Database Exercise - Musicals

Setup

• Create a top level directory in your repository named exactly Musicals.
• Download these files to that directory:
  • ActivityJournal.txt
  • DBIntro.txt
  • musicals.sqlite

Overview

Read the DBIntro.txt file carefully. Start your activity journal with your first estimate. Perform the operations described in the DBIntro.txt file. Record your answers in DBIntro.txt. Record your progress in your activity journal as instructed in the DBIntro.txt file.

Note that the initial database has three tables: musicals, authors, and a link table authors_musicals.

Submission

Submit your completed ActivityJournal.txt and DBIntro.txt file in the Musicals directory to your Git repository.

Grading

• Activity Journal is 5 points
• DBIntro Part 1 is 5 points
• DBIntro Part 2 is 5 points
• DBIntro Part 3 is 5 points

Resources

SQLite home page and SQLite documentation

Specific SQLite tutorials: 

• Soup To Nuts
• Free Code

General SQL tutorials:

• W3Schools
• SQLCourse.com