Jan 18: Course Overview

Learning Objectives

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

• Define data, database, database system, query, and SQL.
• Explain the difference between an entity and attribute.

Lesson Outline

Welcome! [15 min]

• Name tents; get to know other students at your table
• About the course, instructor, syllabus, website, etc.

Lecture Slides [45 min]

• Introduction to Database Systems
  • Based on Chapter 1 from the zyBook
• ER Models: Entities and Attributes

Group Exercise [15 min]

The Billboard Hot 100™ is a weekly music chart that ranks the 100 most popular songs in the United States based on factors such as sales, radio play, and online streaming.

• What are the entities?
• What are the attributes?
  • Any composite attributes?
  • Any multi-valued attributes?
  • Any derived attributes?
• What are the key attributes?