-create Authors and Books relations. -create the tuples of Authors and Books relations. -using T-SQL statements, assign first names of the youngest and the oldest
do these steps in Microsoft SQL Server Management Studio.
*Please copy paste the code and also attach screenshots.
-create Authors and Books relations.
-create the tuples of Authors and Books relations.
-using T-SQL statements, assign first names of the youngest and the oldest
Author into two variables. Display the variable values
-using T-SQL statements, assign first names of Authors whose last name is
the longest and the shortest into two variables. Display the variable values.
-using T-SQL statements, write a program section that calculates and displays sum of numbers starting from 1 to n.
-implement an SP that searches/filters the Authors relation. SP should accept
the following arguments: SSNo (equivalence comparison), First Name
(fuzzy-prefix), Last Name(fuzzy-prefix), DOB (equivalence comparison),
Gender(equivalence comparison), NumberOfPrizesMin (NumberOfPrizes
attribute value of “to be selected tuples” should be greater than or equal to
this value), NumberOfPrizesMax (NumberOfPrizes attribute value of “to be
selected tuples” should be less than or equal to this value). Test your SP
using different actual argument values
-implement an SP that takes a date (date of birth of someone) value as an
argument, and that calculates and displays the age value. Execute this SP
using different date values.
- implement an SP that retrieves first, last names, as well as ages of all
Authors. This SP should make use of the SP you have implemented in
previous step.
Step by step
Solved in 3 steps