Instructions In SQL Server, create a new database called University. Given the ERD in this document, write the CREATE TABLE statements to construct the tables for this database. Be sure to use reasonable data types and create all tables, attributes, primary keys, foreign keys, and “not null” constraints in your statements where appropriate. To receive full credit for this assignment, your CREATE TABLE statements must be executed in SQL Server. In a new Word document, copy the ERD and type your CREATE TABLE statements below the ERD. Then, in SQL Server, after you execute each CREATE TABLE statement, issue these two statements: SELECT * FROM [table name] exec sp_help [table name]
Instructions
In SQL Server, create a new
Given the ERD in this document, write the CREATE TABLE statements to construct the tables for this database. Be sure to use reasonable data types and create all tables, attributes, primary keys, foreign keys, and “not null” constraints in your statements where appropriate.
To receive full credit for this assignment, your CREATE TABLE statements must be executed in SQL Server.
In a new Word document, copy the ERD and type your CREATE TABLE statements below the ERD. Then, in SQL Server, after you execute each CREATE TABLE statement, issue these two statements:
SELECT * FROM [table name]
exec sp_help [table name].
Step by step
Solved in 3 steps with 15 images
What is the difference between step 1 and step 2? I am getting syntax errors when entering in the constraint fk_zipcode foreign key(zipcode) references zipcodes(zipcode) section of step 1. I don't know what the final solution is and what to write into SQL university
by Bartleby Expert
