Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beyond Big Data Using Social MDM To Drive Deep Customer Insight

Authors: Martin Oberhofer, Eberhard Hechler

1st Edition

0133509796, 9780133509793

More Books

Students also viewed these Databases questions

Question

4. What decision would you make and why?

Answered: 1 week ago