Answer 6 Questions Technical Data Management and Applications

Technical Data Management and Applications

Assignment 4

1. Describe the purpose of normalizing data. (5points)

2. Discuss the alternative ways that normalization can be used to support database design (5points)

3. Describe the types of update anomalies that may occur on a relation that has redundant data.

(5points)

4. Describe the concept of functional dependency.(5points)

5. What are the main characteristics of functional dependencies that are used when normalizing a relation?(5points)

6. Describe and show the process of normalizing the table below to at least 3NF relations. Show the keys in your relations.(25points)

staffNo	dentistName	patNo	patName	Appointment date time	surgeryNo
S1011	Tony Smith	P100	Gillian White	12/09/08 10.00	S15
S1011	Tony Smith	P105	Jill Bell	12/09/08 12.00	S15
S1024	Helen Pearson	P108	Ian MacKay	12/09/08 10.00	S10
S1024	Helen Pearson	P108	Ian MacKay	14/09/08 14.00	S10
S1032	Robin Plevin	P105	Jill Bell	14/09/08 16.00	S15
S1032	Robin Plevin	P110	John Walker	15/09/08 18.00	S13