Description
This assignment will assess the competency 9. Investigate database design.
Directions: Complete the following at the end of Chapter 9
Review Questions 9.29-9.42 (1 point each)
Problems and Exercises 9.43-9.45 (2 points each)
In completing this assignment, create a MS Word file, make sure to number your answers corresponding to the questions within your textbook (ex. 1, 2, 3, etc.) as well as label each section such as “Review Questions” or “Problems and Exercises.”
Upload your completed assignment file into the “LP9.1 Assignment: Chapter 9” dropbox in the course for grading. This assignment is worth 20 points and will be graded according to the following scoring guide.
Explanation & Answer
Hello, kindly find the attached completed work. Thank You.
Running Head: DATABASE DESIGN
1
Database design.
Name
Institution of Affiliation
Date
DATABASE DESIGN
2
9. 29 What is the purpose of normalization?
The purpose of data normalization is to remove, insert, delete, and update and also minimize the
redundancy Anomaly. In this aspect, it divides the larger tables into smaller tables and also
creates links that link them together. It was also important to link a set of the same data available
I two different locations.
9. 30 List five properties of relations.
The essential five properties of relations include; the entities in a single column from the same
Colum of values. Secondly, there is the entries in the cell are made to be simple. Additionally
each column is made uniquely, also the sequence of columns are considered insignificant, and
finally, the sequences of the rows are also insignificant.
9. 31 What problems can arise when merging relations (view integration)?
Some of the problems that can arise when merging relations include synonyms, in this case,
synonyms may occur in two or more different names and are also used for the same purp...