[solved]-Work Individual Assignment Create New Sql Script File Using Notepad Notepad Save Lab5xxxxs Q39051176
You should work individual for this assignment. Create a new SQL script file using Notepad or Notepad++) and save it as Lab5xxxx.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. For example, a numerical data type is a better choice than a string data type for the attribute salary. made Yd (rez Num color Cars (noDrs – horsePwmpg capacity numbe models Cars N belongs price certified ID salary Technicians name ssn Make sure your SQL script file can be run successfully in MySQL before submitting it. If it can’t be run, your grade of this assignment will be a ZERO. If your file can be run without error messages, the maximum possible points for each portion are listed below: Create Tables Constraints 90 points 10 points Show transcribed image text You should work individual for this assignment. Create a new SQL script file using Notepad or Notepad++) and save it as Lab5xxxx.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. For example, a numerical data type is a better choice than a string data type for the attribute salary. made Yd (rez Num color Cars (noDrs – horsePwmpg capacity numbe models Cars N belongs price certified ID salary Technicians name ssn Make sure your SQL script file can be run successfully in MySQL before submitting it. If it can’t be run, your grade of this assignment will be a ZERO. If your file can be run without error messages, the maximum possible points for each portion are listed below: Create Tables Constraints 90 points 10 points
Expert Answer
Answer to You should work individual for this assignment. Create a new SQL script file using Notepad or Notepad++) and save it as … . . .
OR
