Week Five

Question 1

Data Dictionary:

Answer 1

A centralized repository that provides detailed information about the data used within a system or database

(Fields, Tables, Constraints)

Question 2

Entity-relationship diagram (ERD):

Answer 2

The relationship between Suppliers, Parts, Line Items, Order

Box - entity
Line - relationship
l l - one to one relationship
l > - one to many relationship

Question 3

Normalization:

Answer 3

Streamlining complex groupings of data to minimize redundant data elements and awkward many-to-many relationships