such as: customer ID first name last name telephone number credit card data The third table should contain the bookings data, such as: booking ID car ID customer ID pick-up date drop-off date total cost Please note that you can create more tables as well as add more data fields, if necessary. Your program should contain multiple Windows forms as follows: The first form will enable the user to search for a car rental. If a car rental is selected, the second form may provide more into about the car that has been selected, including the car description and pi

Design a "Car Rental" Visual C# application, which allows the user to search for and book a car rental. It is required to create a database file that contains at least three related tables, the first of which contains the cars data with the data fields, such as: car ID car type car model quantity on stock cost per day Make up at least five records in the first table and save your database file in the default folder of your project. The second table should contain the customer information, such as: customer ID first name last name telephone number credit card data The third table should contain the bookings data, such as: booking ID car ID customer ID pick-up date drop-off date total cost Please note that you can create more tables as well as add more data fields, if necessary. Your program should contain multiple Windows forms as follows: The first form will enable the user to search for a car rental. If a car rental is selected, the second form may provide more into about the car that has been selected, including the car description and picture(s). This form will also enable the user to book the selected car or return to the previous form and search for another car. If the user confirms the booking, the third form will be shown to get the customer data and process the customer's order. This form or another form will also display a receipt, which contains the customer info and car/booking info, as well as the total cost including all taxes. Please note that when a customer's booking is processed the database file has to be updated, i.e., new records

Please give codes for the forms and how to set up the connections.