Question
Generate a conceptual model for each of the following problem Sales rep data include a sales rep number (unique identifier), name, and phone number. A
Generate a conceptual model for each of the following problem
Sales rep data include a sales rep number (unique identifier), name, and phone number. A sales rep services 0 or more customers. Customer data includes a customer number (unique identifier), name, address, and phone. Each customer places 1 or more orders. Order data include an order number (unique identifier) and order date. Each order contains 1 or more products. Products can be listed on 0 or more orders. Product data includes a product number (unique identifier), description, and price. Each product contained on an order has a quantity ordered. Hint: be careful with the relationship between Product and Order. How will you deal with quantity?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started