Skip to main content

CS403: Introduction to Modern Database Systems

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 conceptual 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.

Completing this unit should take you approximately 12 hours.
- Unit 5 Learning Outcomes Page
- 5.1: The Relational Model at a Glance
  - Gordon Russell's "Mapping ER Models into Relations"
    Read this section.
  - Gordon Russell's "Advanced ER Mapping"
    Read this section.
- 5.2: Mapping an ER Diagram to a Relation
  - Indian Institute of Technology, Bangalore:S. Srinath's "ER Model to Relational Mapping" Page
    Watch this lecture.