DATABASE PROJECT

1. Choose an application (real world problem) that has the following as a minimum: 6 entities (1 weak); 5 relationships (1 many-to-many); 1 composite attribute; 1 derived attribute. In other words, the application should be robust enough in order to make the project a more complete learning experience. If you need to deviate from the minimum requirements, talk with me ahead of time. 2. Design the database using the Entity-Relationship diagram. Follow all of the guidelines discussed in class when generating the E-R diagram. 3. Transform your design into relational database schema. Insure that everything that can be represented in your database is represented. Note those items that can not be represented. 4. Take the resulting database schema and refine it to achieve a "good" set of database schema. 5. Populate the database. Use whatever sample values you wish to choose. There should be at least 20 tuples for each relation in the database (enough to make it interesting to query). 6. Compose 10 meaningful queries to demonstrate that data can be retrieved adequately and accurately. 7. Construct a web based interface to your database. The web interface should allow for data to be entered into as well as displayed from your database. Be as creative as you desire.