CIS 336 Final Exam (Feb 2016) CIS 336 Final Exam (Feb 2016) | Page 2

Question 6. 6. (TCO 3) The extended entity relationship model (EERM) is sometimes referred to
as the _____
Question 7. 7. (TCO 3) A table that has all key attributes defined, has no repeating groups, and
all its attributes are dependent on the primary key, is said to be in _____
Question 8. 8. (TCO 4) When a constraint is created at the _____ level with the CREATE TABLE
command, the constraint definition is simply included as part of the column definition. (Points :
4)
Question 1. 1. (TCO 4) When creating a table, which of the following statements is NOT correct?
Question 2. 2. (TCO 4) Which of the following SQL statements would you use to create a table
named DEVRY?
Question 3. 3. (TCO 5) The Crow's Foot model is more _____-oriented than the Chen model.
Question 4. 4. (TCO 5) Knowing the _____ number of entity occurrences is very helpful at the
application software level.
Question 5. 5. (TCO 6) The _____ statement can be used to enable or disable a constraint.