MAPPING OF ER DIAGRAM TO RELATIONAL DATABASE SCHEMA

-Before doing this topic, we need to understand ER Diagram.

-Relational Database is a collection of NORMALIZED relations with distinct relation names.

•A relation is a table with columns and rows.

[endif]

•Normalized is defined as “conform to a norm or standard” – Merriam-Webster dict. In database, it means no unnecessary redundancies.

•An attribute is a named column/field of a relation.

[endif]

•Domain is the set of allowable values for one or more attributes.

DENORMALIZED/UNORMALIZED VS NORMALIZED

TERMINOLOGIES

•Tuple is a row/record of a relation.

[endif]

•Degree is the number of attributes in a relation.

[endif]

Cardinality is the number of tuples in a relation

DATABASE SCHEMA

-Database schema is the structure of the database when presented according to the database model chosen.

STEPS TO MAP ERD TO RELATIONAL DATABASE SCHEMA