3. Ensure that the Foreign Key referencing across the...

3. Ensure that the Foreign Key referencing across the Relational Tables have been applied. 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

Thanks for your feedback!

Use the CREATE SQL command to do the following: (3 marks) 1. Create all the tables in the below "University" schema. (Note: all of the attributes must have the right data type) 2. Identify the column or the group of columns in the tables that must be unique across all rows in the table. 3. Ensure that the Foreign Key referencing across the Relational Tables have been applied. - Use the ALTER SQL command to add an additional column named "Student_email" with the constraint not null. (1 mark) - Use the ALTER SQL command to apply the following constraints: (1.5 marks) 1. Course.Course_name - should be not null. 2. Section.Year - should be greater than 2000. 3. Course.Credit_hours - should be greater than zero. - Use the INSERT SQL command to do the following: (1.5 marks) 1. Insert at least 1 record into each table. - Use the SELECT SQL command to get the results shown for each query: (3 marks) 1. List of students' names and their IDs for the major "Computer Science". 2. List of all students' information and their sections' information for the Fall 2020 semester. 3. List of courses' names and their prerequisite course names. Ensure that the Foreign Key referencing across the Relational Tables have been applied. STUDENT Name Student_ID COURSE Columbia Course_number Credit_hours Department PREREQUISITE Course_number Prerequisite_number SECTION Section_number Course_number Semester Instructor GRADE_REPORT Student_number Grade Earned

Play audio

Feedback

Question

Please give Ace some feedback