Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1. What are the referential integrity constraints that should hold on the schema? Write appropriate SQL DDL statements to define the database. Figure 2.1 Schema diagram for the database in Figure 1.2 STUDENT Name Silent number Class Major COURSE Course name Course number Credit hours Department PREREQUISITE Course_number Prerequisite_number SECTION Section Identifier Course_number Semester Your Instructor GRADE_REPORT Student number Section identifier Grade Student number Mayor STUDENT Name Smith Brown Department CS COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Database Course_number Credit hours CS1310 CS3320 MATH2410 CS3380 CS MATH CS SECTION Section identifier Course_number 85 MATH2410 92 CS1310 102 C83320 112 MATH2410 CS1310 C$23.00 Semester Fall Fall Spring Fall Year 07 07 08 08 08 Instructor King Anderson Knuth Chang Anderson Stone 119 Fall O COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Database Course number Credit hours Department CS1310 CS CS3320 CS MATH2410 MATH CS3380 13 CS Year Instructor King 07 07 SECTION Section_identifier Course_number Semester 85 MATH2410 Fall 92 CS1310 Fall 102 CS3320 Spring 112 MATH24101 Fall CS1310 Fall 135 CS3380 08 08 Anderson Knuth Chang Anderson Stone 119 08 08 GRADE REPORT Student number 17 Grado Section identifier . 112 119 85 17 92 102 135 PREREQUISITE Course_sumber CS3380 CS3380 C83320 Prerequisite number CS3320 MATH2410 CS1310 stores urse Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1. What are the referential integrity constraints that should hold on the schema? Write appropriate SQL DDL statements to define the database. Figure 2.1 Schema diagram for the database in Figure 1.2 STUDENT Name Silent number Class Major COURSE Course name Course number Credit hours Department PREREQUISITE Course_number Prerequisite_number SECTION Section Identifier Course_number Semester Your Instructor GRADE_REPORT Student number Section identifier Grade Student number Mayor STUDENT Name Smith Brown Department CS COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Database Course_number Credit hours CS1310 CS3320 MATH2410 CS3380 CS MATH CS SECTION Section identifier Course_number 85 MATH2410 92 CS1310 102 C83320 112 MATH2410 CS1310 C$23.00 Semester Fall Fall Spring Fall Year 07 07 08 08 08 Instructor King Anderson Knuth Chang Anderson Stone 119 Fall O COURSE Course_name Intro to Computer Science Data Structures Discrete Mathematics Database Course number Credit hours Department CS1310 CS CS3320 CS MATH2410 MATH CS3380 13 CS Year Instructor King 07 07 SECTION Section_identifier Course_number Semester 85 MATH2410 Fall 92 CS1310 Fall 102 CS3320 Spring 112 MATH24101 Fall CS1310 Fall 135 CS3380 08 08 Anderson Knuth Chang Anderson Stone 119 08 08 GRADE REPORT Student number 17 Grado Section identifier . 112 119 85 17 92 102 135 PREREQUISITE Course_sumber CS3380 CS3380 C83320 Prerequisite number CS3320 MATH2410 CS1310 stores urse
