Question: The drawing shows CUSTOMER which is a super type with total specialization and overlap constraint with two subtypes, REGULAR CUSTOMER and NATIONAL CUSTOMER. The super
The drawing shows CUSTOMER which is a super type with total specialization and overlap constraint with two subtypes, REGULAR CUSTOMER and NATIONAL CUSTOMER. The super type has three attributes as Customer Type, National, and Regular, while National Customer has Account Manager as its attribute. CUSTOMER also has a mandatory single to optional many Submits relationship with ORDER, which further has a mandatory-single to mandatory-many relationship with ORDER LINE, which further has an optional-many to mandatory-single relationship with PRODUCT. Let's make a few assumptions about the average usage of the system: 1. There are 60,000 customers, and of these, 85 percent represent regular accounts and 15 percent national accounts. 2. Currently, the system stores 2,500,000 orders, although this number is constantly changing. 3. Each order has an average of 30 products. 4. There are 5,000 products. 5. Approximately 1,500 orders are placed per hour. 1. Based on these assumptions, draw a usage map for this portion of the EER diagram 2. Management would like employees only to use this database. Do you see any opportunities for denormalization
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
