Question 1

Match each of the following terms with its corresponding definition.
-The address for each row is determined using an algorithm.
A)Calculated field
B)Data type
C)Default value
D)Denormalization
E)Field
F)Hashed file organization
G)Index
H)Index file organization
I)Pointer
J)Sequential file organization

Accepted Answer

The answer of Match each of the following terms with...

Question 2

Match each of the following terms with its corresponding definition.
-An attribute that appears as a nonprimary key attribute in one relation and as a primary key attribute (or part of a primary key) in another relation
A)Foreign key
B)Functional dependency
C)Homonym
D)Normalization
E)Recursive foreign key
F)Referential integrity
G)Relation
H)Relational database model
I)Second normal form (2NF)
J)Synonym
K)Third normal form (3NF)
L)Well-structured relation

Accepted Answer

A foreign key is an attribute that appears as a nonprimary key attribute in one relation and as a primary key attribute (or part of a primary key) in another relation.

Question 3

Match each of the following terms with its corresponding definition.
-A table used to determine the location of rows in a file that satisfy some condition
A)Calculated field
B)Data type
C)Default value
D)Denormalization
E)Field
F)Hashed file organization
G)Index
H)Index file organization
I)Pointer
J)Sequential file organization

Accepted Answer

An index is a table used to determine the location of rows in a file that satisfy some condition.

Note: The other terms do not match the definition given.

Question 4

Match each of the following terms with its corresponding definition.
-A particular relationship between two attributes, for every valid instance of A, that value of A uniquely determines the value of B.
A)Foreign key
B)Functional dependency
C)Homonym
D)Normalization
E)Recursive foreign key
F)Referential integrity
G)Relation
H)Relational database model
I)Second normal form (2NF)
J)Synonym
K)Third normal form (3NF)
L)Well-structured relation

Accepted Answer

The answer of Match each of the following terms with...

Question 5

Match each of the following terms with its corresponding definition.
-A value a field will assume unless an explicit value is entered for that field
A)Calculated field
B)Data type
C)Default value
D)Denormalization
E)Field
F)Hashed file organization
G)Index
H)Index file organization
I)Pointer
J)Sequential file organization

Accepted Answer

The answer of Match each of the following terms with...

Question 6

Match each of the following terms with its corresponding definition.
-A data model that represents data as a set of related tables or relations
A)Foreign key
B)Functional dependency
C)Homonym
D)Normalization
E)Recursive foreign key
F)Referential integrity
G)Relation
H)Relational database model
I)Second normal form (2NF)
J)Synonym
K)Third normal form (3NF)
L)Well-structured relation

Accepted Answer

The answer of Match each of the following terms with...

Question 7

Match each of the following terms with its corresponding definition.
-A named two-dimensional table of data
A)Foreign key
B)Functional dependency
C)Homonym
D)Normalization
E)Recursive foreign key
F)Referential integrity
G)Relation
H)Relational database model
I)Second normal form (2NF)
J)Synonym
K)Third normal form (3NF)
L)Well-structured relation

Accepted Answer

The answer of Match each of the following terms with...

Question 8

Match each of the following terms with its corresponding definition.
-The process of converting complex data structures into simple, stable data structures
A)Foreign key
B)Functional dependency
C)Homonym
D)Normalization
E)Recursive foreign key
F)Referential integrity
G)Relation
H)Relational database model
I)Second normal form (2NF)
J)Synonym
K)Third normal form (3NF)
L)Well-structured relation

Accepted Answer

Normalization is the process of converting complex data structures into simple, stable data structures.

Question 9

Match each of the following terms with its corresponding definition.
-A coding scheme recognized by system software for representing organizational data
A)Calculated field
B)Data type
C)Default value
D)Denormalization
E)Field
F)Hashed file organization
G)Index
H)Index file organization
I)Pointer
J)Sequential file organization

Accepted Answer

The answer of Match each of the following terms with...

Question 10

Match each of the following terms with its corresponding definition.
-A single attribute name that is used for two or more different attributes
A)Foreign key
B)Functional dependency
C)Homonym
D)Normalization
E)Recursive foreign key
F)Referential integrity
G)Relation
H)Relational database model
I)Second normal form (2NF)
J)Synonym
K)Third normal form (3NF)
L)Well-structured relation

Accepted Answer

A homonym in database terminology refers to a single attribute name that is used for two or more different attributes, leading to potential confusion.

Question 11

Match each of the following terms with its corresponding definition.
-The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields
A)Calculated field
B)Data type
C)Default value
D)Denormalization
E)Field
F)Hashed file organization
G)Index
H)Index file organization
I)Pointer
J)Sequential file organization

Accepted Answer

Denormalization is the process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields.

A) Calculated field - A field that derives its value from the computation of other fields

B) Data type - A classification identifying one of various types of data

C) Default value - A value that is automatically assigned to a field when no value has been specified

E) Field - A column or attribute in a relational database table

F) Hashed file organization - A method of organizing files in a way that allows for quick access to specific records based on a hashed value

G) Index - A data structure that improves the speed of data retrieval operations on a database table

H) Index file organization - A file organization technique that uses an index to organize and access data in a database file

I) Pointer - A variable that stores the memory address of another variable

J) Sequential file organization - A method of organizing files in a specific order, such as alphabetically or numerically, to improve the speed of data retrieval operations.

Question 12

Match each of the following terms with its corresponding definition.
-An integrity constraint that specifies that the value (or existence) of an attribute in one relation depends on the value (or existence) of the same attribute in another relation
A)Foreign key
B)Functional dependency
C)Homonym
D)Normalization
E)Recursive foreign key
F)Referential integrity
G)Relation
H)Relational database model
I)Second normal form (2NF)
J)Synonym
K)Third normal form (3NF)
L)Well-structured relation

Accepted Answer

The answer of Match each of the following terms with...

Question 13

Match each of the following terms with its corresponding definition.
-The smallest unit of named application data recognized by system software
A)Calculated field
B)Data type
C)Default value
D)Denormalization
E)Field
F)Hashed file organization
G)Index
H)Index file organization
I)Pointer
J)Sequential file organization

Accepted Answer

The smallest unit of named application data recognized by system software is a field.

Note: The other terms are defined as follows: 
A) Calculated field - a field in a database table that is created by performing a mathematical expression or function 
B) Data type - a classification for the type of data that a field represents (e.g. text, numeric, date) 
C) Default value - the value assigned to a field if no value is provided 
D) Denormalization - a technique of adding redundant data to a database for improved performance 
F) Hashed file organization - a file organization method where data is stored in a way that allows fast retrieval based on a key value 
G) Index - a data structure that provides fast lookup of data based on a key value 
H) Index file organization - a file organization method where data is organized in a way that allows fast retrieval based on a key value 
I) Pointer - a reference to a location in memory 
J) Sequential file organization - a file organization method where data is stored in a sequential order, typically by record or row.

Question 14

Match each of the following terms with its corresponding definition.
-A field that can be derived from other database fields
A)Calculated field
B)Data type
C)Default value
D)Denormalization
E)Field
F)Hashed file organization
G)Index
H)Index file organization
I)Pointer
J)Sequential file organization

Accepted Answer

The answer of Match each of the following terms with...

Question 15

Match each of the following terms with its corresponding definition.
-A relation is in this form if every nonprimary key attribute is functionally dependent on the whole primary key.
A)Foreign key
B)Functional dependency
C)Homonym
D)Normalization
E)Recursive foreign key
F)Referential integrity
G)Relation
H)Relational database model
I)Second normal form (2NF)
J)Synonym
K)Third normal form (3NF)
L)Well-structured relation

Accepted Answer

The answer of Match each of the following terms with...

Question 16

Match each of the following terms with its corresponding definition.
-A foreign key in a relation that references the primary key values of that same relation
A)Foreign key
B)Functional dependency
C)Homonym
D)Normalization
E)Recursive foreign key
F)Referential integrity
G)Relation
H)Relational database model
I)Second normal form (2NF)
J)Synonym
K)Third normal form (3NF)
L)Well-structured relation

Accepted Answer

The answer of Match each of the following terms with...

Question 17

Match each of the following terms with its corresponding definition.
-The rows in the file are stored in sequence according to a primary key value.
A)Calculated field
B)Data type
C)Default value
D)Denormalization
E)Field
F)Hashed file organization
G)Index
H)Index file organization
I)Pointer
J)Sequential file organization

Accepted Answer

The answer of Match each of the following terms with...

Question 18

Match each of the following terms with its corresponding definition.
-Two different names that are used for the same attribute
A)Foreign key
B)Functional dependency
C)Homonym
D)Normalization
E)Recursive foreign key
F)Referential integrity
G)Relation
H)Relational database model
I)Second normal form (2NF)
J)Synonym
K)Third normal form (3NF)
L)Well-structured relation

Accepted Answer

Synonym refers to two different names that are used for the same attribute.

Question 19

Match each of the following terms with its corresponding definition.
-The rows are stored either sequentially or nonsequentially, and a table is created that allows software to locate individual rows.
A)Calculated field
B)Data type
C)Default value
D)Denormalization
E)Field
F)Hashed file organization
G)Index
H)Index file organization
I)Pointer
J)Sequential file organization

Accepted Answer

The answer of Match each of the following terms with...

Question 20

Match each of the following terms with its corresponding definition.
-A relation is in this form if it is in second normal form and no transitive dependencies exist.
A)Foreign key
B)Functional dependency
C)Homonym
D)Normalization
E)Recursive foreign key
F)Referential integrity
G)Relation
H)Relational database model
I)Second normal form (2NF)
J)Synonym
K)Third normal form (3NF)
L)Well-structured relation

Accepted Answer

The answer of Match each of the following terms with...

Quiz 9: Designing Databases

Match each of the following terms with its corresponding definition. -The address for each row is determined using an algorithm.

Match each of the following terms with its corresponding definition. -An attribute that appears as a nonprimary key attribute in one relation and as a primary key attribute (or part of a primary key) in another relation

Match each of the following terms with its corresponding definition. -A table used to determine the location of rows in a file that satisfy some condition

Match each of the following terms with its corresponding definition. -A particular relationship between two attributes, for every valid instance of A, that value of A uniquely determines the value of B.

Match each of the following terms with its corresponding definition. -A value a field will assume unless an explicit value is entered for that field

Match each of the following terms with its corresponding definition. -A data model that represents data as a set of related tables or relations

Match each of the following terms with its corresponding definition. -A named two-dimensional table of data

Match each of the following terms with its corresponding definition. -The process of converting complex data structures into simple, stable data structures

Match each of the following terms with its corresponding definition. -A coding scheme recognized by system software for representing organizational data

Match each of the following terms with its corresponding definition. -A single attribute name that is used for two or more different attributes

Match each of the following terms with its corresponding definition. -The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields

Match each of the following terms with its corresponding definition. -An integrity constraint that specifies that the value (or existence) of an attribute in one relation depends on the value (or existence) of the same attribute in another relation

Match each of the following terms with its corresponding definition. -The smallest unit of named application data recognized by system software

Match each of the following terms with its corresponding definition. -A field that can be derived from other database fields

Match each of the following terms with its corresponding definition. -A relation is in this form if every nonprimary key attribute is functionally dependent on the whole primary key.

Match each of the following terms with its corresponding definition. -A foreign key in a relation that references the primary key values of that same relation

Match each of the following terms with its corresponding definition. -The rows in the file are stored in sequence according to a primary key value.

Match each of the following terms with its corresponding definition. -Two different names that are used for the same attribute

Match each of the following terms with its corresponding definition. -The rows are stored either sequentially or nonsequentially, and a table is created that allows software to locate individual rows.

Match each of the following terms with its corresponding definition. -A relation is in this form if it is in second normal form and no transitive dependencies exist.