Question
(a) Use the Structured Query Language to create enroll table with proper primary key, foreign key, and according to the following constraints. Assumptions: the student
(a) Use the Structured Query Language to create enroll table with proper primary key, foreign key, and according to the following constraints. Assumptions: the student table and course table have been already created for the database. (1) student# must be defined as an integer and existed in the student table; (2) course# must be defined as a small integer and a value in the course table; (3) semesterdate has a default value of fall 2015; (4) grade has to be equal to a value of A, or B, or C, or D, or F or W; (5) a student cannot enroll in the same class twice and/or more than 5 classes in the same semester; and (6) any course can only have up to 50 students enrolled in the course.
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