I need you solve this question (Based on the Un-Normalized database table below, create a data model for a Rental Caragency by normalizing them with 2nd and 3rd normal forms.) i need you to complete just like the second image in hand written **Title: Normalization in Database Design****Description:**This educational section explains how to normalize an un-normalized database table for a rental car agency, focusing on the second and third normal forms. **Un-Normalized Database Table:**| Car ID | Car Type | Base Rent | Cust ID | Name | DOB | Age | Cust Address | Date of Booking | Service Name | Service Charge ||--------|----------|-----------|---------|-------|-------|-----|---------------|----------------|--------------|----------------|| 501 | Sedan | $40 | 10001 | John | 1/8/80| 34 | 300 Main St | 4/22/14 | GPS | $15.00 || 501 | Sedan | $40 | 10001 | John | 1/8/80| 34 | 300 Main St | 4/22/14 | EzPass | $10.00 || 501 | Sedan | $40 | 10001 | John | 1/8/80| 34 | 300 Main St | 4/22/14 | Full tank | $40.00 || 502 | SUV | $60 | 10001 | John | 1/8/80| 34 | 300 Main St | 3/15/13 | GPS | $15.00 || 502 | SUV | $60 | 10001 | John | 1/8/80| 34 | 300 Main St | 3/15/13 | Bluetooth | $30.00 || 501 | Sedan | $40 | 10002 | Jill | 4/15/74| 40 | 123 Wall St | 4/20/14 | Moon Roof | $15.00 || 501 | Sedan | $40 | 10002 | Jill | 4/15/74| 40 | 123 Wall St | 4/20/14 | Leather Seats| $20.00 |**Explanation:**The table contains columns including Car The handwritten note appears to outline a database schema with primary and foreign keys to reference various entities related to a project management system. Below is the transcription of the text:1. **PK: Projcode + EmpNo**2. **Project (Projcode (PK), ProjectName, ProjectMgr, ProjectBudget)** - **Employee (EmpNo (PK), EmployeeName, DeptNo, DeptName, HourlyRate)** - **EmpProject (Projcode (FK), EmpNo (FK))**3. **Dept (DeptNo (PK), DeptName)** - **Employee (EmpNo (PK), EmployeeName, DeptNo, HourlyRate)** - **PM (PMID (PK), PMName)** - **Project (Projcode (PK), ProjName, PMID, ProjectBudget)** - **EmpProject (Projcode (FK), EmpNo (FK))**### Explanation:1. **Primary Key (PK):** - The primary key is a unique identifier for records in a database. In this context, it is a combination of `Projcode` and `EmpNo`.2. **Project Entity:** - Holds information about various projects with attributes like `Projcode` for project code, `ProjectName` for the name of the project, `ProjectMgr` for the manager, and `ProjectBudget` for the budget.3. **Employee Entity:** - Contains details about employees such as `EmpNo` for employee number, `EmployeeName`, `DeptNo` and `DeptName` for department details, and `HourlyRate`.4. **EmpProject Entity:** - A junction table that relates employees to projects using foreign keys: `Projcode (FK)` and `EmpNo (FK)`.5. **Department (Dept) Entity:** - Describes departments with `DeptNo` and `DeptName`.6. **PM (Project Manager) Entity:** - Represents project managers with `PMID` for ID and `PMName` for name.7. **Additional Notes:** - Some entities are repeated within different contexts to illustrate multiple relationships, like `Project` and `Employee`.The handwritten structure outlines relationships between projects, employees, departments, and project managers, exemplifying a typical relational database design approach.

The question asks to normalize an un-normalized database table representing a Rental Car agency into 2nd and 3rd normal forms. The goal is to create separate tables with appropriate relationships, ensuring data integrity using primary and foreign keysTo normalize the given un-normalized table into 2nd and 3rd normal forms, we need to identify functional dependencies and separate them into distinct tables.Here's the given table: Car ID "Car Type" "Base Rent" "Cust ID" "Name" "DOB" "Age" "Cust Address" "Date of Booking" "Service Name" "Service Charge"501 Sedan $4010001 John 1/8/80 34 "300 Main St" 4/22/14 GPS $15.00501 Sedan $4010001 John 1/8/80 34 "300 Main St" 4/22/14 EzPass $10.00501 Sedan $4010001 John 1/8/80 34 "300 Main St" 4/22/14 Full tank $40.00502 SUV $6010001 John 1/8/80 34 "300 Main St" 3/15/13 GPS $15.00502 SUV $6010001 John 1/8/80 34 "300 Main St" 3/15/13 Bluetooth $30.00501 Sedan $4010002 Jill 4/15/74 40 "123 Wall St" 4/20/14 Moon Roof $15.00501 Sedan $4010002 Jill 4/15/74 40 "123 Wall St" 4/20/14 Leather Seats $20.00Now, let's identify the functional dependencies:Car ID -> Car Type, Base RentCust ID -> Name, DOB, Age, Cust Address(Car ID, Date of Booking) -> Service Name, Service ChargeNow, let's create separate tables for each functional dependency.Table 1: Car Car ID "Car Type" "Base Rent"501 Sedan $40502 SUV $60Table 2: Customer Cust ID "Name" "DOB" "Age" "Cust Address"10001 John 1/8/80 34 "300 Main St"10002 Jill 4/15/74 40 "123 Wall St"Table 3: Booking Car ID "Date of Booking" "Service Name" "Service Charge"501 4/22/14 GPS $15.00501 4/22/14 EzPass $10.00501 4/22/14 Full tank $40.00502 3/15/13 GPS $15.00502 3/15/13 Bluetooth $30.00501 4/20/14 Moon Roof $15.00501 4/20/14 Leather Seats $20.00This decomposition ensures that the database is in 2nd and 3rd normal forms, and there are no partial dependencies or transitive dependencies in the tablesLet's identify the primary keys and foreign keys in the tables:Table 1: CarPrimary Key: "Car ID"Table 2: CustomerPrimary Key: "Cust ID"Table 3: BookingPrimary Key: ("Car ID", "Date of Booking")Foreign Keys:"Car ID" references "Car"("Car ID")"Cust ID" references "Customer"("Cust ID")The relationships are as follows:The "Car ID" in the Booking table is a foreign key that references the "Car ID" in the Car table.The "Cust ID" in the Booking table is a foreign key that references the "Cust ID" in the Customer table.These relationships maintain the integrity of the data by ensuring that the values in the foreign key columns (in the Booking table) correspond to existing values in the referenced primary key columns (in the Car and Customer tables)Identify Functional Dependencies:Car ID -> Car Type, Base RentCust ID -> Name, DOB, Age, Cust Address(Car ID, Date of Booking) -> Service Name, Service ChargeCreate Normalized Tables:Car (Primary Key: Car ID):Car ID, Car Type, Base RentCustomer (Primary Key: Cust ID):Cust ID, Name, DOB, Age, Cust AddressBooking (Primary Key: Car ID + Date of Booking, Foreign Keys: Car ID references Car(Car ID), Cust ID references Customer(Cust ID)):Car ID, Date of Booking, Service Name, Service ChargeEnsure Data Integrity with Primary and Foreign Keys.This process transforms the un-normalized data into normalized tables while maintaining relationships between them through primary and foreign keys for a Rental Car Agency