Part 2: Course Project Goals

The goal of the project is for you to design, develop, and implement a database for Atlas Corporation. Your project will have the following four parts.

Database Modeling Phase:

You will develop an entity-relationship model of Atlas Corporation using the information part 1 of this document.

Relational Database Schema Phase:

Using your entity-relationship model of Atlas Corporation, you will develop a Third Normal Form relational database schema for the Atlas Corporation database.

Relational Database Implementation Phase:

Using your entity-relationship model of Atlas Corporation, you will develop a Postgres SQL script consisting of the statements necessary to build a Postgres database for Atlas Corporation.

Relational Database Population Phase:

You will develop a Postgres SQL script to populate the Atlas Corporation database with the information outlined in Part 1 of this document.

Relational Dabase Testing Phase:

You will develop a script which demonstrates that you can extract necessary knowledge for the Atlas Corporation database. The information in part 1 and part 4 should guide you in your testing phase.