Chapter 1-4 Quiz Questions

For the relationship represented in the figure below, which of the following is true?

A department can have more than one employee.

In the figure shown below, which of the following is true?

A person can marry at most one person.

Which of the following statements is true about the figure shown below?

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?

A rental unit can be an apartment, house or just a rental unit; it may not be more than one at the same time.

Which of the following statements is true about the figure shown below?

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?

A rental unit must be either an apartment or a house, and could be both.

Which statement is true about the following diagram?

All attributes of person and student are inherited by undergraduate.

Which of the following conditions should exist if an associative entity is to be created?

All the relationships for the participating entities are many-to-many.

In the following diagram, which of the answers below is true?

Both Each patient has one or more patient histories and Each patient history belongs to one and only one patient

In the following diagram, which answer is true?

Each employee can supervise one employee, no employees or many employees.

The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype, it MUST simultaneously be a member of another subtype.

False

Why is GPA (Grade Point Average) not considered an entity?

It is being calculated based on other data and can change over time.

Which of the following is not an entity?

Manager

Which of the following figures corresponds to the "Patient" entity?

Mandatory one on the Patient side with Patient ID as primary key and name as attribute. Optional many on the Patient-Symptoms side with Patient ID and Symptom ID as the primary keys, and Severity as attribute.

In the figure below, which of the following is not in relationship with "BED" entity?

Outpatient

The subtype discriminator in the figure below is:

Part_Type

Which of the following is NOT an advantage of database systems?

Redundant data

In the figure below, which attribute is multivalued?

Skill

For the following diagram, which one of the following is a proper discriminator attribute?

Student_Type

Which of the following types of data can be stored in a database?

Voice, Numbers, and Letters

The following figure what type of attribute is "Address" attribute:

a composite attribute

The following figure shows an example of:

a strong entity and its associated weak entity.

A business rule:

all of these

The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the ________ phase.

analysis

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

attribute inheritance.

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.

cardinality constraint

A ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype.

completeness

An attribute that can be broken down into smaller parts is called a(n) ________ attribute.

composite

In the following diagram, the discriminator attribute is a _____________ attribute.

composite

An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):

composite identifier

A graphical system used to capture the nature and relationships among data is called a(n):

data model

One application of data warehouses is:

decision support

The number of entity types that participate in a relationship is called the:

degree

The total quiz points for a student for an entire semester is a(n) ________ attribute.

derived

The ________ rule specifies that an entity can be a member of only one subtype at a time.

disjoint

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

disjointedness constraint

Database development begins with ________, which establishes the range and general contents of organizational databases.

enterprise data modeling

A member of a subtype does NOT necessarily have to be a member of the supertype.

false

A well-structured database establishes the entities between relationships in order to derive the desired information.

false

Based on the following diagram, a room cannot be a classroom and a laboratory at the same time.

false

Subtypes at the lowest level of a hierarchy do not inherit attributes from their ancestors.

false

The degree of a relationship is the number of attributes that are associated with it.

false

The SDLC phase in which database processing programs are created is the ________ phase.

implementation

Which of the following is NOT a cost and/or risk of the database approach?

improved responsiveness

One disadvantage of file processing systems is:

limited data sharing

A database is an organized collection of ________ related data.

logically

A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship.

many-to-many

Data that describe the properties of other data are:

meta-data

In the figure below, a student:

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

In a supertype/subtype hierarchy, each subtype has:

only one supertype

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

outpatient

The following figure is an example of:

partial specialization

All of the following are properties of metadata EXCEPT:

processing logic

All of the following are primary purposes of a database management system (DBMS) EXCEPT:

providing an integrated development environment

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):

repository

In a supertype/subtype hierarchy, subtypes that are lower in the hierarchy inherit attributes from not only their immediate supertype but from all ________ in the hierarchy.

supertypes

A simultaneous relationship among the instances of three entity types is called a(n) ________ relationship.

ternary

Subtypes should be used when:

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

The following figure is an example of:

total specialization.

A relational database establishes the relationships between entities by means of a common field.

true

A subtype can become a supertype if the subtype has other subtypes beneath it.

true

In prototyping, implementation and maintenance activities are repeated as necessary until the product is correct.

true

Redundancy increases the risk of inconsistent data.

true

The overlap rule specifies that if an entity instance of the supertype is a member of one subtype, it can simultaneously be a member of two (or more) subtypes.

true

An entity type whose existence depends on another entity type is called a ________ entity.

weak

In the figure below, which attribute is derived?

Years_Employed