• Unit 5: The Relational Database Model

    The relational database model provides us with a way to understand how data can be perceived. While the E-R model represents the relations between elements of a database, it does not provide a logical view of its data. We will use the relational model to solve that problem. The relational model looks at entities as tables and allows operations to be performed on them. In this unit, we will learn how to map ER models into relations.

    From a life-cycle perspective, the relational model corresponds to high-level design, and adds detail to the conceptual design. The database development evolves from requirements (specified in a conceptual model), to high-level database design (specified in a logical model), to an implementation model (specified in a detailed design and physical model). An E-R model is a particular modeling method for requirements, while a relational model is a method for database design.

    Completing this unit should take you approximately 4 hours.

    • 5.1: The Relational Model at a Glance

    • 5.2: Mapping an E-R Diagram to a Relation

    • Unit 5 Assessment