Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

ERD Diagram

22/09/2020 Client: jwhite211 Deadline: 3 days

  


Lab 2 - EERD


Overview


Wally Los Gatos, owner of Wally’s Wonderful World of Wheels, has hired you as a consultant to

design a database management system for his chain of stores that sell used vehicles. Wally requires this system to track details about inventory, employees, sales and customers. 


Requirements

Based on the following information, draw an EER diagram. Please indicate any assumptions that you have made in your diagrams!


After an initial meeting with Wally, you have developed a list of business rules and specification to begin the design of an the ER Model. 


· Customers place orders through a dealership. Wally has three dealership locations (Cambridge, Kitchener and London), and may add more in the future


· Wally would like to track the following about customers:

Name, Address, City, Province, Postal Code, Telephone, Date of Birth, Email


· A customer may place many orders


· A customer does not always have to order through the same dealer all the time


· A dealership may have many customers


· Orders are composed of one or more vehicles from inventory


· The following information about each order needs to be recorded:

Order Date, Final Sale Price, Credit Authorization Status


· We wish to record the following about each vehicle:

Vehicle Identification Number (VIN), Make, Model, Year, Colour, Km’s, Photo, Purchase Price, Sticker Price


· Wally obtains vehicles from a range of suppliers, including auctions, bank foreclosures, other dealerships, and private sellers


· Wally employs fifty-six employees


· He would like to track the following information about employees:

Name, Address (Street, City, Province, Postal Code), Telephone, Date of Hire, Title, Salary, Age


· If the employee’s role is that of a mechanic, we should track their Certification Number


· If the employee’s role is that of a salesperson, we should track their commission and total Vehicles Sold


· If the employee’s role is that of a manager, we should track which employees they manage


· Each employee works in one and only one dealership


· Each employee may have one or more dependents.

We wish to record the name of the dependent as well as the age and relationship

 


Sample Sales Record:


*********************


Thank you for choosing Wally’s World of Wheels at


Guelph Auto Mall for your quality used vehicle!


Sales Rep: #3265 Peter Green


Processed By: 5487 


Invoice Number: 123654


Date: On Sept. 20, 2017


Customer: John Smith!

22 Front St W


Kitchner, ON, N2A4G8


[email protected]


2013 Toyota Camry, White 


VIN: 27764534RTB KMS: 211023

Purchase Price: $15,260.00


Trade In: $ 0.00


Subtotal = $ 15,260.00


HST (13%) = $ 1,983.80


Sale Total = $ 17,243.80

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Best Coursework Help
Top Grade Essay
Academic Master
Buy Coursework Help
Math Specialist
Assignment Hub
Writer Writer Name Offer Chat
Best Coursework Help

ONLINE

Best Coursework Help

Hello, I have access to journals and online libraries as well as insightful articles that guarantee me to write quality and unique content for your paper. I would like to help you at a reasonable price, high-quality work delivered on time. I am ready to work on your assignment and complete it in accordance with all the instructions. Quality is guaranteed and the assignment will have 0% plagiarism. Please consider hiring me.

$150 Chat With Writer
Top Grade Essay

ONLINE

Top Grade Essay

Hello My name is Samson. I am 100% sure that I will meet your expectations in writing the essay . I have written over 4000 high quality plagiarism free papers and deliver within stipulated deadlines. I am familiar with a number of citation styles among them MLA, APA, APSA, Oxford, Chicago, OSCOLA, Harvard and Turabian. I believe that I am the right candidate for this project, and I guarantee quality work.

$180 Chat With Writer
Academic Master

ONLINE

Academic Master

I have super grip on essays, case studies, reports and discussion posts. I am working on this forum from last 6 years with full amount of satisfaction of my clients.

$140 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

I can help you with your project. I will make sure to provide you exceptional quality work within the required timeframe. Please message me so we can discuss the further details over chat.

$135 Chat With Writer
Math Specialist

ONLINE

Math Specialist

I am a specialist in MATHS with having 12 years of experience. I can help you with Maths, Stats, Algebra and Calculus within very short amount of time. Please check my reviews,rating and samples to check my skills and level.

$155 Chat With Writer
Assignment Hub

ONLINE

Assignment Hub

I feel, I am the best option for you to fulfill this project with 100% perfection. I am working in this industry since 2014 and I have served more than 1200 clients with a full amount of satisfaction.

$155 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Pentagon hexagon octagon list - Probability of overlapping events - Stata cluster analysis - Enter a formula that references the value in cell f10 - Https firstworld firstsource com intranet - Verbos complete the chart with the correct verb forms contar - Hamilton science year 4 - Calcot manor salt scrub - Lissajous figures frequency ratio - Raptors a field guide for surveys and monitoring - Nh4cl + h2o enthalpy - Jackie schechter slinky brand - Government - Http www fbi gov wanted wanted_terrorists - Project requirements risk cost - Dwight grabs jim's junk bloopers - Anwar f accawi the telephone - Ed masry law firm - Discussion 7 erm - James madison federalist 10 - Dynamic pricing ecommerce case study - Planning and Organization - Niamerica online bill payment richland - Uts room booking system - Eastern metropolitan regional council - Research Paper - How to write about africa pdf - Birch and swinnerton dyer conjecture - Requirements for iphone upgrade program - Toe chart definition - Alan moore v for vendetta introduction - Sandra case study - Assessment the bill of rights answers - Successfully imitative crossword clue - Philippine lambanog distilled coconut wine - 97 confidence interval z score - Need to read and follow instructions and answer with detailed answers. - Svahn ab is a swedish manufacturer of sailing yachts - Cert iv training and assessment cheat sheet - Persuasive writing examples naplan - Ts3200 tape library express - Marketing SWOT - Essay: code of Hammurabi - Brush turbogenerators managing director - Four basic concepts of nursing - Girls at war pdf - Homework - What is a thematic essay - Hamad medical corporation residency salary - ResP2 - Baby lap bounce songs - A large firm uses an average of 40 boxes - Literature kc value for fescn2+ - Pivot table data crunching microsoft excel 2010 pdf - Teavana artisanal brewing kit platinum edition - Essay - How can creative expression impact issues we deal with today - Resistance to change theory kotter - 99th percentile z score - Nice guy vs bad boy - Discussion - Homework - Ansys installation critical error - Garnier ultimate blends tesco - Patient Autonomy Power point presentation - HLS685 A1 - Can You Please Solve this - Fema - Which of the following has zero dipole moment - Equilibrium and le chatelier lab answers - Balance the following redox reaction in acidic medium - The magic hat mem fox activities - University of essex resits - ODC3IP - Snuggle exhilarations spa pink peony and rosewood - Cephacare flavour 250 mg tablets - Discuss Question - Which of the following is the best definition of effective teaching? - Finnegans funeral home phillipsburg nj - Facilities management best practices - South east wales centre for teacher education and training - ISO Certification discussion question - Measurment &evaluation - Homework4 - Blue mountains bus timetable - A disc rotates about its axis of symmetry - Australian life in the 1960s - Purdue hospitality and tourism management plan of study - Determination of ascorbic acid in vitamin c tablets lab report - Dr ruja health alpha and omega - Assignment #021 - Dave presidential movie worksheet answers - Head loss due to pipe fittings lab report - The circuit short story questions - Theme of short story true love by isaac asimov - Natasha trethewey elegy - BHA415 Module 3 Case - Multiple schedule of reinforcement - Infant soap note example - Social studies