CIS 305 Chapter 4 Quiz

relation

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

maximize storage space

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.

alias

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

primary key.

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

homonym

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

tables

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

Recursive foreign

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

entity integrity rule

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

determinant

The attribute on the left-hand side of the arrow in a functional dependency is the: primary key. determinant. foreign key. candidate key.

Ternary

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

merge

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

synonyms

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

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

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.

create two new relations, one containing the multivalued attribute.

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.

first normal form

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.

No two rows in a relation are identical.

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.

Sample data can reverse database implementation errors.

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.

Sam Hinz

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

Modification

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

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

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.

functional dependency.

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

integrity constraints

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

logical specifications

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

transitive dependency

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

partial functional

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

descriptor

A nonkey attribute is also called a(n):

composite key

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

enterprise 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.

well-structured.

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

Second

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

referential integrity constraint

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.

foreign attribute.

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.

create table

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

Composite

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

A one-to-many relationship

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

Strong entity/weak entity

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

One-to-many

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

A component is always used in only one item.

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.

no primary key attribute can be null.

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.

fourth normal form

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

Boyce-Codd normal form.

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.

Physical

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

Data integrity

________ 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

Deletion

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