Skip to content

Week 1 - Intro / ER Models

Learning Objectives

After today's class, you should be able to:

  • Understand database fundamentals, including history, key roles and definitions, challenges of data management, differences between small and large-scale systems, and an introduction to relational databases, SQL, and the phases of database design.
  • Understand database design within the SDLC, focusing on ER modeling and diagramming (Chen and Crow’s Foot notation), and develop skills to analyze business requirements and represent entities, attributes, and relationships in an ERD.

Class Agenda

Task List

  • Optional Reading: Chapters 1, 2, 4
  • Submit names for Assignment groups on Canvas
  • Complete and Submit Quiz 1
  • Complete and Submit HW1 Create ERD

Additional Resources

Chen Notation
Crow's Foot Notation