What are the referential integrity constraints that should hold on the schema? Write the appropriate SQL DDL statements to define the two relations, COURSE, and SECTION, of the database - you don't need to give SQL for all 5 relations.
 

 

Figure 2.1 Schema diagram for the database in Figure 1.2. 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 GRADE REPORT Student_number Section_identifier Grade Year Instructor