Ready to test your Knowledge?
Try out our new practice tests completely free!
exam preparation banner icon

Modern Database Management Study Set 2

Computing

Quiz 3 :

The Enhanced E-R Model

Quiz 3 :

The Enhanced E-R Model

Question Type
search
arrow
In the figure below, a student: img
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
The process of defining one or more subtypes of a supertype and forming relationships is called:
Free
Multiple Choice
Answer:

Answer:

A

Tags
Choose question tag
close menu
arrow
In the figure below, which of the following apply to both OUTPATIENTs and RESIDENT_PATIENTs? img
Free
Multiple Choice
Answer:

Answer:

C

Tags
Choose question tag
close menu
arrow
In the figure below, which of the following is a subtype of patient? img
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Given the following entities, which of the choices below would be the most complicated? Automobile: VIN, EngineSize, NumberOfDoors, NumberOfPassengers, FuelType, Transmission SUV: VIN, EngineSize, NumberOfPassengers, NoWheelDrive, FuelType, Transmission Truck: VIN, EngineSize, NoWheelDrive, FuelType, Transmission, Payload
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which of the following is a generic entity type that has a relationship with one or more subtypes?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The process of defining a more general entity type from a set of more specialized entity types is called:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A(n) ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The property by which subtype entities possess the values of all attributes of a supertype is called:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The following figure is an example of: img
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The ________ rule states that an entity instance can simultaneously be a member of two (or more) subtypes.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
An attribute of the supertype that determines the target subtype(s) is called the:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Which of the following is a completeness constraint?
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
In the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized? img
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
The ________ rule specifies that an entity can be a member of only one subtype at a time.
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
Subtypes should be used when:
Multiple Choice
Answer:
Tags
Choose question tag
close menu
arrow
In the figure below, the patient must be either an outpatient or a resident patient. This is an example of the ________ rule. img
Multiple Choice
Answer:
Tags
Choose question tag
close menu
Showing 1 - 20 of 102