Question
A business has agents which sells products to customers. An order is taken by an agent for a customer who chooses products to buy. You
A business has agents which sells products to customers. An order is taken by an agent for a customer who chooses products to buy. You are asked to draw an entity relationship diagram to start a database for the company. You can make the following assumptions:
(a) A customer has a name and a street address and a unique phone number.
(b) Each order is identified by a unique order number.
(c) A typical order can be for one or more products.
(d) Each product can only be sold once per order.
(e) Each product has a unique item number.
Write the schemas for the entity-relationship diagram of the Problem, using the methods given in the book and discussed in class.
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