Deck 4: Logical Database Design and the Relational Model

Question 1

Understanding the steps involved in transforming EER diagrams into relations is important because:

A) you 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) none of the above.

Answer 1

A

Question 2

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

A) Composite
B) Foreign
C) Standard
D) Grouped

Answer 2

A

Question 3

________ is a component of the relational data model included to specify business rules to maintain the integrity of data when they are manipulated.

A) Business rule constraint
B) Data integrity
C) Business integrity
D) Data structure

Answer 3

B

Question 4

A domain definition consists of the following components EXCEPT:

A) domain name.
B) data type.
C) integrity constraints.
D) size.

Question 5

Physical database design decisions must be made carefully because of impacts on:

A) data accessibility.
B) response times.
C) security.
D) all of the above.

Question 6

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.

Question 7

Which of the following are properties of relations?

A) Each attribute has a unique name.
B) No two rows in a relation are identical.
C) There are no multivalued attributes in a relation.
D) All of the above.

Question 8

A nonkey attribute is also called a(n):

A) column.
B) unimportant datum.
C) descriptor.
D) address.

Question 9

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

A) referential integrity constraint.
B) key match rule.
C) entity key group rule.
D) foreign/primary match rule.

Question 10

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.

Question 11

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.

Question 12

A two-dimensional table of data is called a:

A) group.
B) set.
C) declaration.
D) relation.

Question 13

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 be used for prototype generation.
C) Sample data can reverse database implementation errors.
D) Sample data provide a convenient way to check the accuracy of your design.

Question 14

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

A) referential integrity constraint
B) entity integrity rule
C) partial specialization rule
D) range domain rule

Question 15

Which of the following are anomalies that can be caused by redundancies in tables?

A) Insertion
B) Deletion
C) Modification
D) All of the above

Question 16

In the SQL language,the ________ statement is used to make table definitions.

A) create session
B) create table
C) create index
D) select

Question 17

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

A) clean.
B) simple.
C) complex.
D) well-structured.

Question 18

The relational data model consists of which components?

A) Data structure
B) Data manipulation
C) Data integrity
D) All of the above

Question 19

A form of database specification that indicates all the parameters for data storage that are then input to database implementation is:

A) logical.
B) physical.
C) schematic.
D) conceptual.

Question 20

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.

Question 21

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

A) Strong entity/weak entity
B) Multivalued
C) Composite foreign key
D) One-to-many

Question 22

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

Question 23

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.

Question 24

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

Question 25

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.

Question 26

Two or more attributes having different names but the same meaning are called:

A) homonyms.
B) aliases.
C) synonyms.
D) alternate attributes.

Question 27

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) none of the above.

Question 28

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.

Question 29

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

A) First
B) Second
C) Unary
D) Ternary

Question 30

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.

Question 31

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.

Question 32

The normal form which removes any remaining functional dependencies because there was more 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.

Question 33

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

A) Primary
B) Recursive primary
C) Composite
D) Recursive foreign

Question 34

Which of the following anomalies result from a transitive dependency?

A) Insertion
B) Modification
C) Deletion
D) All of the above

Question 35

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

Question 36

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

A) Strong entity/weak entity
B) One-to-many
C) Ternary
D) Many-to-many

Question 37

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

A) One-to-one
B) Unary
C) One-to-many
D) Many-to-many

Question 38

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

A) functional relation.
B) attribute dependency.
C) functional dependency.
D) functional relation constraint.

Question 39

An understanding of how to merge relation is important because:

A) there may be a need to merge relations on projects with subteams.
B) different views may need to be integrated.
C) new data requirements may produce new relations to be merged.
D) all of the above.

Question 40

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.

Question 41

The entity integrity rule states that a primary key attribute can be null.

Question 42

A referential integrity constraint is a rule that maintains consistency among the rows of two relations.

Question 43

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

Question 44

There can be multivalued attributes in a relation.

Question 45

Unlike columns,the rows of a relation may not be interchanged and must be stored in one sequence.

Question 46

A cascading delete removes all records in other tables associated with the record to be deleted.

Question 47

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

A) synonym.
B) alias.
C) alternate attribute.
D) related characteristic.

Question 48

An attribute that may have more than one meaning is called a(n):

A) homonym.
B) alias.
C) double defined attribute.
D) synonym.

Question 49

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.

Question 50

One property of a relation is that each attribute within a relation has a unique name.

Question 51

A foreign key is a primary key of a relation that also is a primary key in another relation.

Question 52

Data integrity consists of powerful operations to manipulate data stored in relations.

Question 53

Sample data are useful for developing prototype applications and for testing queries.

Question 54

A composite key consists of only one attribute.

Question 55

The columns of a relation can be interchanged without changing the meaning or use of the relation.

Question 56

All values that appear in a column of a relation must be taken from the same domain.

Question 57

The truncate table statement in SQL creates a new table.

Question 58

In the relational data model,associations between tables are defined through the use of primary keys.

Question 59

A primary key is an attribute that uniquely identifies each row in a relation.

Question 60

The allowable range of values for a given attribute is part of the domain constraint.

Question 61

When transforming a one-to-one relationship,a new relation is always created.

Question 62

An anomaly is a type of flaw in the database server.

Question 63

A candidate key is an attribute,or combination of attributes,that uniquely identifies a row in a relation.

Question 64

A transversal dependency is a functional dependency between two or more nonkey attributes.

Question 65

When transforming a weak entity,one should create one relation with both the attributes of the strong entity and the attributes of the weak entity.

Question 66

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

Question 67

CASE tools can model more complex data relationships,such as ternary relationships.

Question 68

A partial functional dependency is a functional dependency in which one or more non-key attributes are functionally dependent on part (but not all)of the primary key.

Question 69

An identifier assigned to an associative entity is also called a cross-relation key.

Question 70

When normalizing,the goal is to decompose relations with anomalies to produce smaller,well-structured relations.

Question 71

A relation is in first normal form if it has no more than one multivalued attribute.

Question 72

A relation in fifth normal form may not contain any anomalies.

Question 73

The primary key of the many side migrates to the one side when transforming a one-to-many relationship.

Question 74

In the figure below,each employee has exactly one manager.

Question 75

When transforming a unary many-to-many relationship to relations,a recursive foreign key is used.

Question 76

Anomalies do not generally arise out of transitive dependencies.

Question 77

A well-structured relation contains minimal redundancy and allows users to manipulate the relation without errors or inconsistencies.

Question 78

The relational data model does at this time directly support subtype/supertype relationships.

Question 79

If an identifier is not assigned,the default primary key for an associative relation consists of the two primary key attributes from the other two relations.

Question 80

A co-dependency is a constraint between two attributes or two sets of attributes.