CAR RENTAL COMPANY IdNo CUSTOMER Name Initial LastName RentalID CarType VehicleID Available EndDate StartDate Phone RontedFor...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
CAR RENTAL COMPANY IdNo CUSTOMER Name Initial LastName RentalID CarType VehicleID Available EndDate StartDate Phone RontedFor DAILY RENTAL Model Make Year AVAILABLE CARS New Reservation CAR RENTAL Confirmed WeeklyRate DailyRate CurrentOrScheduled RentalType AmountDue W RontalID WEEKLY RENTAL RentallD StartDate NoOrWeeks ReturnDate NoOfDate StartDate ReturnDate 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 schema. You should state the choices you made during the EER-to-relational mapping, and the reasons for your choices. Part 2.2 1 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: 1. The following are the transactions you have to implement for this part of the homework: Load some initial 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. 3. 4. 5. 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 scripting language. 3.1 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. 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. Test your transactions by adding a few new customers, cars, reservations, by changing some rental rates and reservations rates. Part 2 a. b. For part 2.1, what you turn in should include your relational schema diagram design and your CREATE table statements, and documentation describing your EER-to-relational mapping choices. For part 2.2, submit the implementation of part 2.2 using PHP or any other programming language. Source code of all your transactions should be submitted, as well as the data files. CAR RENTAL COMPANY IdNo CUSTOMER Name Initial LastName RentalID CarType VehicleID Available EndDate StartDate Phone RontedFor DAILY RENTAL Model Make Year AVAILABLE CARS New Reservation CAR RENTAL Confirmed WeeklyRate DailyRate CurrentOrScheduled RentalType AmountDue W RontalID WEEKLY RENTAL RentallD StartDate NoOrWeeks ReturnDate NoOfDate StartDate ReturnDate 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 schema. You should state the choices you made during the EER-to-relational mapping, and the reasons for your choices. Part 2.2 1 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: 1. The following are the transactions you have to implement for this part of the homework: Load some initial 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. 3. 4. 5. 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 scripting language. 3.1 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. 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. Test your transactions by adding a few new customers, cars, reservations, by changing some rental rates and reservations rates. Part 2 a. b. For part 2.1, what you turn in should include your relational schema diagram design and your CREATE table statements, and documentation describing your EER-to-relational mapping choices. For part 2.2, submit the implementation of part 2.2 using PHP or any other programming language. Source code of all your transactions should be submitted, as well as the data files.
Expert Answer:
Related Book For
Organizational Behaviour Concepts Controversies Applications
ISBN: 978-0132310314
6th Canadian Edition
Authors: Nancy Langton, Stephen P. Robbins, Timothy A. Judge, Katherine Breward
Posted Date:
Students also viewed these databases questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...
-
A manager found the following information for his company: Profit margin = 0.08 and total asset turnover = 1.85. Given that the total assets of the company is $200 million, the total liabilities is...
-
Stellar Stairs Co. designs and builds factory-made premium wooden stairs for homes. The manufactured stair components (spindles, risers, hangers, hand rails) permit installation of stairs of varying...
-
The Timberlake-Jackson Wardrobe Co. has 7 percent coupon bonds on the market with 9 years left to maturity. The bonds make annual payments and have a par value of $1,000. If the bonds currently sell...
-
What kinds of leveling mechanisms are present in currentday capitalist society? Are they effective in reducing economic inequality?
-
The Scampini Supplies Company recently purchased a new delivery truck. The new truck cost $22,500, and it is expected to generate net after-tax operating cash flows, including depreciation , of...
-
EXPLAIN DIFFERENT WAYS IN WHICH YOU CAN PREPARE FOR SPECIFIED ROLES related to HRM?
-
Darcelle teaches skiing at the Snow School. Jack runs a ski shop called Up Hill, Down Hill. Their combined bank interest is $1,000. If they get a refund, they would like the money deposited into...
-
The moment of inertia of a solid sphere (radius R and mass M) about the axis which is radius R and mass M 2 at a distance of (a) 3 -MR 20 M from the centre is (b) MR (c) 13 20 -MR (4) M 10 -MR
-
How much more or less money would you have to invest today to have $7,000 in 5 years at 5.10% compounded monthly instead of 5.26% compounded annually? Express the answer with a positive sign if more...
-
Your assignment is to find a recent article on an HR Law/Regulation that you feel may be the most challenging to manage. 1. Why did you choose this piece of law/legislation? 2. What is it about this...
-
Cookie Cutter Corp. is considering a new project whose data are shown below. The equipment that would be used has a 5-year tax life, would be depreciated by the straight-line method over its 5- year...
-
Meredith Grey has contacted COVID due to her close contact with her patients. Luckily, she has a whole life policy with a death benefit of $1,000,000 and a cash surrender value of $150,000....
-
4. Each of the following definitions and program segments has errors. Rewrite them without errors. a. int x, *ptr; &x=ptr; b. int x, *ptr;B *ptr = &x; c. int x, *ptr; ptr = &x; ptr 100; // Store 100...
-
Let f(x) = (x - a) e". Find the local extreme(maximum and minimum) points, where a eR. a. at x = a - 1 local maximum O b. at x = a + 1 local minimum O c. at x = a - 1 local minimum O d. at x = a + 1...
-
Find the equations of the ellipses satisfying the given conditions. The center of each is at the origin. Passes through (2, 2) and (1, 4)
-
What are the three levels of analysis in our OB model? Are they related? If so, how
-
This care presents a series of emails between a job candidate who seems to have accepted a job offer and then reneged on the acceptance. The exchange of messages has several communication issues from...
-
Why is participation considered such an effective technique for lessening resistance to change?
-
What are the key differences between financing entrepreneurial and established companies?
-
What is the purpose of staged financing?
-
What are the main types of investors that fund entrepreneurial ventures?
Study smarter with the SolutionInn App