Question: 100% + COURSE You should work individual for this assignment. Create a new SOI. script file using Notepad or Notepad++) and save it as Lab3xxxx.sql
100% + COURSE You should work individual for this assignment. Create a new SOI. script file using Notepad or Notepad++) and save it as Lab3xxxx.sql (where xxxx is your last name name). Write your full name on the first page of the script file. Where required, write your answers in this script file. You need to submit only this script file Tasks: Considering the following E-R diagram, your task is to write SQL statements to create the corresponding relations and capture as many of the constraints as possible. It cannot capture some constraints, explain why. Make sure that the data type and size for each attribute are appropriate 1 N Professor Teachers De 11 credit Students Enrolls Courses 100 re Sot point welche Gralineategories GradingSchema GradingActivities Cicle HAN RE O $ E Prisen Home Evd pl 3 % 5 & 7 6 8 R. Y U CLUDE You should work individual for this assignment. Create a new SQL script file using Notepad or Notepad++) and save it as Lab3xxxx.sql (where xxxx is your last name name). Write your full name on the first page of the script file. Where required, write your answers in this script file. You need to submit only this script file. Tasks: Considering the following E-R diagram, your task is to write SQL statements to create the corresponding relations and capture as many of the constraints as possible. If cannot capture some constraints, explain why. Make sure that the data type and size for each attribute are appropriate. name EN D email Professor N Teaches section No number semester ID credit Hry id Students Enrolls title Courses name email dob courseGrade S pa language has uses Submit point category weight M Grading Categories Grading Schema U letter Grade Grading Activities title max Point
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
