Professor Heimann's sons (twins Alex and Mark) are continuing their entrepreneurial ways by starting up the A & M Creamery, a series of small ice cream shops spread around the greater Pittsburgh area. Your job this semester is to construct an initial version of the Creamery online application that will help manage shifts and handle basic payroll functions.

To help you in this endeavor, you are provided with several items that you will find links to at the bottom of this page. The first is a narrative describing important facts about the A & M Creamery and what is needed from this online application. The remaining files are templates for documents that you will need in this phase.

In this phase, we will focus on creating and documenting the data model that will be needed to create the online application. This phase will constitute 6 percent of your final course grade and is broken down into the following components:

1. Basic Data Model: Students will provide an entity-relationship diagram (computer-generated; no hand drawings accepted), a database design in 3NF (see template below), and a data dictionary (see template below). All documents must be internally consistent. The database must be in 3NF.

2. Use Cases: Students will provide a set of uses cases that the system must implement to be considered fully working. Students will use the use case template provided below to structure their documents.

Student solutions to this phase are to be uploaded to canvas by 4pm on January 23, 2020. Absolutely no late assignments will be accepted.

If you have questions regarding the turn-in of this project or problems downloading any of the materials below, please post them on Piazza or ask someone well in advance of the turn-in date. Waiting until the day before it is due to get help is unwise -- you risk not getting a timely response that close to the deadline and will not be given an extension because of such an error.

Additional Information and Supporting Materials:

Case Narrative for the Creamery
High-Level Use Case Template
Database Design Template
Data Dictionary Template
Use Cases Defined (from class)