Question
Question:

Consider the following normalized relations from a database in a large retail chain:

STORE (Store ID, Region, ManagerID, Square Feet)

EMPLOYEE (EmployeelD. WhereWork, EmployeeName, EmployeeAddress)

DEPARTMENT (DepartmentlD. ManagerlD SalesGoal)

SCHEDULE (DepartmenttD. EmployeelD.Date)

Answer these questions:

1. What opportunities might exist for denormalizing relations when defining the physical records for database?

2 Under what circumstances would you creating such denormalized records?

Leave a Reply

Your email address will not be published. Required fields are marked *

Question
Question:

Consider the following normalized relations from a database in a large retail chain:

STORE (Store ID, Region, ManagerID, Square Feet)

EMPLOYEE (EmployeelD. WhereWork, EmployeeName, EmployeeAddress)

DEPARTMENT (DepartmentlD. ManagerlD SalesGoal)

SCHEDULE (DepartmenttD. EmployeelD.Date)

Answer these questions:

1. What opportunities might exist for denormalizing relations when defining the physical records for database?

2 Under what circumstances would you creating such denormalized records?

Leave a Reply

Your email address will not be published. Required fields are marked *