Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions