(Solved) : Required Create Conceptual Data Model Data Requirements Plumbing Whole Sale Company Follow Q44037903 . . .
You are required to create a conceptual data model of the datarequirements for a plumbing whole sale company. Following are theirbusiness requirements (ERDish): Each salesman has got a salesnumber, last name, first name, and address (street, city, state,zip, commission, and rate. Every salesman handles one or manycustomers. Each customer has customer number, customer name,address (street, city, state, zip, balance, credit limit, andsalesman number. Each customer can be handled by one and only onesalesman. Each order has order number, order date, customernumber. Each order includes one or many parts. Each part haspart number, description, on hand, class, warehouse, price. Eachpart can be handled by zero or many orders. Parts quantity perorder and quoted price also need to be included when an order hasbeen issued. TO DO a) Identify the main entity types basedon the above questions b) Identify the main relationship types andspecify the multiplicity for each relationship for each question.State any assumptions you make about the data. Using your analysisanswers and results for draw a single ER diagram to represent thedata requirements for the company.
Expert Answer
Answer to You are required to create a conceptual data model of the data requirements for a plumbing whole sale company. Following…
OR