Review the logical data model above. (see the attachment) Create a Physical Data implementation. Assume that there are approximately 25,000 students and that each student can enroll in three to five...

1 answer below »

Review the logical data model above. (see the attachment)
Create a Physical Data implementation. Assume that there are approximately 25,000 students and that each student can enroll in three to five courses per semester.
The most common query requirement is that students be able to create their course schedules.
Task: Create sample DDL statements to implement a basic physical design.

What to Submit
1.A single SQL file with all queries
Naming convention of all files: firstnameLastname_Module4Assignment.fileextension (.sql)

module4-elmz0vdg.png

Answered Same DayFeb 22, 2021

Answer To: Review the logical data model above. (see the attachment) Create a Physical Data implementation....

Deepti answered on Feb 22 2021

133 Votes

/*
This file contains the basic physical design of tables Student, Course, Major and Enrollment.
All the constraints are specified. A composite primary key is specified in table Enrollment.
*/
CREATE TABLE Major
(
MajorID integer NOT NULL PRIMARY KEY,
Major varchar(100)
);
CREATE TABLE Student
(
StudentID int NOT NULL PRIMARY KEY, /*Data Type can hold values from -32768 to +32768 thus allowing 25000 student...

SOLUTION.PDF

Review the logical data model above. (see the attachment) Create a Physical Data implementation. Assume that there are approximately 25,000 students and that each student can enroll in three to five...

Answer To: Review the logical data model above. (see the attachment) Create a Physical Data implementation....

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment