Question
Oversell, Inc. has three levels of personal customers: silver, gold and platinum. Customers are identified by a CustomerID. Oversell also stores the customer name, address
Oversell, Inc. has three levels of personal customers: silver, gold and platinum. Customers are identified by a CustomerID. Oversell also stores the customer name, address and balance. Platinum and Gold customers are preferred customers, and they get a special lower interest rate on their credit card balance. Platinum customers also has access to a personal customer service representative, who can serve several platinum customers. The company maintains information about the customer service rep (Employee ID number, Employee name, and the last date of contact between a specific platinum customer and the customer service rep.) In addition, Oversell, Inc. has business customers. These customers get an extended line of credit. Some customers maintain both a personal and a business account with Oversell Inc. Develop an EER model segment to represent Oversells customer structure.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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