Test #2 Terms

For the open-book part of the test, you should be able to take a problem description and identify the entities, functional dependencies, candidate keys, primary keys, foreign keys, etc., to produce a set of entities/tables in fourth normal form.

You should know the following terms for the closed book part of the test.

 


Entity

Attribute

 

Key

Candidate key

Composite key

Primary key

Foreign key

Surrogate key

 

Update anomaly

Deletion anomaly

Insertion anomaly

 

Determinant

Composite determinant

Functional dependency

Transitive dependency

 


Referential integrity

Relation

Normal forms

First normal form

Second normal form

Third normal form

BCNF

Fourth normal form

 

De-normalize

Null value

SQL: COUNT(*) function

SQL: DROP TABLE statement

SQL: INSERT statement

SQL: SELECT * statement

SQL: TOP expression