Module: High-level database models

Introduction to database modeling.

Learning Outcomes

Structure Data using Data Models

You are able to conceptualize data using different data models
You are able to use data modeling tools like Entity-Relationship Diagrams.
You are able to translate data models into relational table schema (DDLs)

Readings

Chapter 4: High-level database models

Requirements analysis, conceptual, logical, and physical database design

70 pages

High-level database models

Logical, physical, and conceptual database modeling

Lecture Notes

Experiential Learning

Exercise 10

Practice the design of a database model

HW4: ERD

Design a database

Assignment 4