Practicum Project 2 – Due on 11/23/2019

The purpose of the database term project is to understand topics covered in class and apply it to a real life problem. The students are free to pick any topic. The goal is to create a database and demonstrate different aspects of how this database can be utilized to accomplish different requests. The term project is composed with 3 components:

1. Practicum Project Part 1

2. Practicum Project Part 2

3. Final Project + Presentation

Some project ideas include (but not limited to):

For the second component, these are the requirements:

  1. The database (it is okay if not all data is in the tables)
  2. SQL scripts for different tasks (make sure JOIN operators, SUBQUERY, and relational SET operators are used for your scripts)