Do the steps below in microsoft SQL server management studio. -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.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Do the steps below in microsoft SQL server management studio. -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.

Expert Solution