Question: 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

 Instructions: In SQL Server, create a new database called University. Given
the ERD in this document, write the CREATE TABLE statements to construct

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 nulla constraints in your statements where appropriate. To receive full credit for this assignment, your CREATE TABLE statements must be executed in SQL Server. In the space provided below the ERD, type your CREATE TABLE statements. Then, in SOL Server, after you execute each CREATE TABLE statement, issue these two statements: SELECT FROM [table namel exec sp.help (table name). Note: exec sp help (table name] is a built-in stored procedure that you run to easily see your table structure, including fieldnames, data types, primary keys, foreign key constraints, etc. It's a very useful tool Take a screen shot of your queries and their results and paste the screenshot below each CREATE TABLE statement. Put each table on a separate page of this document. ERD for the University database ZipCodes Buldings ht Campuses Cly State Abbe Faculty Officer bo Butte Address Buildingham > --Belong to-- -House Carro CampusName Officember Worlat LNein Clasa Rooms Facine Faculty Eacity FirstName Lastame Address Rank Salary Speciaty Bemut Occupancy 15 + Teach Taughtin Students dent AdV Sections Courses Add Phone htte Large Sectomber DO CAR Course Prati Courselber Cowlane Start Bate real Ode

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!