Question: A student sent me the following email while developing the project with her group (paraphrased & condensed): Why are Job Code/ID, Emp ID, and Emp

A student sent me the following email while developing the project with her group (paraphrased & condensed): "Why are Job Code/ID, Emp ID, and Emp Last Name all stored in an event table for that event's internal agent?And why is Job Description stored & displayed in the Emp table rather than Job Code/ID?This makes the Job Code table unnecessary.Worse, it violates redundancy rules, duplicates attribute data, and wastes storage space."

This made me fear that others in the class might be sharing her confusion.What is she misunderstanding about the benefits of relational databases, including the answers to the following:

(1) what is actually being stored in a relational database,

(2) the effects on top management looking at the displayed data in a relational database

(3) the strengthening of controls and the role it has in a relational database

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

A student sent me the following email while developing the project with her group (paraphrased & condensed) "Why are Job Code/ Emp 10. and Emp Last Name all stored in an event table for that events...

Last semester astudent sent me the following email while developing the project with her group (paraphrased & condensed): "Why are Job Code/ID, Emp ID, and Emp Last Name all stored in an event table...

Last semester astudent sent me the following email while developing the project with her group (paraphrased & condensed): "Why are Job Code/ID, Emp ID, and Emp Last Nameall storedin an event table...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Contribution to Final Assessment: 20% This is an Individual Assignment. All work must be your own. Submissions are automatically checked for similarities. Unexplained similarities may constitute...

ISFM-300 Case Study, Stage 2: Business Process Analysis and Functional Requirements Before you begin this assignment, be sure you: 1. Have completed all previously assigned readings, particularly...

ACCT 2281: Accounting Software Systems 1 TRU Open Learning Final Project (25%) The information provided in this test allows you to set up all ledgers for an Ontario company named KILLARNEY...

I would like assist for my assessment. The subject is Subsidiary Accounts and Ledgers and Foundation Skills. T-1.8.1 Details of Assessment Term and Year 1, 2017 Time allowed Week 2-7 Assessment No 1...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Identify three types of pressure that resulted from changes taking place in the education sector and explain how they affected HEC Montreal. Why is the CRM project of strategic importance to HEC...

Give the Boolean equation as mentioned below F (x, y, z) = [(x +y ) (x' + z )]' 1) Modify the Boolean equation such that it can be implemented using two-level NOR gate circuit.

From the mentioned below discuss which model is more suitable for storing data. And what are the drawbacks of other models which are not selected by you for storing data? i. Hierarchal model ii....

Greenity Systems offers its employees a defined contribution plan. The company matches employee contributions at 5 0 % up to 8 % of salary. Jesse works for Greenity Systems, and he earns an annual...

Bruno Fruscalzo decided to start a small production facility in Sydney to sell gelato to the local restaurants. His local milk supplier charges $0.5 per kg of milk plus a $20 delivery fee (that is...

3. What does it mean when we say that we attribute a certain meaning to our experiences?

2. In this chapter, the reader should reflect on the following concepts : Thomas theorem, premise of action, utterance and mental constructions.

11. Based on the following rules regarding the confidence we have in information in a communication context, find examples from your everyday life where the rules have relevance: (a) The spatial rule...