50.1K

Verified Solution

Link Copied!

IN-CLASS ACTIVITY--ACC3260 CAR RENTAL BUSINESS RESERVATION/CHECK-OUT SYSTEM John Doe, one of your close friends, is going to set up a small car rental business next to WSU campus. John just started his business and he did not hire anyone yet. Knowing you are learning "Data Modeling" in Acc3260 this semester, John told you to design a car reservation system for him. The system will handle all the reservations and checkouts for his daily operations (& no other information at this point). Please use an E-R diagram (or any method you prefer) to represent this car reservation database system. You need to define all relevant entities, attributes, and cardinality to earn the credit.

REQUIREMENTS Draw an E-R diagram (or define t.database files) to represent the car reservation system. You need to define all relevant entities, attributes, and cardinality to earn the credit. ( I HAVE ALREADY DONE MOST OF THE WORK, BUT YOU JUST NEED TO DEFINE THE LEFT CARDINALITIES, LIKE reservation is used car 1:1 , but what is car is used reservation ? )

- PK - - FK CAR RENTAL + 1) Car (object) - VIN , LIC#, make, model, year, mileage, color, (M) of doors, last oil change, last tive rotation, Condition remark, last rental date ... 2) customer (people) - Cust # name, contact, cc# email, phone, address, special terms , balance last rental at 3) Reservation (event) - Resut, cust #, VN, P-date, s- time, (T) R- time, special needs, special offers, est amt 4) Check-out (Events) - Contract # cust # VIN, Cactual) P-date, P-time , R-dale, R-time, special needs, special offers, est. amt cc# (requined), condition at neturn. 1:1 car used 12 VIN Check out ) show up Reservation cast # make customer 1:)

Answer & Explanation Solved by verified expert

See Answer