Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are required to create a conceptual data model of the data requirements for a plumbing whole sale company. Following are their business requirements (ERDish):

You are required to create a conceptual data model of the data requirements for a plumbing whole sale company. Following are their business requirements (ERDish): Each salesman has got a sales number, last name, first name, and address (street, city, state, zip, commission, and rate. Every salesman handles one or many customers. Each customer has customer number, customer name, address (street, city, state, zip, balance, credit limit, and salesman number. Each customer can be handled by one and only one salesman. Each order has order number, order date, customer number. Each order includes one or many parts. Each part has part number, description, on hand, class, warehouse, price. Each part can be handled by zero or many orders. Parts quantity per order and quoted price also need to be included when an order has been issued. TO DO a) Identify the main entity types based on the above questions b) Identify the main relationship types and specify the multiplicity for each relationship for each question. State any assumptions you make about the data. Using your analysis answers and results for draw a single ER diagram to represent the data requirements for the company.

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

Databases Illuminated

Authors: Catherine M. Ricardo

1st Edition

0763733148, 978-0763733148

More Books

Students also viewed these Databases questions

Question

What does it mean to say that SQL operators are set-oriented?

Answered: 1 week ago

Question

What is A free product or gift?

Answered: 1 week ago