Keys & Relationships

Site Map

Objective:

To transform the E-R Model to Access Relationships
To create an Normalized Relations understanding the importance of the primary key.
By studying and critiquing the models of classmates to see errors that can occur in database relationships that are not normalized and how they are corrected.
To understand the critical importance of having a correct model before proceeding.
To practice ways to ensure validity of the model.

Assignment:

	Using MS Access to create relationships for your database that implement your E-R model and Business Rules.
	Upload your MDB and post a short description of what you did (what others should look at) on the Bulletin Board.
	Read the summary posts of others, download their databases and critique the relationships of teammates and other class members.
	Respond to your critiques.

Details:

Learn about Access Primary Keys and Relationships

	read about them in an Access book
	use online MS Access help. Enter "Relationships" in the Help wizard and follow the links to "Create or modify relationships" and "Work with relationships"

Select primary keys for all your tables

Make relationships that correspond to your E-R Model

Be sure to go from the 1 to the Many side of the relation and Ensure Referential Integrity

Compact and upload it to your directory on the virtual drive and post description of what you did on the Bulletin Board.

Look at other students posts and study the Relationships

Critique team member and others as replies to their post.

Study your Critiques

Improve your diagram as needed

Procedure:

Read Chapter 5 "Normalization of Database Tables."

Study your tables. Make sure they are all in third Normal Form

Compact and upload your MDB to your directory on the virtual drive

Post a message on the Bulletin Board that your work is ready to be reviewed.

Submit for assignment for feedback from proof and first draft grade

Check if your teammates or other class members have posted a Forms is on their Database

If so download the MDB

View the relationship by clicking on the Relationship button. This will cause the relationships to show such as

Inspect each relationship by pointing to a line and right clicking so you can Edit it

Check the designs including keys of each table by pointing to it and right clicking and choosing "Table Design"

Post suggestions on the Bulletin Board

Imitate good ideas in your database tables, keys and relations

Look for suggestions to your keys and relationships

incorporate suggestions into your design and upload to your directory on the virtual drive again then note improvement on Bulletin Board as a reply to your original post in the Relationship topic or

post reasons why you think suggestions won't work

Iterate on steps 6 an 7 above (Help classmates, Revise your database)

[ Site Map ] [ Home ]

This page was created by Professor Maureen Greenbaum and was last updated on 02/04/06
Page Name: Introduce Yourself
URL:             http://faculty.ucc.edu/business-greenbaum/DB/c0introduceYoursel.htm
Disclaimer:    http://www.ucc.edu/professional_disclaimer.htm
Copyright:      ãMaureen Greenbaum 2001, 2002. All rights reserved.