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