TRUE/FALSE questions:

1			Data modeling is a technique for organizing, documenting, and modeling functional requirements.
			A)	True
			B)	False
2			The data type of an attribute defines what values the attribute can legitimately take on.
			A)	True
			B)	False
3			An alternate key may serve as the primary key of an entity.
			A)	True
			B)	False
4			A candidate key may be a single attribute or a concatenated key.
			A)	True
			B)	False
5			A ternary relationship is a relationship among four or more entities.
			A)	True
			B)	False
6			A foreign key in a child entity may or may not match the primary key in the parent entity.
			A)	True
			B)	False
7			Identifying relationships are those in which each of the participating entities has its own independent primary key.
			A)	True
			B)	False
8			A many-to-many relationship is one in which many instances of one entity are associated with many instances of another entity.
			A)	True
			B)	False
9			An enterprise data model typically identifies only the most fundamental of entities.
			A)	True
			B)	False
10			A good data model has no redundancies.
			A)	True
			B)	False

Multiple Choice questions:

11			Which of the following is NOT a category of entities?
			A)	concept
			B)	place
			C)	object
			D)	relationship
			E)	event
12			An attribute that consists of other attributes is called:
			A)	extended attribute
			B)	element
			C)	compound attribute
			D)	simple attribute
			E)	none of the above
13			Any candidate key that is not selected to become the primary key is called:
			A)	the domain key
			B)	the entity key
			C)	the concatenated key
			D)	the substitution key
			E)	none of the above
14			A relationship that exists between the instances of the same entity is called:
			A)	reflexive
			B)	associative
			C)	identifying
			D)	recursive
			E)	non-identifying
15			An entity whose instances may inherit common attributes from its entity supertype is called:
			A)	generalization entity
			B)	non-specific entity
			C)	recursive entity
			D)	associative entity
			E)	none of the above
16			A technique that organizes data into groups to form non-redundant, stable, flexible, and adaptive entities is:
			A)	optimization
			B)	normalization
			C)	randomization
			D)	requirements analysis
			E)	data modeling
17			An entity is in the second normal form if:
			A)	values of nonprimary key attributes are dependent on the full primary key
			B)	all values of primary keys are independent of the nonprimary key attributes
			C)	you add additional nonkey attributes that are dependent on other nonkey attributes
			D)	values of nonprimary key attributes are not dependent on any other nonprimary key attributes
			E)	none of the above
18			Every faculty has one or more offices. This is an example of:
			A)	domain
			B)	cardinality
			C)	relationship
			D)	attribute
			E)	none of the above
19			In the relationship between course and faculty, the course entity would be
			A)	nonspecific
			B)	supertype
			C)	the child
			D)	the parent
			E)	none of the above
20			An attribute whose value can be calculated form other attributes is called:
			A)	dependent attribute
			B)	compound attribute
			C)	simple attribute
			D)	derived attribute
			E)	none of the above