Your first step is to select a database you will design and implement in this class. You will make weekly contributions to your overall Key Assignment. The database project idea should first be sent to your instructor for approval before this Phase 1 Individual Project is due. In this first week you will explore a structured design process when creating your database application. You will write a report describing the database design development life cycle and describe in details the steps needed to properly create the database you have selected for your Key Assignment. You will also provide an overall description of your database that you received approval from your instructor to do.
You also should take this opportunity to create the template for your entire Key Assignment project; create a Word document that you will add to for each remaining assignment. The document should follow this format:
Database design project document shell
Use Microsoft Word
Title page
Course number and name
Project name
Student name
Faculty name
Date
Table of contents
Use auto-generated TOC
Separate page
Maximum of three levels deep (one level deep is okay too)
Be sure to update the fields of the TOC so it is up-to-date before submitting your project.
Section headings (create each heading on a new page with TBD as content except for sections listed under new content below)
Project outline
Description of the database design life cycle
The entity relationship diagram
The logical model and normalization
The Microsoft Access database
The Microsoft Access database application
Each week, you will add to this document and submit for grading. As a preview, each section will contain the following:
Description of the database design life cycle (Week 1 IP)
A description of the selected database project
A description of the DBDSL - 7 steps
A discussion about the three steps in database design