Question
Q3: Consider the below section of an ERD, assume that it is desirable to classify customers into loyal customers, who have been ordering from the
Q3: Consider the below section of an ERD, assume that it is desirable to classify customers into loyal customers, who have been ordering from the store for more than five years, and those who have been with the store for less than five years but more than three. The purpose of the classification is to provide gifts for these customers. Suppose that it is also desirable to keep information about the gifts. Also, assume that it is needed to classify products into frequently requested and not frequently requested, and to keep information about the suppliers for both categories of products.
Draw the EERD for the above system
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