Reference no: EM1380299
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)
Suppose that a information communications network links a computer at corporate headquarters with a computer in each retail outlet. The chain includes fifty stores with an average of 75 workers 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.
|
What are advantages also disadvantages of project
: What are some of advantages also disadvantages of collaborating on a development project. Do you believe that this relaxing of rules (by UCC) that apply to sales contracts is a good thing.
|
|
Who is responsible for getting work performed
: Once functional manager also project manager agree on a project schedule, who is responsible for getting work performed. Who is accountable for getting work performed.
|
|
List a professional value that is important to you
: List a professional value that is important to you. Then, list an alternative to your value (i.e., How would someone else disagree or have a different perspective).
|
|
Question about data model
: Create a simple data model that outlines a database management system. This model requires to track people's participation in several fitness activities at a fitness center.
|
|
Normalized relations for a database
: Suppose that a information communications network links a computer at corporate headquarters with a computer in each retail outlet. The chain includes fifty stores with an average of 75 workers per store.
|
|
Fire in a bangladesh garment factory
: CASE STUDY - FIRE IN A BANGLADESH GARMENT FACTORY -What would you advise your staff to do when faced with local expectations of "payoffs" and bribery?
|
|
Creating a single table to hold the information
: Think about a typical sales invoice that would include the given information. Create a single table to hold all of the information needed to store an invoice including this information.
|
|
Creating an idef1x diagram
: Construct an IDEF1X diagram that demonstrate only entities and relationships. Name each relationship and specify its cardinalities.
|
|
Detailed strategies to recruit
: What are the qualifications of a trained Mechanical Engineer and what selection methods are best to assess whether or not an applicant meets or exceeds those qualifications
|