Question 1

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)indexed file organization
I)pointer
J)sequential file organization

Accepted Answer

Indexed file organization is a method where a table is created to allow software to locate individual rows, which can be stored either sequentially or nonsequentially.

Question 2

Match each of the following E-R structures with its relational representation.
-Create a relation with a composite primary key using the primary keys of the related entities,plus any nonkey attributes of the relationship or associative entity.
A)regular entity
B)weak entity
C)binary or unary 1:1 relationship
D)binary 1:N relationship
E)binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key

Accepted Answer

In a binary or unary M:N relationship or associative entity, a relation is created with a composite primary key using the primary keys of the related entities, plus any nonkey attributes of the relationship or associative entity.

Question 3

Match each of the following terms with its corresponding definition.
-A data model that represents data in the form of tables or relations.
A)foreign key
B)functional dependency
C)homonym
D)recursive foreign key
E)referential integrity
F)relation
G)relational database model
H)synonym
I)well-structured relation

Accepted Answer

The relational database model is a data model that represents data in the form of tables or relations.

Question 4

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)indexed 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, allowing for faster retrieval of data.

Question 5

Match each of the following E-R structures with its relational representation.
-Create a relation with the primary key associated with the relationship or associative entity,plus any nonkey attributes of the relationship or associative entity and the primary keys of the related entities.
A)regular entity
B)weak entity
C)binary or unary 1:1 relationship
D)binary 1:N relationship
E)binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key

Accepted Answer

The answer of Match each of the following E-R structures...

Question 6

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)recursive foreign key
E)referential integrity
F)relation
G)relational database model
H)synonym
I)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.
-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)indexed 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.

Question 8

Match each of the following terms with its corresponding definition.
-A relation that contains a minimum amount of redundancy and allows users to insert,modify,and delete the rows in a table without errors or inconsistencies.
A)foreign key
B)functional dependency
C)homonym
D)recursive foreign key
E)referential integrity
F)relation
G)relational database model
H)synonym
I)well-structured relation

Accepted Answer

A well-structured relation is a relation that contains a minimum amount of redundancy and allows users to insert, modify, and delete the rows in a table without errors or inconsistencies.

Question 9

Match each of the following E-R structures with its relational representation.
-Create a relation with a composite primary key that includes the primary key of the entity on which this entity depends and nonkey attributes.
A)regular entity
B)weak entity
C)binary or unary 1:1 relationship
D)binary 1:N relationship
E)binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key

Accepted Answer

A weak entity depends on another entity, so its primary key includes the primary key of the entity on which it depends. It also includes nonkey attributes.

Answer: E
 A M:N relationship or associative entity also depends on other entities, so its primary key includes the primary keys of those entities. It also includes nonkey attributes. The associative entity itself may also have its own primary key.

Question 10

Match each of the following terms with its corresponding definition.
-A single name that is used for two or more different attributes.
A)foreign key
B)functional dependency
C)homonym
D)recursive foreign key
E)referential integrity
F)relation
G)relational database model
H)synonym
I)well-structured relation

Accepted Answer

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

Question 11

Match each of the following E-R structures with its relational representation.
-Place the primary key of the entity on the one side of the relationship as a foreign key in the relation for the entity on the many side.
A)regular entity
B)weak entity
C)binary or unary 1:1 relationship
D)binary 1:N relationship
E)binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key

Accepted Answer

The answer of Match each of the following E-R structures...

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)recursive foreign key
E)referential integrity
F)relation
G)relational database model
H)synonym
I)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 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)indexed file organization
I)pointer
J)sequential file organization

Accepted Answer

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

Question 14

Match each of the following terms with its corresponding definition.
-A field of data that can be used to locate a related field or row of data.
A)calculated field
B)data type
C)default value
D)denormalization
E)field
F)hashed file organization
G)index
H)indexed 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 particular relationship between two attributes.For every valid instance of A,the value of A uniquely determines the value of B.
A)foreign key
B)functional dependency
C)homonym
D)recursive foreign key
E)referential integrity
F)relation
G)relational database model
H)synonym
I)well-structured relation

Accepted Answer

A functional dependency is a relationship where the value of one attribute (A) uniquely determines the value of another attribute (B).

Question 16

Match each of the following terms with its corresponding definition.
-Two different names that are used to refer to the same data item.
A)foreign key
B)functional dependency
C)homonym
D)recursive foreign key
E)referential integrity
F)relation
G)relational database model
H)synonym
I)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)indexed file organization
I)pointer
J)sequential file organization

Accepted Answer

Sequential file organization refers to the storage of rows in a file in a sequence based on a primary key value.

Question 18

Match each of the following terms with its corresponding definition.
-An attribute that appears as a nonkey 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)recursive foreign key
E)referential integrity
F)relation
G)relational database model
H)synonym
I)well-structured relation

Accepted Answer

B) functional dependency: A relationship between two attributes in which one attribute determines the value of another attribute.
C) homonym: Different attributes that have the same name in a database schema.
D) recursive foreign key: A foreign key that refers back to the same relation.
E) referential integrity: A set of rules that ensures that the relationships among data in related tables are valid and that data is not lost due to changes in the database.
F) relation: A table with rows and columns that represents an entity or relationship in the database.
G) relational database model: A database model that organizes data into one or more tables of rows and columns, with a unique key identifying each row.
H) synonym: Two different names that refer to the same attribute or relation in a database schema.
I) well-structured relation: A relation that does not contain repeating groups, and each attribute represents a single value.

Answer: 
A) foreign key 
B) functional dependency 
C) homonym 
D) recursive foreign key 
E) referential integrity 
F) relation 
G) relational database model 
H) synonym 
I) well-structured relation

Each term is matched correctly with its corresponding definition.

Question 19

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)indexed file organization
I)pointer
J)sequential file organization

Accepted Answer

A data type is a coding scheme recognized by system software for representing organizational data.

Question 20

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)recursive foreign key
E)referential integrity
F)relation
G)relational database model
H)synonym
I)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 rows are stored either sequentially or nonsequentially,and a table is created that allows software to locate individual rows.

Match each of the following E-R structures with its relational representation. -Create a relation with a composite primary key using the primary keys of the related entities,plus any nonkey attributes of the relationship or associative entity.

Match each of the following terms with its corresponding definition. -A data model that represents data in the form of tables or relations.

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 E-R structures with its relational representation. -Create a relation with the primary key associated with the relationship or associative entity,plus any nonkey attributes of the relationship or associative entity and the primary keys of the related entities.

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 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. -A relation that contains a minimum amount of redundancy and allows users to insert,modify,and delete the rows in a table without errors or inconsistencies.

Match each of the following E-R structures with its relational representation. -Create a relation with a composite primary key that includes the primary key of the entity on which this entity depends and nonkey attributes.

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

Match each of the following E-R structures with its relational representation. -Place the primary key of the entity on the one side of the relationship as a foreign key in the relation for the entity on the many side.

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 address for each row is determined using an algorithm.

Match each of the following terms with its corresponding definition. -A field of data that can be used to locate a related field or row of data.

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

Match each of the following terms with its corresponding definition. -Two different names that are used to refer to the same data item.

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. -An attribute that appears as a nonkey 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 coding scheme recognized by system software for representing organizational data.

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.