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 the space provided below the ERD, type your CREATE TABLE statements.  Then, in SQL Server, after you execute each CREATE TABLE statement, issue these two statements:

SELECT * FROM [table name]

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.

To illustrate, the Campuses table has been created for you on the page following the ERD and Narrative Description section.

NEED ASSIGNMENT HELP?

We guarantee plagiarism-free and AI-free writing services. Every assignment is crafted with originality, precision, and care to meet your academic needs.

Ready to get started? Place your order directly on this post!

Let us help you achieve excellence—authentic work, every time.