Session 09 - Database Exercise

Setup

Download the sqlite database of Broadway musicals, musicals.sqlite, to a clean working directory. The initial database has three tables: musicals, authors, and a link table authors_musicals.

Download the Session9.txt text file. Read the file, perform the operations described, and report the results indicated in the file.

All you will submit for this activity is the completed word document. Place it in a directory called Musicals and submit via Git.

Resources

SQLite home page and SQLite documentation

SQLite tutorials: 1, 2, 3, 4

General SQL tutorials: 1, 2, 3