Course Project: Database Project

Objectives

The object of the project is to give you the experience of solving a problem using the programming language of your choice and the MySQL database engine. Your database solution is pretty open ended. The main requirements are that your solution contains at least three tables and all of the data in those tables are manipulated by your programming language.

Guidelines

Week 1: Determine a Project

Consider a project that might solve a problem. Write a short report defining what the project is and what the problem is that it is designed to solve. The solution database must contain at least three tables. You may manipulate this database with any programming language you desire.

Week 2: Design the Database

Design the database by developing a fully attributed data model. The model should show all tables. Each table should have a primary key and may have foreign keys. Every field in each table should be identified, along with its data type and size.