Database chp4 - test

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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

A component is always used in only one item.

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

Composite

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

Data integrity

An attribute that may have more than one meaning is called a(n)

homonym.

A domain definition consists of the following components EXCEPT:

integrity constraints.

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

one to many

Two or more attributes having different names but the same meaning are called:

synonyms

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

transitive dependency.

The relational data model consists of which components?

All of these

Physical database design decisions must be made carefully because of impacts on:

All of these.

in the figure below, what type of relationship is depicted?

Many-to-many

In the figure below, what type of key is depicted?

Recursive foreign

Which of the following is NOT a reason to create an instance of a relational schema with sample data?

Sample data can reverse database implementation errors.

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?

Second

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

Strong entity/weak entity

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

alias

Which of the following anomalies result from a transitive dependency?

all

Which of the following are anomalies that can be caused by redundancies in tables?

all

Which of the following are properties of relations?

all

An understanding of how to merge relations is important because:

all of these

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

composite key.

In the SQL language, the ________ statement is used to make table definitions.

create table

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

create two new relations, one containing the multivalued attribute.

A nonkey attribute is also called a(n):

descriptor.

The attribute on the left-hand side of the arrow in a functional dependency is the

determinant.

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

entity integrity rule

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

first normal form

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

foreign key.

A constraint between two attributes is called a(n):

functional dependency

All of the following are the main goals of normalization EXCEPT:

maximize storage space.

The entity integrity rule states that:

no primary key attribute can be null.

A functional dependency in which one or more nonkey attributes are functionally dependent on part, but not all, of the primary key is called a ________ dependency.

partial functional

A form of database specification that indicates all the parameters for data storage that are then input to database implementation is:

physical.

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

primary key.

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

referential integrity constraint.

A two-dimensional table of data is called a:

relation.

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

ternary

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

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

A relation that contains minimal redundancy and allows easy use is considered to be:

well-structured

Understanding the steps involved in transforming EER diagrams into relations is important because:

you must be able to check the output of a CASE tool.


Ensembles d'études connexes

Mastering Biology HHMI: Got Lactase?

View Set

Abnormal Psych. Exam 3 Study Guide

View Set

Business English Quiz Questions - Review

View Set

IDS 301: Intro to Interdisciplinary Studies

View Set

Individual and group decision making

View Set