BE SURE TO ANSWER THE QUESTIONS AT THE END IN GREAT DETAIL! CONSIDER DESIGNING A

Question

BE SURE TO ANSWER THE QUESTIONS AT THE END IN GREAT DETAIL! CONSIDER DESIGNING A DIAGRAM WITH THE FOLLOWING INFORMATION GIVEN!

Consider the following normalized relations from a data- base in a large retail chain:

STORE (StoreID, Region, ManagerID, SquareFeet)
EMPLOYEE (EmployeeID, WhereWork, EmployeeName, EmployeeAddress)
DEPARTMENT (DepartmentID, ManagerID, SalesGoal)
SCHEDULE (DepartmentID, EmployeeID, Date)

What opportunities might exist for denormalizing these relations when defining the physical records for this data- base? Under what circumstances would you consider creating such denormalized records?

Explanation / Answer

suppose a data communication networks associates a computer at corporate headquarters through a computer at every retail release.The retail chain contains 50 stores through a mean of 75 employees for each store containing 10 departments.A daily timetable is sustained for two monts.moreover imagine as below.

- each store manager notifies the employee work timetable to store abruptly five times for every hour.

-corporation produces each and evry payroll check,mails and employees notices to every store.

-corporation forms a fresh sales target every month for every department.

-corporation recruits and fires a store managers and manages total details regarding the store managers.These store managers hires and fires every store employee and handles the total details regarding the employees in particular store.

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.