If processing speed was an important requirement for a company when building out a database, what changes can a designer revise in the next database iteration if the current design has more than 95% of tables with a 1:1 relationship?

	a.	Create more M:N relationship.
	b.	Create more 1:M relationships.
	c.	Leave the database design as is.
	d.	Combine some tables together.

In an ERD that says DOCTOR writes PRESCRIPTION, a PATIENT receives a PRESCRIPTION, and a DRUG appears in a PRESCRIPTION, it is mostly portraying what type of relationship degree?

	a.	binary
	b.	unary
	c.	recursive
	d.	ternary

In the relationship where "PROFESSOR teaches CLASS," and a class can have only one professor teaching, how is the PROFESSOR cardinality notated if PROFESSOR is mandatory?

	a.	(0,N)
	b.	(1,N)
	c.	(1,1)
	d.	(0,1)

When a composite entity, ENROLL, is between two parent entities CLASS and STUDENT, what would its cardinality be to ensure an enrollment has at least one student, and an enrollment is associated with at least one class?

	a.	(N:1)
	b.	(1:M)
	c.	(M:1)
	d.	(M:N)

If a university has some departments that are classified as "research only" and do not offer courses, how would the COURSE entity relate to a DEPARTMENT entity of a university database?

	a.	optional to
	b.	existence-dependent on
	c.	mandatory for
	d.	independent of

If TEAM and PLAYER have a mandatory relationship where PLAYER has a cardinality expressed as (6,12), which of the following is true about the TEAM object?

	a.	A team must have minimum of 12 players.
	b.	A team can only have 6 teams.
	c.	A team must have minimum of 6 players.
	d.	A team can exist without players.

When looking at the tables, external database reviewers are unable to quickly see the derived attributes for each table as part of their normal review process. What could the company's internal database administrators provide to the reviewers for proper examination?

	a.	A Crow's Foot model of the database.
	b.	A conceptual model of the database.
	c.	A Chen model of the database.
	d.	A UML model of the database.

When a database designer determines that two entities share the same primary keys in their relationship, what can the designer infer between the two?

	a.	weak relationship
	b.	optional relationship
	c.	Unary relationship
	d.	strong relationship

Although a student's registration form may list information gathered from the COURSE, CLASS, BUILDING, and ROOM table, which of the following would be the most accurate phrase describing these table's relationship with each other in an UML class diagram?

	a.	CLASSes in a BUILDING has multiple ROOMs
	b.	a COURSE generates CLASSes in a BUILDING
	c.	COURSEs in a BUILDING have ROOMs
	d.	a CLASS uses a ROOM in a BUILDING