Question: 3. Using the data information provided in the next 3 slides, implement the schema using Transact SQL (show SQL statements for each table). Implement

3. Using the data information provided in the next 3 slides, implementthe schema using Transact SQL (show SQL statements for each table). Implement

3. Using the data information provided in the next 3 slides, implement the schema using Transact SQL (show SQL statements for each table). Implement the constraints as well. Data information for Question 3 tblLevels O O tblPool O O O O tblStaff O O O O Level - auto increment PK ClassName - text 20 - nulls are not allowed O O Pool - auto increment PK PoolName - text 20 nulls are not allowed Location text 30 StaffID - auto increment PK FirstName text 20 Middlelnitial - text 3 LastName - text 30 Suffix text 3 Salaried - bit PayAmount - numeric Data information for Question 3 tblClasses O LessonIndex - auto increment PK Level Integer FK SectionID - Integer Semester - TinyInt O O O O O O O O O O tblEnrollment O LessonIndex - Integer FK SID - Integer FK (LessonIndex and SID) Primary Key Status - text 30 Charged - bit O AmountPaid numeric O DateEnrolled - datetime O O O Data information for Question 3 O tblStudents O O O Days - text 20 Time - datetime (formatted for time) O Pool - Integer FK Instructor - Integer FK Limit - TinyInt Enrolled - TinyInt Price - numeric O O O SID - auto increment PK FirstName - text 20 Middlelnitial - text 3 LastName - text 30 Suffix - text 3 Birthday - datetime LocalStreet - text 30 LocalCity - text 20

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!