Question
I am having problems understanding the ERDs for this exercise, please help me to understand the concept. Instructions: In SQL Server, create a new database
I am having problems understanding the ERDs for this exercise, please help me to understand the concept.
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 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. Its 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.
EXAMPLE How your output should look for each table
Campuses:
CREATE TABLE Campuses
(CampusID int,
CampusName varchar(20),
CONSTRAINT pk_campuses PRIMARY KEY (CampusID))
ZipCodes ZipCode City Buildings BuildinglD Address BuildingName Campuses - -BelongTo FacultyOffices StateAbbr House CampuslD CampusName fficeNu Contain Faculty Liveln FacultylD FirstName ClassRooms FacLive--- Address Rank Salary Specialty Teach Taughtin Mentor Students StudntD FirstName LastName StreetAddress Phone Birthdate Sections Courses CourselD CoursePrefx CourseNumber CourseName Have.-- SectionNumber Term Year StartDateGrade EndDate
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started