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.
