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, 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
Get step-by-step solutions from verified subject matter experts
