hw1[1] - CSE 5330 Database Systems I Fall 2001 Homework#1...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CSE 5330: Database Systems I Fall 2001 Homework #1 Due on Wednesday September 20 Worth 3% of the final grade Answer key for Q1 Answer key for Q2(a) EER is posted on Instructor's bulletin board (306 NH) Answer key for Q2(b) UML Directions for this homework: In your Entity-Relationship diagrams you need to identify: all the weak entities and the identifying relationships; all keys and partial keys; the cardinality constraints in each relationship (1:1, 1:N, or N:M only). Do not draw the participation or the structural constraints. Avoid the following common mistakes: to use two different entities for the same object; to represent a complex entity as a (multivalued) attribute of another entity (when the former entity is related to other entities); to have N:M identifying relationships for weak entities. For your UML diagrams, you are not required to use a computer diagramming tool and doing so will not earn you extra credit. Do pay attention to clarity though as it will affect your score.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/14/2010 for the course COMPUTER S Database taught by Professor Drasna during the Spring '09 term at University of Tech - Iraq.

Page1 / 2

hw1[1] - CSE 5330 Database Systems I Fall 2001 Homework#1...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online