Skip to content

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]

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?