please help me identify all entities, relationships, attributes and cardinality in the attached Mini Miller Dealership case.  

 

Miller Mini Dealerships Design Case StudyFall 201630 pointsMary and Mike Miller own multiple Mini dealerships throughout Missouri. Theyhave used systems in the business for several years to handle payroll, typical accountingfunctions, and customer order entry. Because of the dealership's expansion both in thenumber of used car locations and the number of cars handled, they need a databaseapplication to track their used car inventory, dealership locations, managers, salespeople,customers, and prospects (CRM-like).The dealership handles both new and used cars at several locations but the newcar inventory is managed by a system supplied by BMW. While the information theyneed to track on both types of cars is similar (VIN#, make, model, year, style, color,engine, cost, selling price, transmission, etc) for used cars they want to track informationabout the car's condition, mileage, repairs, and previous owner. Some used cars are trade-ins, some are lease returns, and some have been purchased at auction. New cars aretracked by the BMW tracking system. A salesperson can sell a car from anotherdealership location, but usually cars will stay at one location.The owners also wish to keep track of their salesforce. Each location has amanager who is also a salesperson at that location. They would like to know the typicalemployee information as well as which customer is assigned to an individual salesperson.Customers are categorized by whether they have purchased in the past or whetherthey are a prospect. Prospects are further categorized as to what stage of the buyingprocess they are in. A customer may have purchased one or more cars and a prospect maybe interested in one or more models. The database should keep track of contacts madewith the prospects and any quotes. For commission purposes, a customer may beassigned to more than one salesperson. The owners wish to track which car(s) a customerpurchased over time. They wish to actively market to their prospect and customer base,both electronically and through the mail. The Miller family takes a great deal of pride intheir service levels.The owners wish to be able to produce reports that show inventory levels (whichused cars are at each dealership. They also want to do direct database marketing to theirprospective customers. The system should be able to produce information aboutsalesperson production as well as show the customer/salesperson relationship. The systemshould be able to provide a wide variety of ad-hoc queries from information in thedatabase.Design and present a graphical conceptual entity-relationship model of thisdatabase application. Make sure you label and specify the degree of each relationship. Ifyou cannot show all attributes in the model itself, list them separately.Be sure to list anyassumptions you make.You need not use an automated tool like Visio for this, but makesure your diagram is neatly presented and readable. The grading will be based on roughly10 points each for the entities, relationships, and attributes. While you may discuss the

• 1495433862-MillerMiniCase12016.docx

ComputerScienceExpert

(11)

Status NEW Posted 22 May 2017 06:05 AM My Price 8.00

-----------

Attachments

file 1495433865-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer