Collage Code Create N M 2 Term COURSES year 1 Have Assignment Assignment no Date/Time Email Name (Affiliation INSTRUCTORS M Email 2 1 Add Students 2 Student ID Works On 3 1 2 Consist of Tasks Grade
Write the SQL code to create the relational schemas from this data base system :
Relationships :
An Instructor can create multiple Courses.
Each Course can have multiple Students.
In a Course, Instructors can create one or more Assignments.
Each Assignment can consist of one or more Tasks.
Attributes:
Instructor: email, affiliation, name
Course: course code, term, year
Student: email, student ID
Assignment: assignment ID, max grade
Task: task ID, max grade
Entities:
Instructor with attributes: email, affiliation, and name.
Course with attributes: course code, term, and year, linked to an Instructor.
Student with attributes: email and student ID.
Assignment with attributes: assignment ID, max grade, linked to a Course.
Task with attributes: task ID and max grade, linked to an Assignment.
Step by step
Solved in 2 steps
