Randall_Hall_week_3_quiz

Randall_Hall_week_3_quiz - 7. The process of decomposing...

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

View Full Document Right Arrow Icon
Randall Hall CS360 Week 3 Quiz 1. primary key  is an attribute that uniquely identifies each row in a relation.     2. A primary key that consists of two or more attributes is called a  composite  key.     3. The first step in transforming EER diagrams into relations is  map regular entities .     4. Associative entities are also called  gerunds .     5. A weak entity must always have a  partial identifier  which distinguishes the various occurrences of the  weak entity for each owner entity instance.     6. A recursive foreign key is one that references the primary key values of the same relation.
Background image of page 1

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

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

Unformatted text preview: 7. The process of decomposing relations with anomalies to create smaller, well-structured relations is called normalization . 8. A functional dependency is a constraint between two attributes or two sets of attributes. 9. An attribute or combination of attributes that uniquely identifies a row in a relation is called a primary key . 10. A relation that contains no multivalued attributes, but has nonkey attributes not dependent on the primary key is in third normal form. -10 pts: first normal form, page 192...
View Full Document

This note was uploaded on 07/10/2011 for the course CS 360 taught by Professor Hammond during the Spring '09 term at Park.

Page1 / 2

Randall_Hall_week_3_quiz - 7. The process of decomposing...

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