Part 1 – Conceptual Design (50%)
Create a set of requirements that will be used to create the ER Diagram in Step 2.
Create an ER diagram (using ERDPlus) that contains at least five entities and at least four binary relationships. At least one of the relationships should be many to many. Show all attributes of all entities.
Map the ER diagram you created in Step 2 into a relational schema containing the relations (with their attributes) and the referential integrity constraints (i.e. arrows pointing from foreign keys into their sources). Use ERDPlus to draw the mapped relational schema.
Summarization: You will deliver a document containing 4 items:
Item 1: Title Information containing the following:
Header:
Project Phase I, Name
Project Title:
e.g. “Dental Center Database” or “Music Company Database”
Item 2: Requirements
Item 3: ER Diagram
Item 4: Mapped Relational Schema
Part II – Implementation (50%)
Examine the Relational Schema that was created during the Phase I of the project.
Based on that schema, create a set of tables for an MS Access database. Name the database and its tables appropriately. Make sure to specify primary keys for all tables. Make sure all referential integrity constraints are enforced.
Create all the necessary relationships between the tables.
Populate the tables with initial data (no less than two no more than ten records per table).
Create at least three queries for this database.
Create at least three forms for this database. (You can base your forms on tables, queries, or both).
Create at least three reports for this database. (You can base your reports on tables, queries, or both).
Create a Navigation Form that will present the forms and reports created in previous steps to novice users of your application. Create an AutoExec macro, which invokes the Navigation Form you created in Step 7 (simply create a macro named AutoExec which opens the main Navigation Form and maximizes the form – this macro will automatically execute as soon as your Access file is open).
Summarization: You will deliver MS Access file containing your finished application.
