1.You need to analyze the object and information structure in the given scenario and perform the following tasks: Identify the primary classes and their relationships. The primary classes should model the car categories, cars, bookings, and drivers. Create the primary classes with their required fields and methods.
2.Once the primary classes are created, you need to perform the following tasks: Create the database tables in Derby and populate the tables with the sample data. The following figure shows the structures of the tables that you need to create.
The Structure of the Tables
Implement the following classes that use JDBC to interact with the database tables: Implement a class that inserts the record of a car booking into the BOOKING table. Implement a class that inserts the driver and car assignment records for a booking into the ASSIGNMENT table. Implement a class that queries the database tables to retrieve booking records based on client name, driver name, and travel date.
3.After creating the JDBC classes, you need to implement the customer payment module of the application. To implement this module, you will need to perform the following tasks: Create a class to model a customer payment file. Create a class that manages customer payments by implementing the following functions: The class should create a customer payment file of a driver on the file system in the following directory structure format:
EarnestCabs/<Car Category>/<driver ID>.txt
In the preceding format: <Car Category>: Represents the category of a car, such as Economy, Standard, and Premium. <driver ID>: Represents the unique identifier of a driver.
For adding information about customer payments, the class should search the file system for the customer payment file of the driver and add data to it. For querying customer payments, the class should search the file system for the customer payment file of the driver and display the recorded details.
4.You need to test and debug the application. You need to use the console to input test data and verify the outputs based on the requirement of the system. You also need to validate that the input data conforms to the data format used in the application
2.Once the primary classes are created, you need to perform the following tasks: Create the database tables in Derby and populate the tables with the sample data. The following figure shows the structures of the tables that you need to create.
The Structure of the Tables
Implement the following classes that use JDBC to interact with the database tables: Implement a class that inserts the record of a car booking into the BOOKING table. Implement a class that inserts the driver and car assignment records for a booking into the ASSIGNMENT table. Implement a class that queries the database tables to retrieve booking records based on client name, driver name, and travel date.
3.After creating the JDBC classes, you need to implement the customer payment module of the application. To implement this module, you will need to perform the following tasks: Create a class to model a customer payment file. Create a class that manages customer payments by implementing the following functions: The class should create a customer payment file of a driver on the file system in the following directory structure format:
EarnestCabs/<Car Category>/<driver ID>.txt
In the preceding format: <Car Category>: Represents the category of a car, such as Economy, Standard, and Premium. <driver ID>: Represents the unique identifier of a driver.
For adding information about customer payments, the class should search the file system for the customer payment file of the driver and add data to it. For querying customer payments, the class should search the file system for the customer payment file of the driver and display the recorded details.
4.You need to test and debug the application. You need to use the console to input test data and verify the outputs based on the requirement of the system. You also need to validate that the input data conforms to the data format used in the application
No comments:
Post a Comment