ComputerScienceExpert
$18/per page/
Please see the attached files which describe a database class term project:
The Business ProblemOur company does car rental business and has several locations with differentaddresses (address consist of street or rural route with the number, city, state and zipcode). The cars are classified as subcompacts, compacts, sedans, or luxury. Each car hasa particular make, model, year made, and color. Each car has a unique identificationnumber and a unique license plate. The cars rented in a particular location may bereturned to a different location (so called drop off).For every car we keep the odometer reading before it is rented and after it isreturned. Since we trust our customers, we do not record any defects when the car isrented out and returned back. However, we rent the car with a full tank and record thevolume of gas in the tank when the car is returned, but we only indicate if the tank isempty, 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 carreturns. If a customer requests a specific class (say sedan), we may rent the customer ahigher-class car if we do not have the requested class in the stock, but we will price it atthe 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, 1week, 2 weeks, and 1 month. Thus, if a customer rents a car for 8 days, it will be pricedas 1 week + 1 day. The drop-off charge only depends on the class of the rented car, thelocation it was rented from and the location it is returned to.About our customers, we keep their names, addresses, all phone numbers, and thenumber of the driver’s license (we assume a unique license per person). About ouremployees we keep the same information (we require that all our employees have adriver’s license). We have several categories of workers: drivers, cleaners, clerks, andmanagers. Any of our employees can rent a car from our company for a 50% discount, ifthe rental is less than 2 weeks. However, for any longer rental they must pay 90% of theregular price. Every employee works in one location only. We have headquarters inHamilton. The people who work there are all classified as managers, one of them is thepresident, two of them are the vice-presidents, one for operations, the other formarketing).For certain weeks we have promotional rentals that are usually 60% of the regularprice, but may be also of different percentage. They always affect only a single class ofcars – i.e. we may have a promotion for subcompacts, but during that week we do nothave any promotions for compacts, sedans or luxury cars. During some years we canhave many promotions, in some we have none. The promotions cannot be applied toemployee rentals.Transactions to be Supported1.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.) ofall cars currently rented out.5.For each completed rental, list the rental price and the rental identificationnumber.6.List the rental identification number, make, model, year, classification, and rentalStep 1: Create and check the E‐R model1.1 Identify entitiesEntityDescriptionActorAll performers, as listed on the DVD packageDVDInformation regarding the movieMemberInformation regarding the club membersRentalDeliveryInformation that connects the Member information to the DVD beingrentedWishInformation regarding DVDs that the member would like to rent inthe futureDistributionCenterInformation about the company location – can be either a storefrontor a warehouseDVDCopySpecific copy of a DVD – any DVD can exist in many copies in theinventoryMembershipTypeList and description of the different types of membership availablethrough the clubStaffInformation relevant to the club employeesAn ER Diagram with relationship and crows feet linking each entitytable is needed, the primary and foreign keys have to be indicated andall attributes listedThis document presents an example of the deliverable due for the DatabaseDesign Project assignment. Most of the steps and sub‐steps present an example ofwhat you should provide in your project deliverable. Some of the steps and sub‐steps (sub‐step 1.4, for example) provide an explanation of what, if anything, youneed to develop. You can easily distinguish an example from an explanation;explanations are written initlaics.
Attachments: