3024.S08.HW3.KEY

3024.S08.HW3.KEY - ISE 3024/S08: HW3 KEY - 1 of 4 ISE 3024...

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

View Full Document Right Arrow Icon

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

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

Unformatted text preview: ISE 3024/S08: HW3 KEY - 1 of 4 ISE 3024 Data Management for IEs Spring 2008 Homework Assignment #3 Solution Key (10) 1. a) Primary key = set of one or more attributes which uniquely define entities in a class. There will be as many primary keys as there are entity classes in a given conceptual schema. (b) Single attribute, value unlikely to change. (c) Specify a secondary key , based upon attributes the user is familiar with. Example: cable bill has a customer ID # (primary key), but customers can also specify their last name and address. (9) 2. A null value is when nothing is assigned to an attribute (i.e., empty space exists) for a particular entity. These are not desirable . This is because they create ambiguity . A null value could mean either the attribute is not applicable for that entity, or the value is known but missing (not recorded), or the value is unknown....
View Full Document

Page1 / 4

3024.S08.HW3.KEY - ISE 3024/S08: HW3 KEY - 1 of 4 ISE 3024...

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