[solved]-Need Help Database Assignment Assignment Create Database Let S Wreck Em Driving School Usi Q39088374
I need in help in Database assignment.!!
In this assignment you will create a database for the Let’sWreck ‘Em Driving School. Using the attached pdf with the providedERD and business rules, create the database and attach the mdf file(not the script file) to this assignment. You will needto detach your database before you can copy the .mdf file.
Let’s Wreck ‘Em Driving School Vehicle Student Enrolled Certifications Is StudentID AwardID CertlD VehiclelD Apply to Enrolls Awarded Fname StudentID CertName Vtype Engine Weight CertLength Desciption Lname CertID DLState CertDate Street VehiclelD #Wheels City ZIP Phone Business Rules: The “Let’s Wreck ‘Em Driving School accepts all students regardless of Driving ability or arrest record. Students may gain a certification on any number of vehicles Students do not have to have any certifications (They just need money to pay the tuition!) A Vehicle can be on only one certification, but does not have to be on any certifications Each Award can belong to one and only one Student and Vehicle 1 2 3. 4 (CertLength is number of months like 24 or 36) (Weight is number of pounds like 10,000) (NumberWheels is just that) When you create your database, you will need to add an attribute to the child table from the parent tables for the foreign key. Remember you do not normally show foreign keys on the ERD, but you need them to create relationships in SQL. I show them in the table mockups below) Student Table (tblStudent) Phone Zip Char (5) City VarChar (50) Lname DLState Street Fname State StudentID Char (10) VarChar (50) VarChar (50) VarChar (50) Not Null Char (2) Char (2) Int PK Not Null Not Null. Cert Table (tblCert) CertName CertLength Description Vehicle|D VarChar (50) Not Null CertID Int FK VarChar (50) Int Int PK Not Null Vehicle Table tblVehicle Weight NumberWheels VehiclelD Engine Vtype VarChar (50) VarChar (50) Int Int PK Int Intersection Table tblEnrolled StudentID CertID CertDate AwardID Date Int FK Int FK Int PK Not Null Not Null Not Null Show transcribed image text Let’s Wreck ‘Em Driving School Vehicle Student Enrolled Certifications Is StudentID AwardID CertlD VehiclelD Apply to Enrolls Awarded Fname StudentID CertName Vtype Engine Weight CertLength Desciption Lname CertID DLState CertDate Street VehiclelD #Wheels City ZIP Phone
Business Rules: The “Let’s Wreck ‘Em Driving School accepts all students regardless of Driving ability or arrest record. Students may gain a certification on any number of vehicles Students do not have to have any certifications (They just need money to pay the tuition!) A Vehicle can be on only one certification, but does not have to be on any certifications Each Award can belong to one and only one Student and Vehicle 1 2 3. 4 (CertLength is number of months like 24 or 36) (Weight is number of pounds like 10,000) (NumberWheels is just that) When you create your database, you will need to add an attribute to the child table from the parent tables for the foreign key. Remember you do not normally show foreign keys on the ERD, but you need them to create relationships in SQL. I show them in the table mockups below) Student Table (tblStudent) Phone Zip Char (5) City VarChar (50) Lname DLState Street Fname State StudentID Char (10) VarChar (50) VarChar (50) VarChar (50) Not Null Char (2) Char (2) Int PK Not Null Not Null. Cert Table (tblCert) CertName CertLength Description Vehicle|D VarChar (50) Not Null CertID Int FK VarChar (50) Int Int PK Not Null Vehicle Table tblVehicle Weight NumberWheels VehiclelD Engine Vtype VarChar (50) VarChar (50) Int Int PK Int Intersection Table tblEnrolled StudentID CertID CertDate AwardID Date Int FK Int FK Int PK Not Null Not Null Not Null
Expert Answer
Answer to I need in help in Database assignment.!! In this assignment you will create a database for the Let’s Wreck ‘Em Driving S… . . .
OR
