Write the SQL code to create relational schemas in your MySQL database.

Consider a database application which provides a web-based platform where students can practice on tasks assigned by the instructors. In terms of design, following are some major requirements:
• Instructors will first create their accounts. Relevant details for the instructors are: email, affiliation and name.
• Instructors will create Courses and add Students to each course. Relevant details for Courses are: course code, term and year. Relevant details for Students are: email and student ID.
• In Courses, Instructors will create one or more assignment and an assignment will consist of one or more tasks. Each task has a grade.
Students will work on Tasks and Assignments and will be awarded grade based on their submission.

   

Transcribed Image Text:

Course code Term Year Assignment no Create M N COURSES (Date/Time) 1 Have N Email N ASSIGNMENT INSTRUCTORS M Name N Add Consist of 1 N Affiliation STUDENTS N Work on M TASKS Grade Email Student ID Course code Term Year Assignment no Create M N COURSES (Date/Time) 1 Have N Email N ASSIGNMENT INSTRUCTORS M Name N Add Consist of 1 N Affiliation STUDENTS N Work on M TASKS Grade Email Student ID

Answer rating: 100% (QA)

I can provide a verbal description of the EER schema diagram for the given data base application along with my assumption and design choices The EER s... View the full answer