Please prove the detailly answer for all the question blew, thank you very much 1 List the five types of users identified in a database system and describe their individual interactions with database systems 2 Consider the File Structure for the ABC Company Project Management data given below Then, respond to each of the following questions related to the structure ProjectNum ProjectName EmpNum EmpName JobCode Job Chg Hour Proj Hours Emp Phone 1001 Thunder 121 Daisy B Burns AB 80 00 14 2 773 555 1216 1001 Thunder 217 Alice M Zane CD 65 00 15 7 773 555 1216 1002 Chicago 821 Dean P Pence BD 95 00 14 4 773 555 1231 1002 Chicago 219 Cecily D Worth CD 80 00 17 2 773 555 1217 1003 Archimedes 222 Sami A Allen EH 65 00 24 9 773 555 8821 1003 Archimedes 121 Cecily D Worth AB 95 00 37 8 773 555 1219 1003 Archimedes 516 Denny T Li HW 80 00 22 2 773 555 2222 1004 Emerald 355 Danny T Li UG 65 00 19 7 773 555 2222 1005 Diamond 217 Alice M Zane CD 80 00 19 5 773 555 1216 1005 Diamond 222 Sami A Allen BD 95 00 22 3 773 555 8821 (a) List and discuss two additional fields that could or should appear on the above table structure (b) Identify and discuss the serious data redundancy problems exhibited by the file structure shown in the given data sheet

The Answer is in the image, click to view ...

Question: Please prove the detailly answer for all the question blew, thank you very much. 1. List the five types of users identified in a database

Please prove the detailly answer for all the question blew, thank you very much.

1. List the five types of users identified in a database system and describe their individual interactions with database systems.

2. Consider the File Structure for the ABC Company Project Management data given below. Then, respond to each of the following questions related to the structure.

ProjectNum	ProjectName	EmpNum	EmpName	JobCode	Job_Chg_Hour	Proj_Hours	Emp_Phone

1001	Thunder	121	Daisy B. Burns	AB	80.00	14.2	773-555-1216
1001	Thunder	217	Alice M. Zane	CD	65.00	15.7	773-555-1216
1002	Chicago	821	Dean P. Pence	BD	95.00	14.4	773-555-1231
1002	Chicago	219	Cecily D. Worth	CD	80.00	17.2	773-555-1217
1003	Archimedes	222	Sami A. Allen	EH	65.00	24.9	773-555-8821
1003	Archimedes	121	Cecily D. Worth	AB	95.00	37.8	773-555-1219
1003	Archimedes	516	Denny T. Li	HW	80.00	22.2	773-555-2222
1004	Emerald	355	Danny T. Li	UG	65.00	19.7	773-555-2222
1005	Diamond	217	Alice M. Zane	CD	80.00	19.5	773-555-1216
1005	Diamond	222	Sami A. Allen	BD	95.00	22.3	773-555-8821

(a) List and discuss two additional fields that could or should appear on the above table structure.

(b) Identify and discuss the serious data redundancy problems exhibited by the file structure shown in the given data sheet.

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 Databases Questions!

Please prove detailly answers for the questions blew, thank you very much. 1. Consider these types of local businesses, and their individual system needs, that could be near or in your area of...

Please prove the detail answer for all the questions blew, thank you so much. Questions: Part 1 (1) ( Data Models and Business Rules ) Consider the following business facts that a retail company...

Please prove the detail answer for all the questions blew, thank you so much. Questions: 1. customers purchase products and goods products are subject to various types of sales / county taxes retail...

Please prove the detail answer for all the questioins blew, thank you so much. Part 1: (1) ( Data Modeling ) Given the following group of tables, list FIVE written business rules that are reflected...

Can you please help me with this case problem? AICPA Case Development Program. Case No. 2000-02: Recreation, Inc Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC....

He want us to identify the 18 vulnerabilities. template is attach. Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC. AN INFORMATION TECHNOLOGY RISK ASSESSMENT CASE...

Risk Assestment Project - Identify 18 Vulnerabilit AICPA Case Development Program Case No. 2000-02: Recreation, Inc. ? 1 RECREATION, INC. AN INFORMATION TECHNOLOGY RISK ASSESSMENT CASE STUDY OF...

Hello, please help me these questions that attached in this request. Thank you very much Swinburne University of Technology ACC80005 FINANCIAL ACCOUNTING THEORY Primary Exam Semester 1, 2016 Exam...

1 PM665 Project Management Capstone Project Name Your Name Date 2 Table of Contents 1.0 Introduction...

Required Informatlon [The following Information applies to the questions displayed below.] Marc and Michelle are marrled and earned salarles this year of $64,000 and $12.000, respectively. In...

Consider two mutually exclusive R&D projects that ADM is considering. Assume the discount rate for ADM is 15 percent. Project A: Server CPU .13 micron processing project By shrinking the die size to...

Great deposited $ 3 4 0 0 . 1 3 years ago for an emergency phone account is worth $ 6 2 4 0 what are you a rate of return to return on this account

Hillside issues $2,000,000 of 6%, 15- year bonds dated January 1, 2013, that pay interest semiannually on June 30 and December 31. The bonds are issued at a price of $2,447,990. Required: 1. Prepare...

3. Consider the interview questions for the lead drivers that are shown on page 115. Write questions that could be used to interview the six lead driver supervisors and the two regional vice...

3. Validate or confirm the preliminary list of tasks. This step involves having a group of SMEs (job incumbents, managers, etc.) answer in a meeting or on a written survey several questions regarding...

4. Once the tasks have been identified, it is important to identify the knowledge, skills, or abilities necessary to successfully perform each task. This information can be collected through...