Welcome to the Most Reliable, Essay Writing Service on the internet

our-company-does-car-rental-business-and-has-several-locations-with-different-addresses

Mar 23

Database Design Project

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. 1. Add a new car to our car inventory.
  2. 2. Add a new customer to our list of customers.
  3. 3. List the names of all customers who are currently renting a car from our company.
  4. 4. List the make, model, year, and classification (i.e. subcompact, compact, etc.) of all cars currently rented out.
  5. 5. For each completed rental, list the rental price and the rental identification number.
  6. 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. 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. 8. List the names of all employees who have also rented cars from us.
  9. 9. List the make, model, and color of all cars that have never been rented.

Please Help me follow THESE two steps:

1) Identify and associate attributes with entities, identifying attribute domains and primary keys

2) Check that the model supports user transactions

  

CLIENT TESTIMONIALS

The Service Is Okay. I won’t Complain

The writers on the website are courteous and the customer service responds quickly. My paper was handled well; They promised...

Writers here are very professional and are native British

Thanks a lot for helping me out with my PhD Thesis, Writers here are very professional and are native British!!

Jack, The United Kingdom

Very Very Helpful, and On time.

Very Very Helpful, and On time.

Adelio M, Spain

I scored complete A’s in 3 out of four courses

I scored complete A’s in 3 out of four courses

Anonymous, Illinoi Chicago

CLICK HERE  To order your paper

About Essaysmiths Assignment writing service

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for upto 20% off in their first Order. Our payment method is safe and secure.

 CLICK HERE to Order Your Assignment

 

Get access to cheap essays online, and forget about all your worries

Quality assurance

When we accept your assignment order, we treat it with the utmost seriousness. This means that only the best experts will conduct research on your topic and that they will deliver your paper only after making sure that it is insightful.

Total confidentiality

We use the SSL protocol to ensure that all the details of our customers are 100% safe and secure. So, forget about all worries when sharing personal information on our site. We never disclose the details of our clients.

All round service

24/7 customer support. We don’t want you to fail to submit your paper. So, we work 24 hours a day and 7 days a week to provide you with instant feedback.

Original Essays

One of the key principles of our work is to be creative and original. We hire only talented and experienced essay writers that are able to create authentic papers. Each regular essay or term paper is written from scratch in accordance with all your guidelines.

Cheap Service

Compared to our competitors, we offer a relatively cheap service. We allow you the comfort of a cheap paper writing service to improve your grades. If you are facing an academic problem, we’ll solve it by asking for a fair price.

Rocket fast Essay writing service

Don’t worry! We work in a timely manner to deliver orders before the due date. You’ll have enough time to check whether the finished paper corresponds to all your requirements. If not, provide us with feedback and ask for a revision.

Order Your Essay Today From  reliable Essay writing Service.

Order your Assignment today and save 15% with the discount code ESSAYHELP

X