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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started