Please write the normalization table, the relational table and the data dictionaries based on ERD 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 has User Role PK PK may be id roleld id title name description has address email DOB may be manage Passenger Permission id | PK id PK Car Driver title id id PK PK roleID FK name password mobile address email name number ownerID FK description module password mobile email address username type description category username has Booking Carroute id PK id FK name FK carid PassengerID type ticket type deescription description title date Permission Class Role Class Passenger Class role_idint trole titlestring role description string permission id; int permission_role_d.int *permission title: string permission module string permission description string *passenger_idint *passenger name: string passenger mobile: string passenger address: String passenger_erial string passenger_password. string *passenger username: string addrolell #edit Rolell delere Role +SearchRole) assignole addPermission editPermission) deletePermission +SearchPermission) addPassenger) +edieassenger) deletePassenger search Passenger User Class Drivers Class user id:int user role_id: In Username string -user email string user dab: date uter address: string drivers id int drivars namo string drivers mobile: string drivers address string drivers email: string drivers password: string -drivers username string addUser edit User deleteUser) searchuset Booking Class addDrivers edit Drivers delete Drivers search Drivers Car Class booking id:int booking title: string booking description string booking type string + booking ticket: string booking date: date Car Houtes Class +car id: int car_number: String car_type: string car_category: string *car_description: string car owner Id: in *car_route Id: int car_route_type: string car route description: string car_route_name: string add Booking +editBooking) delete Booking!) +SearchBooking +addCard redit Card) deleteCara) Search Card) addCar Routes) +edit Car Routes!) deleteCar Routes) searchCarRoutes UML Rent-a-car System
