DB - U2T1. Normalization

What is normalization?

What is the 1NF?

• Eliminate repeating groups in individual tables (columns).

• Create a separate table for each set of related data.

• Identify each set of related data with a primary key.

• All options.

What does ERD mean?

• Entity Relationship Diagnosis

• Educational Relationship Diagram

• Entity Relationship Diagram

• Elementary Relationship Diagnosis

What is the 3NF?

• Identify each set of related data with a primary key.

• Eliminate fields that do not depend on the key.

• I don’t know, next question.

• Relate these tables with a foreign key.

What is the 2NF?

• Eliminate fields that do not depend on the key.

• Create separate tables for sets of values that apply to multiple records (rows).

• Relate these tables with a foreign key.

• Identify each set of related data with a primary key.

What are database business rules used for?

What are the differences between the Entity-Relationship Diagram and the Relational Model?

Draw the 3 types of cardinalities based on their representation in the Entity-Relationship Diagram and in the Relational Model.

What are the differences between Primary key and Foreign key?

Are you ready for the practical phase of the exam?

• 
• 
• 
• 
•