Question Details

Answered: - Design Project Assignment The Business Problem Our company


Design Project Assignment

The Business Problem

Our company does car rental business and has several locations with different addresses (address consist of street or rural route with the number, city, state and zip code). The cars are classified as subcompacts, compacts, sedans, or luxury. Each car has a particular make, model, year made, and color. Each car has a unique identification number and a unique license plate. The cars rented in a particular location may be returned to a different location (so called drop off).

For every car we keep the odometer reading before it is rented and after it is returned. Since we trust our customers, we do not record any defects when the car is rented out and returned back. However, we rent the car with a full tank and record the volume of gas in the tank when the car is returned, but we only indicate if the tank is empty, quarter full, half full, three quarters full, or full.

We keep track of which day a car was rented, but not of the time, similarly for car returns. If a customer requests a specific class (say sedan), we may rent the customer a higher-class car if we do not have the requested class in the stock, but we will price it at the level the customer requested (so-called upgrade). Each car class has its own pricing, but all cars in the same class are priced the same. We have rental policies for 1 day, 1 week, 2 weeks, and 1 month. Thus, if a customer rents a car for 8 days, it will be priced as 1 week + 1 day. The drop-off charge only depends on the class of the rented car, the

location it was rented from and the location it is returned to.

About our customers, we keep their names, addresses, all phone numbers, and the number of the driver?s license (we assume a unique license per person). About our employees we keep the same information (we require that all our employees have a driver?s license). We have several categories of workers: drivers, cleaners, clerks, and managers. Any of our employees can rent a car from our company for a 50% discount, if the rental is less than 2 weeks. However, for any longer rental they must pay 90% of the regular price. Every employee works in one location only. We have headquarters in Hamilton. The people who work there are all classified as managers, one of them is the president, two of them are the vice-presidents, one for operations, the other for marketing).

For certain weeks we have promotional rentals that are usually 60% of the regular price, but may be also of different percentage. They always affect only a single class of cars ? i.e. we may have a promotion for subcompacts, but during that week we do not have any promotions for compacts, sedans or luxury cars. During some years we can have many promotions, in some we have none. The promotions cannot be applied to employee rentals.

Transactions to be Supported

  1. Add a new car to our car inventory.
  2. Add a new customer to our list of customers.
  3. List the names of all customers who are currently renting a car from our company.
  4. List the make, model, year, and classification (i.e. subcompact, compact, etc.) of all cars currently rented out.
  5. For each completed rental, list the rental price and the rental identification number.
  6. List the rental identification number, make, model, year, classification, and rental duration for each of our locations for the month of October, 2015.
  7. List the full names of all customers (all people who have rented a car at some time, not just those with current rentals.
  8. List the names of all employees who have also rented cars from us.
  9. List?the?make,?model,?and?color?of?all?cars?that?have?never?been?rented.


Please help me solve these two following steps:

  1. Identify and associate attributes with entities, identifying attribute domains and primary keys
  2. Check that the model supports user transactions


CAR RENTAL SYSTEM

 


 

Associating attributes with entities

 


 

Entity 1: car

 

Column

 


 

Type

 

Class

 

char(20)

 

Make

 

char(30)

 

Model

 

Text

 

year_made

 

year(4)

 

Color

 

char(20)

 

identification_number varchar(20)...

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001185320.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now