create a database using the following entites and attributes: taxi: (taxi_id PK, registration_no, taxi_model, taxi_year, taxi_type, status, driver_id FK); USER: (Usr_id PK, F_name, L_name, Contat_no, Gender, Address, Taxi_id FK); DRIVER: (Driver_id PK, F_name, L_name, Gender, Conatct_no, Rating, Age); TRIP_DETAILS: (Trip_id PK, Trip_date, Trip_amount, Driver_id FK, Usr_id FK, Taxi_id FK , Strt_time, End_time) BILL_DETAILS: (Bill_no PK, Bill_date, Advance_amount, Advance_amount, Total_amount, Usr_id FK, Trip_id FK (unique)) CUSTOMER_SERVICE: (Emp_id PK, F_name, L_name) FEEDBACK: (Fbk_id PK, Message, Email , Emp_id FK (unique), Usr_id FK , Trip_id FK) owns: (Owner_id PK, number of cars) OWNER_TAXI ( Owner_id PK(FK), Taxi_id PK(FK)); INDIVIDUAL (ssn PK, individual name, owner_id FK); TAXI_SERVICE_COMPANY( Tsc_id PK, Tsc_name, Owner_id FK); NOTE: pk= Primary key, fk= foreign key
create a
taxi: (taxi_id PK, registration_no, taxi_model, taxi_year, taxi_type, status, driver_id FK);
USER: (Usr_id PK, F_name, L_name, Contat_no, Gender, Address, Taxi_id FK);
DRIVER: (Driver_id PK, F_name, L_name, Gender, Conatct_no, Rating, Age);
TRIP_DETAILS: (Trip_id PK, Trip_date, Trip_amount, Driver_id FK, Usr_id FK, Taxi_id FK , Strt_time, End_time)
BILL_DETAILS: (Bill_no PK, Bill_date, Advance_amount, Advance_amount, Total_amount, Usr_id FK, Trip_id FK (unique))
CUSTOMER_SERVICE: (Emp_id PK, F_name, L_name)
FEEDBACK: (Fbk_id PK, Message, Email , Emp_id FK (unique), Usr_id FK , Trip_id FK)
owns: (Owner_id PK, number of cars)
OWNER_TAXI ( Owner_id PK(FK), Taxi_id PK(FK));
INDIVIDUAL (ssn PK, individual name, owner_id FK);
TAXI_SERVICE_COMPANY( Tsc_id PK, Tsc_name, Owner_id FK);
NOTE: pk= Primary key, fk= foreign key
Step by step
Solved in 2 steps
