Jan. 28 Form groups of 4-5 students each.
Feb. 25 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)
Mar. 10 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)
Mar. 31 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)
Apr. 26-28 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 15 minutes). (10
points)
Apr. 28 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.