Scribd
Upload
3K views

Chapter 1 Problems

This document contains information about two file structures (Figures 1.1 and 1.5) that have data redundancy issues. Figure 1.1 contains project manager information with redundancies in manager names, phone numbers, and addresses. Figure 1.5 contains employee and project details with redundancies across many fields like employee names and phone numbers. The document asks questions about identifying redundancy issues, how they could lead to anomalies, and how the file structures could be modified to eliminate redundancies.

Uploaded by

Rosh Sibal
Copyright
© © All Rights Reserved
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3K views

Chapter 1 Problems

This document contains information about two file structures (Figures 1.1 and 1.5) that have data redundancy issues. Figure 1.1 contains project manager information with redundancies in manager names, phone numbers, and addresses. Figure 1.5 contains employee and project details with redundancies across many fields like employee names and phone numbers. The document asks questions about identifying redundancy issues, how they could lead to anomalies, and how the file structures could be modified to eliminate redundancies.

Uploaded by

Rosh Sibal
Copyright
© © All Rights Reserved
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

FIGURE 1.

1 The file structure for Problems 1-4


PROJECT_CO
DE
21-5Z

PROJECT_MANA
GER
Holly B. Parker

MANAGER_PHO
NE
904-338-3416

25-2D

Jane D. Grant

615-896-9909

25-5A

George F. Dorts

615-227-1245

25-9T

Holly B. Parker

904-338-3416

27-4Q

George F. Dorts

615-227-1245

29-2D

Holly B. Parker

904-338-3416

31-7P

William K. Moor

904-445-2719

MANAGER_ADDR
ESS
3334 Lee Rd.,
Gainesville, FL
37123
218 Clark Blvd.,
Nashville, TN
36362
124 River Dr.,
Franklin, TN
29185
3334 Lee Rd.,
Gainesville, FL
37123
124 River Dr.,
Franklin, TN
29185
3334 Lee Rd.,
Gainesville, FL
37123
216 Morton Rd.,
Stetson, FL
30155

PROJECT_BID_P
RICE
16633460.00

12500000.00

32512420.00

21563234.00

10314545.00

25559999.00

56850000.00

1. How many records does the file contain? How many fields are there per
second?
There are nine record in Figure P1.1. In each record there are five
fields.
2. What problem would you encounter if you wanted to produce a listing by city?
How would you solve this problem by altering the file structure?
Manager_Address is not yet precises it can subdivided into simple
attributes so, the problem that can be encounter will be sql confusion
can be lead to data redundancy
3. If you wanted to produce a listing of the file contents by last name, area
code, city, state, or zip code, how would you alter the file structure?
In this case, first I will delete project Manager, and use Add Alter to add
a column name LastName, then instead of giving the complete
address, they divide it or classify it and these are area code, city, state,
or zip code. I use add alter command to add this in the table.
4. What data redundancies do you detect? How could those redundancies lead
to anomalies?
I detect four (4) redundancies per column these are Holly B. Parker and
George F. Dorts, they both repeated twice in Project_Manager, same as
in their Manager_Phone and Manager_Address. They will lead to
anomalies if their main key will become a unique key

FIGURE 1.5 The file structure for problems 5-8


PROJ_NU
M
1

PROJ_NA
ME
Hurricane

EMP_NU
M
101

Hurricane

105

Hurricane

110

Coast

101

Coast

108

Satellite

110

Satellite

105

Satellite

123

Satellite

112

EMP_NAM
E
John D.
Newson
David F.
Schwann
Anne R.
Ramoras
John D.
Newson
June H.
Sattlemei
r
Anne R.
Ramoras
David F.
Schwann
Mary D.
Chen
Allecia R.
Smith

JOB_CO
DE
EE

JOB_CHG_HO
UR
85.00

PROJ_HOU
RS
13.3

CT

60.00

16.2

CT

60.00

14.3

EE

85.00

19.8

EE

85.00

17.5

CT

62.00

11.6

CT

26.00

23.4

EE

85.00

19.1

BE

85.00

20.7

EMP_PHO
NE
653-2343245
653-2341123
615-2335568
653-2343254
905-5547812
615-2335568
653-2341123
615-2335432
615-6786879

5. Identify and discuss the serious data redundancy problems exhibited by the
file structure shown Figure P1.5
All the fields have redundancies
6. Looking at the EMP_NAME and EMP_PHONE contents in Figure P1.5 what
change(s) would you recommend?
I recommend that the redundancy should be lessen and the number.
Create new table to avoid redundancy.
7. Identify the various data sources in the file you examined in Problem 5.
Proj_Num 1 2 and 3 are repeated
Proj_Name Hurricane, Coast, Satellite, are repeated
Emp_Num 101, 105, 110, are repeated
Emp_Name John D. Newson, David F. Schwann, Anne R. Ramoras are
repeated
Job_Code EE,CT are repeated
Job_CHG_Hour 85, 60, are repeated
Emp_Phone 653-234-1123, 615-233-5568, are repeated
8. Given your answer to Problem 7, what new files should you create to help
eliminate the data redundancies found in the file Figure P1.5?

Create new table.

FIGURE 1.9 the file structure for problems 9-10


BUILDING_C
ODE
KOM

ROOM_CO
DE
204E

TEACHER_LNA
ME
Williston

TEACHER_FNA
ME
Horace

TEACHER_INI
TIAL
G

KOM

123

Cordoza

Maria

LDB

504

Patroski

Donald

KOM

34

Hawskin

Anne

JKP

225B

Risell

James

LDB

301

Robertson

Jeanette

KOM

204E

Cordoza

Maria

LDB

504

Williston

Horace

KOM

34

Cordoza

Maria

LDB

504

Patroski

Donald

DAYS_TIME
MWF 8:008:50
MWF 8:008:50
TTh 1:002:15
MWF 10:0010:50
TTh 9:0010:15
TTh 9:0010:15
MWF 9:009:50
TTh 1:002:15
MWF 11:0011:50
MWF 2:002:50

9. Identify and discuss the serious data redundancy problems exhibited by the
file structure shown in Figure P1.9.(The file is meant to be used as a teacher
class assignment schedule. One of the many problems with data redundancy
is the likely occurrence of data inconsistenciestwo different initials have
been entered for the teacher named Maria Cordoza.)
Figure 1.9, the entry for primary key (build_code) has a multiply no of
KOM, which does not satisfy the definition of primary key, uniquely
identifies each attribute. So there will be confusion on the data on the
table.
10.Given the file structure shown in Figure P1.9 what problem(s) might you
encounter if building KOM were deleted?
If the Building_Code was deleted the Room_Code, Teacher_LName,
Teacher_Initial and Day_Time, Will become unclassified because they
dont have primary key that supports the record.

You might also like