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 info 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 retu 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

Programming Logic & Design Comprehensive
9th Edition
ISBN:9781337669405
Author:FARRELL
Publisher:FARRELL
Chapter6: Arrays
Section: Chapter Questions
Problem 11PE
icon
Related questions
Question
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 info 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
Transcribed Image Text: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 info 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
added into the second and third tables, as well as the quantity on stock updated
in the first table.
It is required to use exception handling to prevent a variety of possible run-time errors.
It is also required to create the project documentation that includes:
1. User manual, i.e. info how to use your application
2. Screen captures of all forms with sample I/O and the source code of each form's
class
3. Screen captures of your database tables, including sample data
Transcribed Image Text:added into the second and third tables, as well as the quantity on stock updated in the first table. It is required to use exception handling to prevent a variety of possible run-time errors. It is also required to create the project documentation that includes: 1. User manual, i.e. info how to use your application 2. Screen captures of all forms with sample I/O and the source code of each form's class 3. Screen captures of your database tables, including sample data
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Data Binding
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning