Quiz 3

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 below, what is depicted?

An associative entity

In the figure below, Customer_ID in the CUSTOMER Table is which type of key?

Candidate

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

Composite

In the following diagram, which answer is true?

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

In the figure below, what type of relationship do the relations depict?

Strong entity/weak entity

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

Ternary

In the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized?

Vehicle

An alternative name for an attribute is called a(n):

alias.

A person's name, birthday, and social security number are all examples of:

attributes.

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

composite

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

composite identifier.

A primary key that consists of more than one attribute is called a:

composite key.

Data modeling may be the most important part of the systems development process because:

data characteristics are important in the design of programs and other systems components.

The ________ states that no primary key attribute may be null.

entity integrity rule

A(n) ________ is the relationship between a weak entity type and its owner.

identifying relationship

A form of database specification which maps conceptual requirements is called:

logical specifications.

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.

mandatory one

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

The following figure shows a:

supertype/subtype hierarchy.

Data is represented in the form of:

tables

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

ternary

A candidate key must satisfy all of the following conditions EXCEPT:

the key must indicate the row's position in the table.

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

weak

A good data definition will describe all of the characteristics of a data object EXCEPT:

who can delete the data.