When a regular entity type contains a multivalued attribute, two relations are created.

Chapter 4 Database Design Flashcards ionicons-v5-c

Physical

________ database specification indicates all the parameters for data storage that are theninput to database implementation.A) LogicalB) PhysicalC) SchematicD) Conceptual

security specifications

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

Tables

Data is represented in the form of:A) data trees.B) tables.C) data notes.D) chairs.

Relation

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

Data integrity

________ is a component of the relational data model included to specify business rules tomaintain the integrity of data when they are manipulated.A) Business rule constraintB) Data integrityC) Business integrityD) Data structure

primary key

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

Foreign Key

An attribute in a relation of a database that serves as the primary key of another relation in thesame database is called a:A) link attribute.B) link key.C) foreign key.D) foreign attribute.

Enterprise Key

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

Composite Key

A primary key that consists of MORE THAN ONE ATTRIBUTE IS CALLED A:A) foreign key.B) composite key.C) multivalued key.D) cardinal key.

create table

In the SQL language, the ________ statement is used to make table definitions.A) create sessionB) create tableC) create indexD) select

COMPOSITE

In the figure below, the primary key for "Order Line" is which type of key?A) CompositeB) ForeignC) StandardD) Grouped

integrity constraints.

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

No two rows in a relation are identical.

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

Sam Hinz

Which of the following violates the atomic property of relations?A) SamB) HinzC) Sam HinzD) Atomic

no primary key attribute can be null.

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

entity integrity rule

The ________ states that no primary key attribute may be null.A) referential integrity constraintB) entity integrity ruleC) partial specialization ruleD) range domain rule

Candidate

In the figure below, Customer_ID in the CUSTOMER Table is which type of key?A) CompositeB) CandidateC) StandardD) Grouped

Maximize Storage Pace

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

First normal form

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

Boyce-Codd normal form.

The normal form which removes any remaining functional dependencies because there wasmore than one primary key for the same nonkeys is called:A) fifth normal form.B) fourth normal form.C) Boyce-Codd normal form.D) sixth normal form.

fourth normal form.

The normal form which deals with multivalued dependencies is called:A) fifth normal form.B) fourth normal form.C) Boyce-Codd normal form.D) sixth normal form.

Second

A relation that contains no multivalued attributes and has nonkey attributes solely dependenton the primary key but contains transitive dependencies is in which normal form?A) FirstB) SecondC) ThirdD) Fourth

functional dependency

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

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

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

determinant.

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

partial functional

A functional dependency in which one or more nonkey attributes are functionally dependenton part, but not all, of the primary key is called a ________ dependency.A) partial key-basedB) partial functionalC) cross keyD) merged relation

transitive dependency.

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

Deletion

________ problems are encountered when removing data with transitive dependencies.A) InsertionB) ModificationC) DeletionD) Merging

merge

The need to ________ relations commonly occurs when different views need to beintegrated.A) metadataB) systemC) dropD) merge

synonyms

Two or more attributes having different names but the same meaning are called:A) homonyms.B) aliases.C) synonyms.D) alternate attributes.

homonym

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

alias.

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

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

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

descriptor

A nonkey attribute is also called a(n):A) column.B) unimportant datum.C) descriptor.D) address.

create two new relations, one containing the multivalued attribute.

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

Strong entity/weak entity

In the figure below, what type of relationship do the relations depict?A) Strong entity/weak entityB) MultivaluedC) Composite foreign keyD) One-to-many

one-to-Many

In the figure below, what type of relationship do the relations depict?A) Strong entity/weak entityB) One-to-manyC) TernaryD) Many-to-many

An associative entity

In the figure below, what is depicted?A) A one-to-one relationshipB) A unary relationshipC) A one-to-many relationshipD) An associative entity

Recursive foreign

In the figure below, what type of key is depicted?A) PrimaryB) Recursive primaryC) CompositeD) Recursive foreign

A component is always used in only one item.

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

Ternary

The figure below is an example of mapping which type of relationship?A) FirstB) SecondC) UnaryD) Ternary

Modification

________ are anomalies that can be caused by editing data in tables.A) InsertionB) DeletionC) ModificationD) Creation

well-structured

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

True

Data structures include data organized in the form of tables with rows and columns. T / F

referential integrity constraint.

A rule that states that each foreign key value must match a primary key value in the otherrelation is called the:A) referential integrity constraint.B) key match rule.C) entity key group rule.D) foreign/primary match rule.

TRUE.

In the figure below, each employee has exactly one manager.Answer : T / F

Discuss when it is best to create a surrogate key for an associative entity

Discuss the two possible scenarios when mapping an associative entity

What is an anomaly, and what are the three types of anomalies?