CIS 305 Chapter 4 Quiz

In the figure below, what is depicted? A one-to-one relationship A one-to-many relationship A unary relationship An associative entity

A one-to-many relationship

In the figure below, Customer_ID in the CUSTOMER Table is which type of key? Grouped Candidate Composite Standard

Composite

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

Composite

The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called: Boyce-Codd normal form. fourth normal form. fifth normal form. sixth normal form.

Boyce-Codd normal form.

________ problems are encountered when removing data with transitive dependencies. Modification Insertion Merging Deletion

Deletion

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

transitive dependency

A relation that contains minimal redundancy and allows easy use is considered to be: complex. well-structured. clean. simple.

well-structured.

Two or more attributes having different names but the same meaning are called: alternate attributes. synonyms. homonyms. aliases.

synonyms

Data is represented in the form of: data trees. data notes. tables. chairs.

tables

________ are anomalies that can be caused by editing data in tables. Deletion Modification Creation Insertion

Modification

Which of the following are properties of relations? No two rows in a relation are identical. All columns are numeric. Each attribute has the same name. There are multivalued attributes in a relation.

No two rows in a relation are identical.

Which of the following violates the atomic property of relations? Hinz Sam Atomic Sam Hinz

Sam Hinz

Which of the following is NOT a reason to create an instance of a relational schema with sample data? Sample data provide a convenient way to check the accuracy of your design. Sample data can be used for prototype generation. Sample data can reverse database implementation errors. Sample data can be used to improve user communications.

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? First Second Third Fourth

Second

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

composite key

A primary key whose value is unique across all relations is called a(n): global primary key. inter-table primary key. foreign global key. enterprise key.

enterprise key

The ________ states that no primary key attribute may be null. range domain rule referential integrity constraint entity integrity rule partial specialization rule

entity integrity rule

When all multivalued attributes have been removed from a relation, it is said to be in: Boyce-Codd normal form. second normal form. third normal form. first normal form.

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: link key. foreign attribute. foreign key. link attribute.

foreign attribute.

The normal form which deals with multivalued dependencies is called: fifth normal form. fourth normal form. sixth normal form. Boyce-Codd normal form.

fourth normal form

A constraint between two attributes is called a(n): functional relation constraint. functional dependency. functional relation. attribute dependency.

functional dependency.

An attribute that may have more than one meaning is called a(n): alias. synonym. double defined attribute. homonym.

homonym

A domain definition consists of all of the following components EXCEPT: domain name. integrity constraints. size. data type.

integrity constraints

A form of database specification which maps conceptual requirements is called: security specifications. logical specifications. physical specifications. response specifications.

logical specifications

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. merged relation cross key partial functional partial key-based

partial functional

An attribute (or attributes) that uniquely identifies each row in a relation is called a: primary key. duplicate key. column. foreign field.

primary key.

A rule that states that each foreign key value must match a primary key value in the other relation is called the: key match rule. foreign/primary match rule. entity key group rule. referential integrity constraint.

referential integrity constraint

A two-dimensional table of data sometimes is called a: set. declaration. relation. group.

relation

Referring to the figure below, which of the following is NOT true? A component can be part of an item. A component may be used in many items. A component is always used in only one item. A component is part of an item.

A component is always used in only one item.

________ 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 Business integrity Business rule constraint Data structure

Data integrity

In the figure below, what type of relationship do the relations depict? Ternary Strong entity/weak entity One-to-many Many-to-many

One-to-many

________ database specification indicates all the parameters for data storage that are then input to database implementation. Conceptual Physical Schematic Logical

Physical

In the figure below, what type of key is depicted? Primary Composite Recursive foreign Recursive primary

Recursive foreign

In the figure below, what type of relationship do the relations depict? Strong entity/weak entity Composite foreign key One-to-many Multivalued

Strong entity/weak entity

The figure below is an example of mapping which type of relationship? Second Ternary Unary First

Ternary

An alternative name for an attribute is called a(n): synonym. alias. related characteristic. alternate attribute.

alias

In the SQL language, the ________ statement is used to make table definitions. create table select create index create session

create table

When a regular entity type contains a multivalued attribute, one must: create two new relations, one containing the multivalued attribute. create two new relations, both containing the multivalued attribute. create a single relation with multiple lines for each instance of the multivalued attribute. delete the relation and start over.

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: primary key. determinant. foreign key. candidate key.

determinant

All of the following are the main goals of normalization EXCEPT: simplify the enforcement of referential integrity. maximize storage space. minimize data redundancy. make it easier to maintain data.

maximize storage space

The need to ________ relations commonly occurs when different views need to be integrated. system merge drop metadata

merge

The entity integrity rule states that: a primary key must have only one attribute. each entity must have a primary key. no primary key attribute can be null. referential integrity must be maintained across all entities.

no primary key attribute can be null.

Understanding the steps involved in transforming EER diagrams into relations is important because: there are rarely legitimate alternatives from which to choose. CASE tools can model any situation. CASE tools model hypothetical business problems. one must be able to check the output of a CASE tool.

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

A candidate key must satisfy all of the following conditions EXCEPT: the key must uniquely identify the row. the key must indicate the row's position in the table. the key must be nonredundant. each nonkey attribute is functionally dependent upon it.

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