Reference no: EM13949838
Consider the following normalized relations for a database in a large retail store chain:
EMPLOYEE(Emp_Id, Work_Location, Name, Address)
STORE(Store_ID, Region, Manager_ID, Square_Feet)
DEPARTMENT(Dep_ID, Manager_ID, Sales, Goal)
SCHEDULE(Dep_ID, Emp_ID, Date)
Assume that a data communications network links a computer at corporate headquarters with a computer in each retail outlet. The chain includes 50 stores with an average of 75 employees per store. There are 10 departments in each store. A daily schedule is maintained for 5 months (the previous 2 months, the current month, and next 2 months). Further assume that:
- Each store manager updates the employee work schedule for her or his store roughly five times per hour.
- The corporation generates all payroll checks, employee notices, and other mailings for all employees for all stores.
- The corporation establishes a new sales goal each month for each department.
- The corporation hires and fires store managers and control all information about store managers; store managers hire and fire all store employees and control all information about employees in that store.
a. Would you recommend a distributed database, a centralized database, or a set of decentralized databases for this retail store chain? Justify your answer.
b. Assuming that some form of distributed database is justified, what would you recommend as a data distribution strategy for this retail store chain? Justify your answer.
|
Problem regarding the saturated vapor
: An ideal vapor-compression refrigeration cycle, with ammonia as the working fluid, has an evaporator temperature of 2208C and a condenser pressure of 12 bar. Saturated vapor enters the compressor, and saturated liquid exits the condenser. The mas..
|
|
Indicate the normal form of the relation
: For each of the following relations, indicate the normal form of the relation. Put each relation in the 3NF.
|
|
Perform regression smoking status as independent variable
: Perform multiple regression to identify whether there is an association between the independent variables (age, height, sex, and smoke) and FEV, using forced entry and stepwise methods of regression. Describe, compare, and interpret your results (..
|
|
Vapor compression refrigeration system
: Refrigerant 22 enters the compressor of an ideal vapor- compression refrigeration system as saturated vapor at 2408C with a volumetric flow rate of 15 m3/min. The refrigerant leaves the condenser at 198C, 9 bar. Determine
|
|
A data distribution strategy for this retail store chain
: Would you recommend a distributed database, a centralized database, or a set of decentralized databases for this retail store chain? Justify your answer.
|
|
Where do most native americans live
: Where do most Native Americans live? Go Online and the home page for your home state. Once there, seek Out the Category that gives you Information on county and local statistics. Select the county where you reside and obtain the vital demographic a..
|
|
Ideal vapor-compression refrigeration cycle
: An ideal vapor-compression refrigeration cycle operates at steady state with Refrigerant 134a as the working fluid. Saturated vapor enters the compressor at 2 bar, and saturated liquid exits the condenser at 8 bar. The mass flow rate of refrigeran..
|
|
Evaluating the situation of the organisation
: Drawing from the EML reading lists and relevant literature recommended and as taught in class to assist in the evaluation of the selected organisation and, based upon this, inform the recommendations you offer to develop.
|
|
Explore areas of interest in more detail
: In responding to the questions in the discussions and on the essay, you may want to use resources in addition to your textbook. This is encouraged, as it allows you to explore areas of interest in more detail. I do caution you; however, to be aware o..
|