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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!