1. What is normalization?
2. When is a table in INF?
3. When is a table in 2NF?
4. When is a table in 3NF?
5. Given the dependency diagram shown below, answer items 5a-5e:
a. Identify and discuss each of the indicated dependencies.
b. Create a database whose tables are at least in 2NF, showing the dependency
diagrams for each table.
c. Create a database whose tables are at least in 3NF, showing the dependency
diagrams for each table.
6. The table structure shown below contains many unsatisfactory components and
characteristics. (For example, there are several multivalued attributes, naming
conventions are violated, and some attributes are not atomic.)
Jill H. Martin
EMP HIRE DATE
L1, L3, L8,
EMP BASE SALARY
EMP _COMMISSION_ RATE
Given that structure, write the relational schema and draw its dependency diagram. Label all
transitive and/or partial dependencies.
7. Break up the dependency diagram you drew in Problem 6 to produce dependency
diagrams that are in 3NF. (Hint: You might have to create a few new attributes. Also
make sure that the new dependency diagrams contain attributes that meet proper
design criteria; that is, make sure there are no multivalued attributes, that the naming
conventions are met, and so on.)
8. Using the results of problem 7, draw the relational diagram.
9. Using the results of Problem 8, draw the Crow's Foot ERD.
This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.
1). Normalization is the process of organizing the records from tables of a database in order to reduce redundancy and dependency.
2). A table it is said to be in 1NF (first normal form) when all key attributes are defined and there aren’t repeating groups in the table. Besides this, all remaining attributes are dependent on the primary key. On the other hand, usually a table in first normal form still contains partial dependencies. These are commonly based on just pieces of primary key and transitive dependencies that are based on a non-key attribute.
3). A table is in 2NF (second normal form) when it is already in 1NF and it also doesn’t include any partial dependencies. A table in 2NF can still contain transitive dependencies, such as dependencies based on attributes that are not part of the primary key....