project+1

Project 1 You can work in Teams: If you do, I will need to know what each person in the group did to contribute to the project.
Along with your database, you will have a to turn in a project design document. Your project design document will have the following sections. > Provide the following information:
 * 1) **Preamble**
 * Your design document last modified date
 * Your name
 * Your project name
 * A summary description of your proposed database system
 * A link or some indication where you got your project idea from
 * Your signature.

Provide a reasonably comprehensive description of the database project -- (Approx. 250 words)
 * 2. Project Description**

> State at least 5 substantially different queries that your system will handle, in English; you will later provide the SQL commands to execute these queries. > Create an Entity/Relationship Diagram of your project database. Be sure to start with some hand-drawn sketches. Minimum requirements: at least 5 entity sets, and at least 20 attributes (total), and enough relationships to connect each entity set to at least one other entity set. Be sure to indicate degree constraints (many-many, many-one, and one-one), open or closed arrows and multiplicity indicators where appropriate, and primary keys. > **Note:** Do not give in to the temptation to design a super-sized mammoth database that does everything you might possibly be able to think of in your domain. Stick as closely to the minimum as you think is reasonable and complete all the work for this phase. Even if you have time and energy left over to do more, hold that thought until after the next phase of the project... When you are confident you have a fully qualified diagram, render your diagram using an E/R design tool, such as Gliffy ([|www.gliffy.com]) as we have done in class. 3. **Relational Schema** Convert your E/R diagram to a relational database schema. 4. **Sample Queries SQL** State the queries from Section 3 using SQL Commands. 5. **Functional Dependencies** State all the functional dependencies that exist in your database (In each table), given your initial schema. 6. **Database Implementation** Build your database in SQLPLUS, Oracle Express, Microsoft Access, etc. and show me that it is live-->Meaning that the database was fully implemented and I could test it. (I will verify this in the last week of class) Must have a minimum of 5 tables and 25 records each table.
 * 1) **Sample Queries - English**
 * 1) **Entity-Relationship Diagram**
 * Note:** Resist the temptation to do this first, or even simultaneously with the previous section. It will be so much easier and quicker to do this AFTER you have completed your E/R diagram.

Database Example Projects:
 * 1) Computer Equipment Inventory Tracking
 * 2) Music CD Collection for Music Store
 * 3) Grocery Store
 * 4) Financial Institution (e.g. Bank)
 * 5) Book Collection for Book Store

OR come up with your own idea.

Creating Forms or Reports will be Extra Credit for this Project

Example: