Task :
Not all entity requirements are determined at this point,
therefore Q-Car Rental is looking for your expertise in assisting
them with the design. it is important to look at the different
areas to be considered in the design and based on your knowledge to
make reasonable assumptions regarding each area. you will have to
make assumptions to determining the entities, attributes/ columns,
the datatypes, relationships, primary/foriegn key constraints, and
cardinality. your Entity Relationship Diagram ERD has to follow the
rules of Normalization and adhere to 3rd norm form in your
design.
- Task Not All Entity Requirements Are Determined At This Point Therefore Q Car Rental Is Looking For Your Expertise In 1 (280.97 KiB) Viewed 50 times
1. Q-Car Rental Case Study: -50% Consider the following entities and relational model for the Q-Car Rental System. Customer (customer_id, name, address, phone1, vehicle, type, email) • Car (car_id, make, model, daily_cost, mileage, service_mileage_date) Reservation (res_id, start_date, end_date, mileage_start, mileage_end, max_mileage, extra_mileage) RES_1 CUSTOMER CUSTOMER_ID HULBER (5) NAME VARCHAR250 BYTE) ADDRESS VARCHAR2(50 BYTE PHONE VARCHAR2 (20 BYTE) VEHICLE VARCHAR2(50 BYTE) TYPE VARCHAR2(50 BYTE EMAIL VARCHAR2 (50 BYTE > CUST_ID_PK (CUSTOMER_D) RESERVATION NUMBER 5) START_DATE DATE END_DATE DATE MILEAGE_START VARCHAR2 50 BYTE) MILEAGE_END VARCHAR250 BYTE MAX_MILEAGE VARCHAR250 BYTE) EXTRA_MILEAGE VARCHAR250 BYTE) CUSTOMER_ID NUMBER (5) CAR_ID NUMBER (5) >> RES_ID_PK (RES_JD) RES_CAR_ID_FK (GARD) RES_C_ID_FK (CUSTOMER_ID) CAR P. CAR_ID MAKE MODEL DAILY COST MILEAGE SERVICE_MILEAGE_DATE > CAR_ID_PK (CAR_ID) HUMOR (5) VARCHAR2(50 BYTE) VARCHAR200 BYTE NUMBER 5.2 VARCHAR2(50 BYTE DATE create the missing tables Q-Car Rental also tracks information about vehicle servicing, service garage, parts, and car insurance. Q-Car Rental requires a system that will integrate all requirements of the system. You are hired to develop a fully functional logical model (ERD) for Q-Car Rental that can be used to develop the physical model of the system.