Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

quick answer pls.. Part C: ER-Diagram and EER-Diagram (15 points) Medinah Transport dealership sells Proton, Ford, Honda and Toyota. The dealership keeps the cars information

quick answer pls..
image text in transcribed
Part C: ER-Diagram and EER-Diagram (15 points) Medinah Transport dealership sells Proton, Ford, Honda and Toyota. The dealership keeps the cars information such as vehicle number, list price, chassis number, made (eg. Honda, Toyota), model name (eg. Civic, Camry) and year. They also keep information about all sales they have made (for instance, invoice number, buyer's name, data of purchase and amount paid for the car). In order to contact the buyers in the future, the dealership also keeps their telephone number and address. Some buyers bought more than one car. For statistical purposes, the buyer's gender and age are also captured. Dealer also needs to know the staff who sold the cars to the buyers such as their staff ID, name, phone number, gender, date of birth, address and basic salary. The dealership has two types of staff - sales agent and admin. Sales agent will have sales quota, basic salary and sales commission from selling cars. While admin staff will receive basic salary and overtime (based on his/her overtime rate). Medinah Transport has three dealerships all over town. The branch is identified by a unique branch number, address and telephone number. Each staff will be assigned to a particular branch. Based on the information given about Medinah Transport, create a single integrated Entity Relationship Diagram or EER-Diagram using the class notation diagram from UML. In your diagram, you should identify all the entities, attributes, primary key, relationship, and multiplicity constraints

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Knowledge Discovery In Databases

Authors: Animesh Adhikari, Jhimli Adhikari

1st Edition

3319132121, 9783319132129

More Books

Students also viewed these Databases questions

Question

what is a peer Group? Importance?

Answered: 1 week ago

Question

3. Job rotation is used for all levels and types of employees.

Answered: 1 week ago