Database Concepts - create a use case diagram using the information and the table. explain your reasoning.

- entities, attributes, relationships, assumptions -

 

Music Store A local music store wants help with marketing. Specifically, the owner knows that some customers are better than others and wants to encourage them to purchase more items from the store by offering discounts. However, she does not want to offer the same level of discounts to everyone who walks in from the street because profits would drop. She needs a computer system to help employees give the correct discounts to each customer. Basically, she wants a frequent buyer program, where customers are placed into categories based on the amount of money they spend in a year. However, she also wants the ability to move some customers into higher categories based on other factors (such as name recognition). The heart of the system is a list of the customer categories, the sales amount needed to reach each level, and the discount applied. However, some products or sales will not count towards the reward levels. For instance, close-out sales items will not be included in sales totals, nor are they eligible for additional discounts. So, she needs a list of inventory items along with an indicator for the discount eligibility. Level Sales Discount Platinum $50,000 20% Gold $25,000 15% Silver $10,000 10% Bronze $5,000 5% Sale ID Customer ID Last Name, First Name Band E-mail Address Phone Sale Date Employee Delivery Address City State, ZIP Reward Level Item Description Price Quantity Discount Value Total Current annual total of reward points: Reward Points