Question
Data: Stud_SSN Branch_ID Branch_Name Branch_school Stud_Name Stud_Age Stud_Street Stud_Location Stud_Zip School_City School_State School_Zip School_Code Start_Date End_Date 2146589647 20 ITM JSOM,UTD Joseph Marks 20 Jupiter Rd
Data:
| Stud_SSN | Branch_ID | Branch_Name | Branch_school | Stud_Name | Stud_Age | Stud_Street | Stud_Location | Stud_Zip | School_City | School_State | School_Zip | School_Code | Start_Date | End_Date | |
| 2146589647 | 20 | ITM | JSOM,UTD | Joseph Marks | 20 | Jupiter Rd | Allen,TX | 75002 | Richardson | TX | 75080 | 4243 | 1/1/2017 | 12/1/2017 | |
| 2456987412 | 21 | BA | JSOM,UTD | Mary Barnhill | 21 | Campbell Rd | Frisco,TX | 75070 | Richardson | TX | 75080 | 4243 | 1/1/2017 | 12/1/2017 | |
| 4579625879 | 22 | CSC | ERIK,UTD | Elizabeth Smith | 24 | Coit Rd | Dallas,TX | 75253 | Richardson | TX | 75080 | 4243 | 1/1/2017 | 12/1/2017 | |
| 4123658749 | 21 | MECH | ERIK,UTD | Martin Jones | 19 | Pilot Dr | Plano,TX | 75025 | Richardson | TX | 75080 | 4243 | 1/1/2017 | 12/1/2017 | |
| 4578562145 | 38 | NEURO | SOBBS,UTD | Albert Lau | 22 | Spring Valley Rd | Richardson,TX | 75080 | Richardson | TX | 75080 | 4243 | 1/1/2017 | 12/1/2017 | |
| 2146589635 | 20 | ITM | JSOM,UTD | John Lewis | 21 | Pilot Dr | Plano,TX | 75025 | Richardson | TX | 75080 | 4243 | 1/1/2017 | 12/1/2017 | |
| 2146589635 | 38 | MIS | McComb, UTA | John Lewis | 21 | Pilot Dr | Plano,TX | 75025 | Austin | TX | 78712 | 3658 | 12/2/2017 | 1/1/2200 | |
Please make sure the primary keys, foreign keys are mentioned clearly. Any ambiguity could lead to you losing points.
Question 1: (40 points)
The following is the business environment of Enterprise Car Rental. A car is manufactured by one manufacturer only. A manufacturer manufactured at least one of Enterprise's cars. A car could have had many maintenance events (but a brand new car may not have had any, yet.) A car may not have been rented to any customers (again, the case of a brand new car) or to many customers. A customer may have rented many cars from Enterprise, and to be in Enterprise's business environment must have rented at least one. Please draw the ERD for the above business. Include any and all attributes you think are required such as Customer Details, etc.
Convert the ERD to tables and convert the ERD into tables based on the rules discussed in class.
Note: If you are making any assumptions, do mention them explicitly.
Grading Criteria (partial marking will be there):
10 points for all correct create tables
14 points for all correct relationships
8 points to all correct primary keys
8 points if it has all entities
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Management With Website Development Applications
Authors: Greg Riccardi
1st Edition
0201743876, 978-0201743876
