Question: create a database implementation on the following relational model in MYSQL : car(car_id, brand, model, color, rental_category, selling_price) Primary Key (PK): car_id customer(customer_id, name, date_of_birth)
create a database implementation on the following relational model in MYSQL :
car(car_id, brand, model, color, rental_category, selling_price) Primary Key (PK): car_id customer(customer_id, name, date_of_birth) PK: customer_id registered(customer_id, license_number, loyalty_points) PK: customer_id registered_tel(customer_id, number) PK: customer_id, number buy(customer_id,car_id, date, cc_number, cc_expiry_date, cc_security_code) PK: customer_id, car_id, date rent(customer_id, car_id, rental_date, return_date) PK: customer_id, car_id, rental_date Foreign keys: registered: customer_id is a foreign key referencing customer. customer_id registered_tel: customer_id is a foreign key referencing customer. customer_id buy: customer_id is a foreign key referencing customer. customer_id car_id is a foreign key referencing car.car_id rent: customer_id is a foreign key referencing customer. customer_id car_id is a foreign key referencing car.car_id
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
