This preview has intentionally blurred sections. Sign up to view the full version.View Full 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
- Spring '08
- Data Management, Entity-relationship model, advisor, IDEF1X, Natural key, weak entity class