http://yunus.hacettepe.edu.tr/~tonta/courses/spring2006/dok322/homework-e-r-diagram.htm

Hacettepe University Department of Information Management

DOK 322 Database Management Systems (Spring 2006) Yaşar Tonta

HOMEWORK: COOKIE ENTITY-RELATIONSHIP (E-R) DIAGRAM

You were asked to answer some queries using the ready-made Cookie database in your first assignment.  This assigment aims to introduce you to the Entity-Realtionship (E-R) diagrams.  We reviewed the basic E-R terminology and tools (rectangles for entities, ellypses for attributes, etc.) in class along with extended E-R and IDEF1X notations.  Please read Chapters 2 and 3 of Kronke and review the Cookie database before you complete this assignment. Use MS PowerPoint to draw E-R diagrams (will be explained briefly in class).

1. Create an E-R diagram for the Cookie database.  

2. Name the entities and relationships along with their attributes using the E-R notations.  

3. Define the relationships between various entities (one-to-one, one-to-many, many-to-many).  By "entity" one should understand the table names in the Cookie database (i.e., BIBFILE, PUBFILE, etc.).

4. Indicate minimum and maximum cardinalities for each entity.

5. File your homework in your directory under Network Neighborhood/Bilgi/ by March 27, 2006, 09:00 a.m. (File names should be "cookie-ER" for the original ER notation and "cookie-IDEF1X" for the IDEF1X notation.  Please store them immediately under your directory, NOT under sub-sub-subdirectories that you may be inclined to create!!  Failure to do so may affect your grade if we cannot identify the files that contain your assignments.)

6. Repeat steps 1-5 using IDEF1X notation.

The assignment is due in class on March 28, 2005 9:00 am.  Your directories shall be temporarily inaccessible after the due date and time to grade your assignments.

No late assigments shall be accepted.  

Yaşar Tonta

tonta@hacettepe.edu.tr

Last updated: March 12, 2006