Chapter 6- Part 1

Question 1

ERD Model Components

Answer 1

Entity (Table, Relation)
Attribute (Column)
Relationship
Composite Entity

Question 2

Normalization

Answer 2

process of converting complex data structures into well-structure relations

Question 3

Well-Structured Relations

Answer 3

1. Contains a minimum amount of redundancies
2. allows rows to be inserted, modified and deleted without introducing errors or inconsistencies

Question 4

First Normal Form

Answer 4

table describes a single entity and it contains no arrays or repeating attributes

Question 5

Second Normal Form

Answer 5

First Normal Form + all attributes are fully depended on the PK ( No partial dependencies)

Question 6

Third Normal Form

Answer 6

Second Normal Form + all non-key attributes are completely independent of each other