Question: Write an SQL script to build a table. Call the script spCreateTable() it should accept one argument, a varchar called subjectOfTable. subjectOfTable is a varchar

Write an SQL script to build a table.

Call the script spCreateTable() it should accept one argument, a varchar called subjectOfTable.

subjectOfTable is a varchar containing the subject of the table. Some examples are example Employee or Formula. Your script will use that subject to build the table name, primary key, and natural key.

For example, given Employee as the subject, your script will build a table called tEmployee with a surrogate key called EmployeeID and a natural key called Employee. Be sure to create the necessary constraints for the keys.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!