Question 1

Which of the following best describes a unique sequential number or random number assigned by the database management system (DBMS) whenever a new record is added to a table?
A) Number
B) Currency
C) OLE object
D) Hyperlink
E) Autonumber

Accepted Answer

Autonumber is a unique sequential number or random number assigned by the database management system (DBMS) whenever a new record is added to a table. This helps in identifying and differentiating each record.

Question 2

The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields best describes:
A) normalization.
B) simplification.
C) denormalization.
D) data structure.
E) nullifying.

Accepted Answer

The process described belongs to denormalization, which involves taking normalized relations and adding redundant data or breaking them down further to improve performance.

Question 3

A single name that is used for two or more different attributes best defines:
A) homonym.
B) synonym.
C) transitive dependency.
D) alias.
E) antonym.

Accepted Answer

A homonym is a word that has the same spelling or pronunciation as another word but has a different meaning. Therefore, a single name that is used for two or more different attributes is best defined as a homonym.

Question 4

Relationships between instances of a single entity type are referred to as:
A) binary relationships.
B) transitive relationships.
C) recursive relationships.
D) dependent relationships.
E) singular relationships.

Accepted Answer

Recursive relationships refer to relationships between instances of a single entity type. This means that the entity type is related to itself in some way, such as an employee reporting to another employee within the same company. Binary relationships refer to relationships between two different entity types, transitive relationships refer to relationships where A is related to B and B is related to C, therefore A is related to C, dependent relationships refer to relationships where one entity is dependent on another entity, and singular relationships is not a commonly used term in database relationships.

Question 5

All of the following are objectives when choosing data types EXCEPT:
A) minimizing storage space.
B) representing all possible values.
C) decrease data quality.
D) improve data integrity.
E) support all data manipulations desired on the field.

Accepted Answer

Decreasing data quality is not an objective when choosing data types. The other choices are all valid objectives when selecting data types.

Question 6

The smallest unit of named application data recognized by system software is called a(n):
A) field.
B) table.
C) row.
D) relation.
E) entity.

Accepted Answer

A field is the smallest unit of named application data recognized by system software. It refers to a single piece of information, such as a person's name or address. Tables, rows, relations, and entities are all related to databases and are not necessarily the smallest unit of named application data.

Question 7

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)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

A field that can be derived from other database fields is called a:
A) quoted field.
B) primary field.
C) hidden field.
D) calculated field.
E) none of the above

Accepted Answer

A calculated field is a field that is created by performing calculations on other fields in the database. For example, a database could have fields for quantity and price, and a calculated field for total cost (quantity multiplied by price).

Question 9

A many-to-many relationship that associates certain items with their component items is called a:
A) binary structure.
B) bill-of-materials structure.
C) binary relationship.
D) ternary relationship.
E) singular relationship.

Accepted Answer

A many-to-many relationship that associates certain items with their component items is commonly referred to as a bill-of-materials structure, often used in manufacturing and production industries to track the components needed to create a final product. A binary structure refers to a relationship between two entities, a binary relationship is a relationship between two entities or sets of data, a ternary relationship refers to a relationship between three entities, and a singular relationship does not indicate a specific type of relationship.

Question 10

Two different names that are used to refer to the same data item best defines:
A) homonym.
B) synonym.
C) transitive dependency.
D) alias.
E) antonym.

Accepted Answer

The answer of Two different names that are used to...

Question 11

A default value is:
A) the value that all fields will take.
B) the value that a field will take unless otherwise specified.
C) a value that is not allowed in a field.
D) a way to represent null values.
E) the value that a field always returns to.

Accepted Answer

A default value is the value that a field will take unless otherwise specified. It is a predetermined value that is automatically assigned to a field if no other value is specified.

Question 12

"Create a relation with primary key and nonkey attributes" is the relational representation for which E-R structure?
A) Weak entity
B) Regular entity
C) Gerund
D) IS-A relationship
E) Transitive dependency

Accepted Answer

The E-R structure of a regular entity is represented as a relation in a relational database. The primary key uniquely identifies each record in the relation, and nonkey attributes are all other attributes that provide additional information about the record but are not used to identify it. Therefore, creating a relation with primary key and nonkey attributes is the correct way to represent a regular entity in a relational database. Choice A (Weak entity) would also have a primary key, but it would be a composite key consisting of the primary key of the related strong entity along with a discriminator attribute. Choices C, D, and E are not related to creating relations in a relational database.

Question 13

For a unary M:N relationship:
A) the entity type is modeled as one relation; a separate relation is created to represent the M:N relationship; the new relation has a composite key that consists of two attributes that both take their values from the same primary key.
B) the entity type and the M:N relationship are modeled as one relation; a composite key consisting of two attributes that both take their values from the same primary key is used as the primary key for the relation.
C) separate relations for the class and for each subclass are created; primary and foreign keys are established for each class.
D) the primary key of the entity on the one side of the relationship serves as a foreign key in the relation on the many side of the relationship.
E) none of the above is true.

Accepted Answer

The answer of For a unary M:N relationship:
A) the entity...

Question 14

A field of data that can be used to located a related field or row of data is called a(n):
A) pointer.
B) key.
C) entity.
D) attribute.
E) index.

Accepted Answer

The answer of A field of data that can be...

Question 15

Merging relations is also referred to as:
A) view integration.
B) view consolidation.
C) encompassing.
D) normalizing.
E) transforming.

Accepted Answer

Merging relations is the process of combining two or more tables/views into a single table/view. This process is also referred to as view integration as it involves integrating multiple views into a single view.

Question 16

A data integrity control that restricts the permissible values for data is called a(n):
A) input mask.
B) default value.
C) range control.
D) primary key.
E) candidate key.

Accepted Answer

A range control restricts the permissible values for data by setting a minimum and/or maximum value. This helps ensure data integrity by preventing incorrect or invalid data from being entered. Input masks, default values, primary keys, and candidate keys are all methods for ensuring data integrity, but they do not necessarily restrict the permissible values for data.

Question 17

A foreign key in a relation that references the primary key values of that same relation is referred to as a:
A) secondary key.
B) recursive foreign key.
C) composite key.
D) complex key.
E) concatenated key.

Accepted Answer

A foreign key that references the primary key values of the same relation is referred to as a recursive foreign key. This is often used for hierarchical data structures, such as an employee reporting to a manager who is also an employee in the same table.

Question 18

If a relationship exists among three or more entities, then:
A) recursive relationships must be established through the use of recursive foreign keys.
B) a separate relation with a primary key that is the composite of the primary keys of each of the participating entities is created.
C) separate relations are established for each class and for each of the subclasses.
D) use the primary key of relation A as a foreign key in relations B and C.
E) none of the above is done.

Accepted Answer

When a relationship exists among three or more entities, a separate relation with a primary key that is the composite of the primary keys of each of the participating entities is created. This is known as a junction table or intersection table. This table serves as a bridge or connector between the other tables and allows for an efficient way to represent the relationship among multiple entities. The other options listed are not typically used in this scenario.

Question 19

All of the following are types of file organizations EXCEPT:
A) indexed.
B) sequential.
C) hashed.
D) logical.

Accepted Answer

The options (A), (B), and (C) are all valid types of file organization. However, (D) is not a type of file organization but rather refers to a way of organizing data within a database.

Question 20

Using the term "account" to refer to a checking account and also to a savings account is an example of a(n):
A) homonym.
B) synonym.
C) transitive dependency.
D) alias.
E) antonym.

Accepted Answer

Homonyms are words that have the same spelling and pronunciation but different meanings. In this case, "account" is used to refer to a checking account and a savings account, which have different purposes and features.

Quiz 9: Designing Databases

Which of the following best describes a unique sequential number or random number assigned by the database management system (DBMS) whenever a new record is added to a table?

The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields best describes:

A single name that is used for two or more different attributes best defines:

Relationships between instances of a single entity type are referred to as:

All of the following are objectives when choosing data types EXCEPT:

The smallest unit of named application data recognized by system software is called a(n) :

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 field that can be derived from other database fields is called a:

A many-to-many relationship that associates certain items with their component items is called a:

Two different names that are used to refer to the same data item best defines:

A default value is:

"Create a relation with primary key and nonkey attributes" is the relational representation for which E-R structure?

For a unary M:N relationship:

A field of data that can be used to located a related field or row of data is called a(n) :

Merging relations is also referred to as:

A data integrity control that restricts the permissible values for data is called a(n) :

A foreign key in a relation that references the primary key values of that same relation is referred to as a:

If a relationship exists among three or more entities, then:

All of the following are types of file organizations EXCEPT:

Using the term "account" to refer to a checking account and also to a savings account is an example of a(n) :