Question 1

Codd's rule of ____ states:
Application programs and ad hoc facilities are logically unaffected when changes are made to the table structures that preserve the original table values (changing order of columns or inserting columns).

Accepted Answer

Codd's rule of Logical Data Independence states that application programs and ad hoc facilities should be logically unaffected when changes are made to the table structures that preserve the original table values. This includes changes such as changing the order of columns or inserting new columns. Therefore, option B is the correct answer. The other choices are not relevant to the given statement.

Question 2

When you define a table's primary key,the DBMS automatically creates a(n)____ index on the primary key column(s)you declared.

Accepted Answer

When defining a table's primary key, the DBMS automatically creates a unique index on the primary key column(s) that you declared. Therefore, the best choice is C, unique.

Question 3

If the foreign key contains either matching values or nulls,the table that makes use of that foreign key is said to exhibit ____________________ integrity

Accepted Answer

The answer of If the foreign key contains either matching...

Question 4

A(n)____________________ key can be described as a superkey without unnecessary attributes.

Accepted Answer

The answer of A(n)____________________ key can be described as a...

Question 5

The ____ is actually a system-created database whose tables store the user/designer-created database characteristics and contents.

Accepted Answer

The answer of The ____ is actually a system-created database...

Question 6

The relational operators have the property of ____________________; that is,the use of relational algebra operators on existing relations (tables)produces new relations.

Accepted Answer

The answer of The relational operators have the property of...

Question 7

In the relational model,____________________ are important because they are used to ensure that each row in a table is uniquely identifiable.

Accepted Answer

The answer of In the relational model,____________________ are important because...

Question 8

In a database context,the word ____ indicates the use of the same attribute name to label different attributes.

Accepted Answer

Homonym refers to the use of the same name for different attributes in a database context. Redundancy refers to unnecessary duplication of data, duplicate refers to having multiple identical copies of the same attribute or record, and synonym refers to using different names to refer to the same attribute.

Question 9

The logical view of the relational database is facilitated by the creation of data relationships based on a logical construct known as a(n)____________________.

Accepted Answer

The answer of The logical view of the relational database...

Question 10

A ____ contains at least all of the attribute names and characteristics for each table in the system.

Accepted Answer

A data dictionary contains descriptions of all data elements in a system, including the tables, columns, data types, relationships, and constraints. It helps ensure consistency and accuracy in the system design and maintenance. A relational schema and logical schema are both types of data models used to organize data in a relational database. A join is a type of SQL operation used to combine data from two or more tables based on a common field. None of these choices fully describe a comprehensive list of attributes and characteristics for each table in the system, which is provided by a data dictionary.

Question 11

A(n)____ is an ordered arrangement of keys and pointers.

Accepted Answer

An index is an ordered arrangement of keys (usually values of specific attributes) and pointers, which allows data retrieval operations to be performed more efficiently. A table is a collection of related data organized in rows and columns, a superkey is a set of one or more attributes that can uniquely identify each row in a table, and a relationship is a connection between two or more tables based on common attributes.

Question 12

____ relational type is the "relational model ideal."

Accepted Answer

The 1:M (one-to-many) relationship is considered the ideal in the relational model because it allows for efficient organization and retrieval of data, where one entity can be associated with multiple entities in another table.

Question 13

In a database context,a(n)____ indicates the use of different names to describe the same attribute.

Accepted Answer

A synonym is a word or phrase that means exactly or nearly the same as another word or phrase in the same language, such as shut and close. In a database context, a synonym is used to describe different names that refer to the same attribute. This is useful when different users or systems refer to the same attribute by different names, and helps to ensure that queries and reports can be written using the correct name regardless of the source.

Question 14

Attribute A determines attribute B (that is,B is functionally ____________________ on A)if all of the rows in the table that agree in value for attribute A also agree in value for attribute B.

Accepted Answer

The answer of Attribute A determines attribute B (that is,B...

Question 15

Since it is used to link the tables that originally were related in a M:N relationship,the composite entity structure includes-as foreign keys-at least the ____ keys of the tables that are to be linked.

Accepted Answer

The composite entity structure includes foreign keys, and the foreign keys needed to link the tables are the primary keys of the linked tables.

Question 16

In a relational table,each column has a specific range of values known as the ____________________ domain.

Accepted Answer

The answer of In a relational table,each column has a...

Question 17

PRODUCT yields all possible pairs of rows from two tables-also known as the ____________________ product.

Accepted Answer

The answer of PRODUCT yields all possible pairs of rows...

Question 18

To avoid nulls,some designers use special codes,known as ____________________,to indicate the absence of some value.

Accepted Answer

The answer of To avoid nulls,some designers use special codes,known...

Question 19

The following example exhibits ____________________ integrity:
The CUSTOMER table's primary key is CUS_CODE.The CUSTOMER primary key column has no null entries,and all entries are unique.Similarly,the AGENT table's primary key is AGENT_CODE,and this primary key column also is free of null entries.

Accepted Answer

The answer of The following example exhibits ____________________ integrity:
The CUSTOMER...

Question 20

The ____ relationship should be rare in any relational database design.

Accepted Answer

A 1:1 relationship should be rare in any relational database design because it can typically be combined into a single table. In most cases, a 1:M or M:1 relationship would be sufficient and more efficient. A M:N relationship is also common, but requires a junction table to resolve the many-to-many relationship.

Quiz 3: The Relational Database Model

Codd's rule of ____ states: Application programs and ad hoc facilities are logically unaffected when changes are made to the table structures that preserve the original table values (changing order of columns or inserting columns) .

When you define a table's primary key,the DBMS automatically creates a(n) ____ index on the primary key column(s) you declared.