Our Services

Get 15% Discount on your First Order

Normalized relations for a database

June 14, 2023

Part A.

Please use the database you created in the Week 4 Assignment. I have attached what was done in Week 4.

Create a matrix to indicate permissions (read, insert, delete, modify) you would grant to different users of your database.
Create at least two different users and implement their permissions using SQL statements.

Part B.

“Consider the following normalized relations for a database in a large retail store chain:

STORE (Store_ID, Region, Manager_ID, Square_Feet)

EMPLOYEE (Employee_ID, Where_Work, Employee_Name,

Employee_Address)

DEPARTMENT (Department_ID, Manager_ID, Sales_Goal)

SCHEDULE (Department_ID, Employee_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 five months (the previous two months, the current month, and next two 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 controls all information about store managers; store managers hire and fire all store employees and control all information about employees in that store.

Would you recommend a distributed database, a centralized database, or a set of decentralized databases for this retail store chain? Please explain why.
Assuming that some form of distributed database is justified, what would you recommend as a data distribution strategy for this retail store chain?” (Hoffer, Prescott, & Topi, 2009, p. ch.14 – 29 ).

How to solve
Normalized relations for a database Nursing Assignment Help

Introduction:

This assignment requires the creation of a matrix to set permissions for different users of a database, as well as implementing these permissions using SQL statements. Additionally, the assignment requires us to make a recommendation for a retail store chain’s database management system, including whether a distributed, centralized, or set of decentralized databases would be best, and what data distribution strategy would be ideal.

Part A:

1. Matrix indicating permissions for users of database:
| | Read | Insert | Delete | Modify |
|———-|——-|——–|——–|——–|
| Admin | x | x | x | x |
| Manager | x | x | | x |
| Employee | x | x | | |

2. SQL statements for implementing permissions:
CREATE USER ‘Admin’@’localhost’ IDENTIFIED BY ‘password’;
GRANT SELECT, INSERT, DELETE, UPDATE ON database_name.* TO ‘Admin’@’localhost’;

CREATE USER ‘Manager’@’localhost’ IDENTIFIED BY ‘password’;
GRANT SELECT, UPDATE ON database_name.* TO ‘Manager’@’localhost’;

CREATE USER ‘Employee’@’localhost’ IDENTIFIED BY ‘password’;
GRANT SELECT, INSERT ON database_name.* TO ‘Employee’@’localhost’;

Part B:

1. In this case, we would recommend a centralized database management system. While the data communications network could support a distributed system, it would be more challenging to maintain and manage the necessary infrastructure, especially with daily scheduling updates and monthly sales goal changes. Additionally, a centralized system allows for more efficient management and control of data.

2. For a centralized system, we recommend a replicated database with all the necessary data stored in a centralized location and accessible to all stores. This strategy eliminates communication issues and streamlines all data management. Additionally, it ensures that all relevant data is uniform across all stores and is up-to-date. Finally, it reduces the risk of errors and inconsistencies.

Reference:
Hoffer, J. A., Prescott, M. B., & Topi, H. (2009). Modern database management. Pearson Education.

database, Normalized, Relations

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Embark on a journey within the new omegle, an online sanctuary exclusively for those aged 18 and above. Let serendipity guide you through an array of

Embark on a journey within the new omegle, an online sanctuary exclusively for those aged 18 and above. Let serendipity guide you through an array of exhilarating features, forging connections that transcend borders. Customize your experience by adding interests, and fostering connections with kindred spirits who share your passions, be

Is it right for nurses to endorse health reform legislation even if the legislation is not perfect? Does this apply to the recently failed American

Is it right for nurses to endorse health reform legislation even if the legislation is not perfect? Does this apply to the recently failed American Health Care Act?

Section One Ethics Problems From Thiroux and Krasnow’s Ethics: Theory and Practice 11th Edition

Section One Ethics Problems From Thiroux and Krasnow’s Ethics: Theory and Practice 11th Edition Choose ONE of the following Ethics Problems and answer it to the very best of your ability. These questions are fairly complex, and will require a minimum of 4 full pages (double spaced, not including the

2-2 Discussion: Carl Rogers and Person-Centered Therapy In 1965, a company called Educational and Psychological Films produced a series of therapy

2-2 Discussion: Carl Rogers and Person-Centered Therapy In 1965, a company called Educational and Psychological Films produced a series of therapy vignettes called “the Gloria Tapes,” featuring the same woman, Gloria, in therapy sessions with the founders of three important psychotherapeutic approaches: Carl Rogers (client centered), Fritz Perls (Gestalt), and

2-1 Discussion: Active vs. Passive Listening Describe the difference between active and passive listening in your own words, supporting your explanation

2-1 Discussion: Active vs. Passive Listening Describe the difference between active and passive listening in your own words, supporting your explanation with a citation. You may use resources provided in the module reading and resources area, or a scholarly resource of your choice. Then, think about your own life. Can

1-2 Journal: Using Social Justice and Understanding Bias Specifically, you must address the following: Describe your most dominant social

1-2 Journal: Using Social Justice and Understanding Bias Specifically, you must address the following: Describe your most dominant social identities. Describe implicit bias represented within your most dominant identities. How does implicit bias show up in your most dominant identities? Identify the core principles of social justice. Describe how implicit bias impacts your understanding of the core

Use the resources linked below to help complete this assessment. Informatics Project Management To learn more about key

Use the resources linked below to help complete this assessment. Informatics Project Management To learn more about key topics related to this assessment, read: · Garcia-Dia, M. J. (Ed.). (2019). Project management in nursing informatics . Springer Publishing Company. · Chapter 6, “Project Integration Management and Systems Development Life Cycle:

There are different answers to the question of what makes a healthcare system good. It likely depends upon one’s point of view. However, the World

There are different answers to the question of what makes a healthcare system good. It likely depends upon one’s point of view. However, the World Health Organization (WHO), one of the major organizations in the world has established a well-accepted list of six major areas, so let’s begin here.

Review “Case: Revised training for the U.S. Navy” in Chapter 4 of the textbook, and respond to the prompts below. You are not required to answer the

Review “Case: Revised training for the U.S. Navy” in Chapter 4 of the textbook, and respond to the prompts below. You are not required to answer the questions at the end of the case study in the textbook. Summarize the case. Examine the components of an effective training needs analysis

YENROSE DISCUSSION QUESTIONS: Answer them separately 1. How has technology affected your life? Be specific as to what changes, and in what ways. 2.

YENROSE DISCUSSION QUESTIONS: Answer them separately 1. How has technology affected your life? Be specific as to what changes, and in what ways. 2. Do you believe the long-term consequences of increased technological dependence are going to be good or bad? Explain. How do you see technology’s effect on society

The Commerce Clause refers to Article 1, Section 8, Clause 3 of the U.S. Constitution. It authorizes Congress “to regulate commerce with foreign nations,

The Commerce Clause refers to Article 1, Section 8, Clause 3 of the U.S. Constitution. It authorizes Congress “to regulate commerce with foreign nations, and among the several states, and with the Indian tribes.” This is the fundamental source of authority for the federal regulation of commerce. However, the federal government’s authority to regulate

2 Professional Goal and Objectives: (SMART) · Professional goals and objectives are related to this course’s clinical

2 Professional Goal and Objectives: (SMART) · Professional goals and objectives are related to this course’s clinical rotation (practicum). · During your clinical practicum, you will have the opportunity to work side-by-side with an expert (RN preceptor) to meet specific learning goals in a chosen area of interest. Thus, your professional goals

After reviewing the TEDTalk Video: I Love Being a Police Officer, but We Need Reform by Melvin Russell, respond to the following: There doesn’t seem to

After reviewing the TEDTalk Video: I Love Being a Police Officer, but We Need Reform by Melvin Russell, respond to the following: There doesn’t seem to be a question that law enforcement is in crisis today. What steps can be taken to transform the relationship between police and the communities they are

A) Describe the importance of folk medicine practices and folk healers to African Americans in the rural setting. B) Mrs. M., a Mexican American who

A) Describe the importance of folk medicine practices and folk healers to African Americans in the rural setting. B) Mrs. M., a Mexican American who just gave birth, tells the nurse not to include certain foods on her meal tray because her mother told her to avoid those foods while

2-2 Annotated Bibliography: Part 1 The purpose of the Annotated Bibliography is to help you organize the research that you conduct for this class

2-2 Annotated Bibliography: Part 1 The purpose of the Annotated Bibliography is to help you organize the research that you conduct for this class and for your final project. Please refer to the Annotated Bibliography Example for additional information. To help format your assignment, use Sections I through IV of

Describe the key roles and responsibilities in homeland security by federal, state, and local actors. Also, discuss the part played by private industry.

Describe the key roles and responsibilities in homeland security by federal, state, and local actors. Also, discuss the part played by private industry. What inherent conflicts arise among these various actors as they pursue their homeland security missions? How does DHS navigate among these organizations to ensure homeland security? 750

2-1 Discussion: Theory Progression Discuss the historical influence of Freud’s theory. How did the time period influence Freud as he developed his

2-1 Discussion: Theory Progression Discuss the historical influence of Freud’s theory. How did the time period influence Freud as he developed his personality theory? Respond to two other classmates and compare your observations on how the historical context influenced Freud’s theory. Think about the historical context of your selected theory

Our Services

Normalized relations for a database

How to solve Normalized relations for a database Nursing Assignment Help

Share This Post

Related Questions

Use Our 6 Free Tools

How to solve
Normalized relations for a database Nursing Assignment Help