CIS 305 Chapter 4 Quiz

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

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

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

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

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

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

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

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.

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

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

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.

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

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

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.

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.

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

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.

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

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

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

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

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

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

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

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

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.

________ 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

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.

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

An alternative name for an attribute is called a(n): synonym. alias. related characteristic. alternate 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.

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

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

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

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.

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

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

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

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

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

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.

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.

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.

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 nonkey attribute is also called a(n):