BTMA 331 Quiz 3 Relational Schema

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

A)  Recursive foreign

B)  Recursive primary

C)  Composite

D)  Primary

A

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

A)  column.

B)  duplicate key.

C)  primary key.

D)  foreign field.

C

The entity integrity rule states that:

A)  each entity must have a primary key.

B)  referential integrity must be maintained across all entities.

C)  a primary key must have only one attribute.

D)  no primary key attribute can be null.

D

Which of the following are properties of relations?

A)  Each attribute has the same name.

B)  There are multivalued attributes in a relation.

C)  No two rows in a relation are identical.

D)  All columns are numeric.

C

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

A)  Multivalued

B)  One-to-many

C)  Composite foreign key

D)  Identifying entity/weak entity

D

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

A)  entity key group rule.

B)  key match rule.

C)  referential integrity constraint.

D)  foreign/primary match rule.

C

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

A)  Unary

B)  First

C)  Second

D)  Ternary

D

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

A)  each nonkey attribute is functionally dependent upon it.

B)  the key must be nonredundant.

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

D)  the key must uniquely identify the row.

C

Data is represented in the form of:

A)  data notes.

B)  tables.

C)  chairs.

D)  data trees.

B

In the figure below, what is depicted?

A)  A one-to-many relationship

B)  An associative entity

C)  A one-to-one relationship

D)  A unary relationship

B

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

A)  referential integrity constraint

B)  range domain rule

C)  entity integrity rule

D)  partial specialization rule

C

________ anomalies can be caused by editing data in tables.

A)  Insertion

B)  Creation

C)  Deletion

D)  Modification

D

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

A)  logical designs.

B)  physical design.

C)  security design.

D)  response designs.

A

The normal form which removes any remaining functional dependencies because there was more than one primary key for the same nonkeys is called:

A)  Boyce-Codd normal form.

B)  fourth normal form.

C)  sixth normal form.

D)  fifth normal form.

A

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

A)  Many-to-many

B)  One-to-many

C)  Identifying entity/weak entity

D)  Ternary

B

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

A)  attribute dependency.

B)  functional relation.

C)  functional dependency.

D)  functional relation constraint.

C

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

A)  third normal form.

B)  Boyce-Codd normal form.

C)  second normal form.

D)  first normal form.

D

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

A)  create two new relations, one containing the multivalued attribute.

B)  delete the relation and start over.

C)  create two new relations, both containing the multivalued attribute.

D)  create a single relation with multiple lines for each instance of the multivalued attribute.

A

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

A)  A component may be used in many items.

B)  A component can be part of an item.

C)  A component is part of an item.

D)  A component is always used in only one item.

D

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

A)  Grouped

B)  Candidate

C)  Standard

D)  Composite

B

The normal form which deals with multivalued dependencies is called:

A)  Boyce-Codd normal form.

B)  fourth normal form.

C)  sixth normal form.

D)  fifth normal form.

B

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

A)  link attribute.

B)  link key.

C)  foreign key.

D)  foreign attribute.

C

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

A)  synonym.

B)  related characteristic.

C)  alternate attribute.

D)  alias.

D

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

A)  Sample data can be used to improve user communications.

B)  Sample data can reverse database implementation errors.

C)  Sample data provide a convenient way to check the accuracy of your design.

D)  Sample data can be used for prototype generation

B

A two-dimensional table of data sometimes is called a:

A)  declaration.

B)  group.

C)  set.

D)  relation.

D

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

A)  foreign key.

B)  determinant.

C)  candidate key.

D)  primary key.

B

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

A)  complex.

B)  simple.

C)  well-structured.

D)  clean.

C

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?

A)  First

B)  Second

C)  Third

D)  Fourth

B

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

A)  transitive dependency.

B)  partial transitive dependency.

C)  partial functional dependency.

D)  partial nonkey dependency.

A

________ is the maintenance and assurance of the accuracy and consistency of data over its entire life-cycle, ensuring it remains unaltered and uncorrupted from creation and storage to retrieval and processing.

A)  Data integrity

B)  Business integrity

C)  Business rule constraint

D)  Data structure

A

A domain definition consists of all of the following components EXCEPT:

A)  data type.

B)  integrity constraints.

C)  domain name.

D)  size.

B

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.

A)  partial key-based

B)  partial functional

C)  cross key

D)  merged relation

B

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

A)  Standard

B)  Grouped

C)  Foreign

D)  Composite

D

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

A)  simplify the enforcement of referential integrity.

B)  make it easier to maintain data.

C)  minimize data redundancy.

D)  maximize storage space.

D

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

A)  cardinal key.

B)  foreign key.

C)  multivalued key.

D)  composite key.

D