In this project, you will design and implement a database for keeping track of information about a car rental company. Y

[answerhappygod]

In This Project You Will Design And Implement A Database For Keeping Track Of Information About A Car Rental Company Y 1 (80.6 KiB) Viewed 40 times

In This Project You Will Design And Implement A Database For Keeping Track Of Information About A Car Rental Company Y 2 (74.3 KiB) Viewed 40 times

In This Project You Will Design And Implement A Database For Keeping Track Of Information About A Car Rental Company Y 3 (58.07 KiB) Viewed 40 times

In this project, you will design and implement a database for keeping track of information about a car rental company. You will first design an EER schema diagram for this database application. Then, you will map the EER schema into a relational database schema and implement it on MYSQL Finally, you will load some data into your database, and create some queries and update transactions Assume that the following requirements were collected for this application: 1. The database keep track of CUSTOMERS. Each CUSTOMER has a unique IdNo (assume this is a unique integer generated by the system for each new CUSTOMER, such as 1,2,3...), a Name (assume this is string consisting of an single initial and Inst name only for simplicity, such as "J Smith" or "R. Wong'), and a Phone (a string of 12 characters such as "817-272-3000) 2 The database keeps track of CARs available for rental, which are categorized based on their type There are six main types: COMPACT, MEDIUM, LARGE, SUV (Sports Utility Vehice). TRUCK, and VAN Each type of car has its own Daily Rate and Weekly Rate (assume all cars of the same type have the same rental rates). For simplicity, we will assume that there is only one rental location. 3. Each CAR has a VehicleID (a unique number for each car - assume it is a number 1001, 1002, 1003, ...). Model (Chevy, Toyota, Ford, .), and Year (2015, 2014, ...) 4. The database will keep track of the current (active) RENTALS as well as scheduled RENTALS of each can The are two types of RENTAL DAILY and WEEKLY. For each DAILY RENTAL, the information kept will include the specific CAR and CUSTOMER as well as the NoOfDays, StartDate, and ReturnDate (the ReturnDate can be calculated from the StartDate and NoOfDays). For each WEEKLY RENTAL, the information kept will include the specific CAR and CUSTOMER as well as the NoOfWeeks, StartDate, and ReturnDate (the ReturnDate can be calculated from the StartDate and NoOfWeeks). Each rental will also have the amount Due for the rental, which is a derived value that can be calculated from the other information 5. The database will also keep track of which cars are available for rental during which periods ho Part 1 You will first design an EER schema diagram based upon the RENTALS database requirements specified above, and create an EER schema diagram and documentation report describing your design choices. As part of this assignment, you should identify any missing or incomplete requirements, and explicitly state them in your documentation. You should also explicitly state any assumptions you made that were not part of the requirements listed above Part 2.1 In this part you will be to map the EER schema design to a relational database schema, and create the tables corresponding to the relational schema using the MySQL. You will add to your report a listing of the CREATE TABLE statements. Specify as many constraints (key, referential integrity as you can in the relational cham Yonhould state the

the tables corresponding to the relational schema using the MySQL You will add to your report a listing of the CREATE TABLE statements. Specify as many constraints (key, referential integrity) as you can in the relational schema. You should state the choices you made during the EER-to-relational mapping, and the reasons for your choices. Part 2.2 h h This part of the project you will load some data into the database, and apply certain update transactions and retrieval queries. You will create your own data. Include at least 10 customers, and at least 20 cars of different types. You have to implement transactions from 1 to 5: The following are the transactions you have to implement for this part of the homework: 1 Load some initial data (as discussed above) into the database tables that you created in Part 21 of the assignment You can either write a loading program, or use SQL (insert command Your data should ! be kept in files so that it can easily be reloaded during debugging. The data format should be designed by you 2. Write queries to retrieve and print all the data you entered. Try to print the data so that it is easy to understand (for example, print appropriate headings, such as Customers Compact Cars, SUVs Current Rentals, etc) Write the following database update transactions using PHP or some other programming language or

This part of the project you will load some data into the database, and apply certain update transactions and retrieval queries. You will create your own data. Include at least 10 customers and at least 20 cars of different types. You have to implement transactions from 1 to 5 The following are the transactions you have to implement for this part of the homework 1. Load some initin data (as discussed above) into the database tables that you created in Part 2.1 of the assignment. You can either write a loading program, or use SQL (insert command. Your data should be kept in files so that it can easily be reloaded during debugging. The data format should be designed by you 2. Wnte queries to retrieve and print all the data you entered. Try to print the data so that it is easy to understand (for example, print appropriate headings, such as Customers, Compact Cars, SUV, Current Rentals, etc) 3. Write the following database update transactions using PHP or some other programming language or scripting language 31 The first transaction is to add information about a new CUSTOMER 3.2 The second transaction is to add all the information about a new CAR 3.3 The third transaction is to add all the information about a new RENTAL reservation (this must find a free car of the appropriate type for the rental period) 3.4 The fourth transaction is to handle the return of a rented car. This transaction should print the total customer payment due for the rental, and enter it in the database 3.5 The fifth transaction is to enter or update the rental rates (daily and weekly) for a type of car 4. Each transaction should have a user friendly interface to enter the information needed by the transaction. This can either be a Web-based interface or a command line interface. 5. Test your transactions by adding a few new customers, cars, reservations, by changing some rental rates and reservations rates.