1/26 Form groups of 4-5 students each.
2/23 Find a database application that has about 5 to 10 entities. Describe the application, information requirements, and the function the database is supposed to perform. Clearly state any assumptions you make about the application. Any application is fine. Ideal place to look is at your work – this could be a great opportunity for you to enhance your grade and make your boss happy (maybe you will get promoted !!). (4 points)
3/9 Do the conceptual data modeling using the E-R diagram. You may well go through several iterations and refinements in the process, but you need to report only the final results. (3 points)
3/30 Do the logical and physical design of the database. Represent the elements of the conceptual design model in a relational data model. Apply normalization principles to translate your set of relations so that they are in 5NF. Develop a composite usage map. Denormalize your 5NF relations if necessary. Incorporate any other physical design features as desired. (3 points)
4/25-4/27 Implement the relational database and create some sample data (at least 15 tuples for each table as sample data) using Access. Formulate 10-15 frequently used queries and some innovative queries that you can visualize. Run the queries against your relational database. Try to employ as many advanced features of ACCESS in your implementation as you see fit. Demonstrate your ACCESS system to the class (about 20 minutes). (10 points)
4/27 Prepare a report to document your entire database development effort, i.e., from initiation to implementation, and discuss to what extent the user requirements of the system are accomplished. The report should be about 10-15 pages (typed, double-spaced, including figures, tables, etc.). Turn in a printed copy of the report and an electronic copy of the completed system. (10 points)
Note: Your individual score will be adjusted based on the evaluation of your group members.