urgent plss

A car rental company wants to digitize the management process. The company has a number of vehicles that are characterized by ID, license plate, model, year of production, maximum number of pre-chargers, type of engine (diesel, gasoline, hybrid, etc.), type of gearbox (manual or automatic). as well as the current number of kilometers of the vehicle. Each vehicle is insured with an insurance company. Depending on the prices and offers that insurance companies have available, vehicles can be insured by different companies. For each vehicle, the company has a list of insurances in years which is characterized by the name of the company, the insurance, the start date, the end date and the cost of the insurance. Customers who want to rent a vehicle must register in the system. The data that customers must provide are: first name, last name, date of birth, personal identification number, email and phone number. For each rental, the company stores the date, time and place of withdrawal from the customer and the date, time and place of delivery of the vehicle. Among other things, notes on the condition of the vehicle on delivery or the moments of towing can be saved i) Using the business rules described above, write the relational schema in INF, identify all keys and primary dependencies including all partial and transitive dependencies. (3 marks) ii) Using the answer to i) remove all partial dependencies and write the relational schema in 2NF, identifying all keys and primary dependencies in each case. (3 marks) iii) Using the answer to ii) remove all transitive dependencies and write 3NF relational (3 marks) schema in iv) Using the results of iii) draw the Entity Relationship Diagram based on Chen's Notation. (3 marks) v) Using the results of iii) draw the Entity Relationship Diagram based on Crow's Foot Notation, identifying primary, foreign keys, cardinality and ordinality of the relationships. (3 points)

whicle in delivory or withdraw moments cim be saved. Keys and dependencies ines described above write the relational schema in INF, identify all primary ii) Using the answer to i) remove all partial dependencies and partial and transitive dependencies. (3 points) oy identifying in each case all primary keys and dependencies and write the relational schema in 2NF, Using the answer to ii) remove all transitive dependencies and write the relational schema in (3 points) (s) the results of iii) draw the Entity Relationship Diagram based on Chen's Notation. the results of iii) draw the Entity Relationship Diagram based on Crow's Foot Notation, g the primary, forcign keys, the cardinality and ordinality of the relationships, (3,p0ints) whicle in delivory or withdraw moments cim be saved. Keys and dependencies ines described above write the relational schema in INF, identify all primary ii) Using the answer to i) remove all partial dependencies and partial and transitive dependencies. (3 points) oy identifying in each case all primary keys and dependencies and write the relational schema in 2NF, Using the answer to ii) remove all transitive dependencies and write the relational schema in (3 points) (s) the results of iii) draw the Entity Relationship Diagram based on Chen's Notation. the results of iii) draw the Entity Relationship Diagram based on Crow's Foot Notation, g the primary, forcign keys, the cardinality and ordinality of the relationships, (3,p0ints)