Question: 1. Please write the normalization table based on database not coding. 2. Please write the relational table based on database not coding. 3. Please write
1. Please write the normalization table based on database not coding.
2. Please write the relational table based on database not coding.
3. Please write the data dictionaries based on database not coding


v rent-a-car system car id : int(11) number: varchar(10) e type : varchar(10) e category : varchar(25) a description : varchar(150) # ownerlD : int(11) v rent-a-car system drivers & id: int(11) e name : varchar(15) @mobile: varchar(12) e address : varchar(100) @email: varchar(50) @password: varchar(25) username : varchar(25) v O rent-a-car system role id: int(11) title : text decription : varchar(100) v O rent-a-car system passenger id: int(11) @name : varchar(15) @mobile : varchar(12) address : varchar(100) @email : varchar(50) e password : varchar(25) e username : varchar(25) v rent-a-car system permission id : int(11) # rolelD : int(11) title : varchar(25) module : varchar(50) description : varchar(150) v rent-a-car system carroute aid: int(11) e type : varchar(30) e description : varchar(100) e name : varchar(25) V O rent-a-car system user & id: int(11) # rolelD : int(11) e name : varchar(15) e address : varchar(100) email: varchar(50) D.O.B : date vo rent-a-car system booking & id : int(11) e title : varchar(15) decription : varchar(100) e type : varchar(15) e ticket : varchar(15) date : date role-id user_role_id user_name user_addres user_email user-id role_title User Has Role user_dob 1 role-description May be Manage Permission May be permission-role-id permission_id permission_title permission_description driver-password permission_module car_category car_type driver_id driver driver-username car_id driver_name car_owner driver-mobile driver_email username password car_description Car driver_address name car_route-id address passenger car_no has mobile id Carroute car_route_type email booking car_route-description booking_title car_id car_route_name booking_description booking_id booking_ticket booking_date passenger_id booking_type
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
