5010 Quiz 2

disjointedness constraint

A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes.

integrity constraints.

A domain definition consists of the following components EXCEPT:

transitive dependency.

A functional dependency between two or more nonkey attributes is called a:

enterprise key.

A primary key whose value is unique across all relations is called a(n):

Second

A relation that contains no multivalued attributes and has nonkey attributes solely dependent on the primary key but contains transitive dependencies is in which normal form?

referential integrity constraint.

A rule that states that each foreign key value must match a primary key value in the other relation is called the:

the overlap rule.

The following figure shows an example of: ROOM | o CLASSROOM LAB OFFICE

generalization

The process of defining a more general entity type from a set of more specialized entity types is called:

specialization

The process of defining one or more subtypes of a supertype and forming relationships is called:

attribute inheritance.

The property by which subtype entities possess the values of all attributes of a supertype is called:

Part_Type.

The subtype discriminator in the figure below is: PART SUPPLIER MANUFACTERED PURCHASED SUPPLIES

only one supertype.

In a supertype/subtype hierarchy, each subtype has:

M:N relationships

In packaged data models, strong entities always have ________ between them.

must be a graduate student, an undergraduate, a special student or some other type of student.

In the figure below, a student:

disjoint

In the figure below, the patient must be either an outpatient or a resident patient.This is an example of the ________ rule.

Composite

In the figure below, the primary key for "Order Line" is which type of key?

Recursive foreign

In the figure below, what type of key is depicted? EmployeeID Name Date ManagerID

Strong entity/weak entity

In the figure below, what type of relationship do the relations depict? EmployeeID EmployeeName child | Name EMployeeID Bith gender

One-to-many

In the figure below, what type of relationship do the relations depict? StudentID Name Address Major RoomId Location StudentID |

Many-to-many

In the figure below, what type of relationship is depicted? StudentID Name address Major CourseID | StudentID | Semester Year CourseID description Credits

Outpatient

In the figure below, which of the following are subtypes of patient?

utilize all business rules that come with the packaged data model.

All of the following are steps to using a packaged data model EXCEPT:

primary key.

An attribute (or attributes) that uniquely identifies each row in a relation is called a:

foreign key.

An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a:

None of these.

An attribute of the supertype that determines the target subtype(s) is called the:

A component is always used in only one item.

Referring to the figure below, which of the following is NOT true?

there are attributes that apply to some but not all instances of an entity type.

Subtypes should be used when:

entity cluster.

The figure below is an example of a(n):

Ternary

The figure below is an example of mapping which type of relationship?

None of these.

The following diagram shows: EMPLOYEE | x SALARIED HOURLY CONULSTANT

partial specialization.

The following figure is an example of: ROOM | O CLASSROOM LABRATORY OFFICE

total specialization.

The following figure is an example of: ROOM || O CLASSROOM LABRATORY OFFICE

create two new relations, one containing the multivalued attribute.

When a regular entity type contains a multivalued attribute, one must:

first normal form.

When all multivalued attributes have been removed from a relation, it is said to be in:

entities

When identifying with the parts of the packaged data model that apply to your organization, you should first start with:

Total specialization

Which of the following is a completeness constraint?

A rental unit can be an apartment, a house or just a rental unit. It could be both an apartment and a house at the same time.

Which of the following statements is true about the figure shown below? RENTAL UNIT | o APARTMENT HOUSE

A rental unit must be either an apartment or a house and cannot be both at the same time.

Which of the following statements is true about the figure shown below? RENTAL UNIT || d APARTMENT HOUSE

All attributes of person and student are inherited by undergraduate.

Which statement is true about the following diagram? PERSON FACULTY STUDENT STAFF UNDERGRADUATE GRADUATE

Data integrity

________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.