Consider the database shown below ,Whose schema is also shown below .What are the referential integrity constraints that should hold on the schema ? Write appropriate $SQL$ $DDL$ statements to define database
DATABASE
STUDENT |
NAME |
Student_number |
Class |
Major |
Smith |
17 |
1 |
CS |
Brown |
8 |
2 |
CS |
COURSE |
Course_name |
Course_number |
Credit_hours |
Department |
Intro to Computer Science |
CS1310 |
4 |
CS |
Data Structures |
CS3320 |
4 |
CS |
Discrete Mathematics |
MATH2410 |
3 |
MATH |
Databases |
CS3380 |
3 |
CS |
SECTIONS |
Section_identifier |
Course_number |
Semester |
Year |
Instructor |
85 |
MATH2410 |
Fall |
07 |
King |
92 |
CS1310 |
Fall |
07 |
Anderson |
102 |
CS3320 |
Spring |
08 |
Knuth |
112 |
MATH2410 |
Fall |
08 |
Chang |
119 |
CS1310 |
Fall |
08 |
Anderson |
135 |
CS3380 |
Fall |
08 |
Stone |
GRADE_REPORT |
Student_number |
Section_identifier |
Grade |
17 |
112 |
B |
17 |
119 |
C |
8 |
85 |
A |
8 |
92 |
A |
8 |
102 |
B |
8 |
135 |
A |
PREREQUISITE |
Course_number |
Prerequisite_number |
CS3380 |
CS3320 |
CS3380 |
MATH2410 |
CS3320 |
CS1310 |
SCHEMA
STUDENT |
Name |
Student_number |
Class |
Major |
COURSE |
Course_name |
Course_number |
Credit_hours |
Department |
PREREQUISITE |
Course_number |
Prerequisite_number |
SECTION |
Section_identifier |
Course_number |
Semester |
year |
Instructor |
GRADE_REPORT |
Student_number |
Section_identifier |
Grade |