Question 1

Identify several advantages and disadvantages of using an index.

Accepted Answer

The answer of Identify several advantages and disadvantages of using...

Question 2

You have recently been hired by an appliance repair company.Your first task is to normalize the following relation.

Accepted Answer

The answer of You have recently been hired by an...

Question 3

Define each of the following terms: relation,functional dependency,foreign key,and normalization.

Accepted Answer

The answer of Define each of the following terms: relation,functional...

Question 4

Match each of the following E-R structures with its relational representation.
-Create a relation with primary key 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 regular entity is represented as a single relation with its primary key and nonkey attributes.

Question 5

What is second normal form? What conditions determine if a relation is in second normal form?

Accepted Answer

The answer of What is second normal form? What conditions...

Question 6

What are the four key physical database design decisions you will make?

Accepted Answer

The answer of What are the four key physical database...

Question 7

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.)
-Referencing storage space,this method has no wasted space.
A)indexed file organization
B)hashed file organization
C)sequential file organization

Accepted Answer

The answer of Match each of the following file organizations...

Question 8

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.)
-Referencing random retrieval on primary key,this method is moderately fast.
A)indexed file organization
B)hashed file organization
C)sequential file organization

Accepted Answer

An indexed file organization allows for random retrieval on a primary key, and is moderately fast.

Question 9

Briefly identify the three file organizations.

Accepted Answer

The answer of Briefly identify the three file organizations....

Question 10

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.)
-Referencing sequential retrieval on the primary key,this method is impractical.
A)indexed file organization
B)hashed file organization
C)sequential file organization

Accepted Answer

In a hashed file organization, data is accessed using a hash function, making sequential retrieval on the primary key impractical because the data is not stored in a sequential order.

Question 11

Discuss the rules for normalization.

Accepted Answer

The answer of Discuss the rules for normalization....

Question 12

Match each of the following E-R structures with its relational representation.
-Place the primary key of either entity in the relation for the other entity or do this for both 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 13

Identify the five properties of a relation.

Accepted Answer

The answer of Identify the five properties of a relation....

Question 14

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.)
-Referencing multiple key retrieval,this method is not possible.
A)indexed file organization
B)hashed file organization
C)sequential file organization

Accepted Answer

In hashed file organization, data is accessed using a hash function, which does not support multiple key retrieval as it maps keys to specific locations.

Question 15

How is a binary one-to-one relationship represented?

Accepted Answer

The answer of How is a binary one-to-one relationship represented?...

Question 16

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.)
-Referencing updating rows,this method is easy but requires maintenance of indexes.
A)indexed file organization
B)hashed file organization
C)sequential file organization

Accepted Answer

Indexed file organization is the best choice for referencing and updating rows, as it allows for quick access to specific records through the use of indexes. However, it does require maintenance of these indexes to ensure efficiency. Hashed file organization is also efficient for accessing specific records, but it may not be as easy to update rows. Sequential file organization is not ideal for referencing specific rows or updating them.

Question 17

Outline the four key steps in logical database modeling and design.

Accepted Answer

The answer of Outline the four key steps in logical...

Quiz 9: Designing Databases

Identify several advantages and disadvantages of using an index.

You have recently been hired by an appliance repair company.Your first task is to normalize the following relation.

Define each of the following terms: relation,functional dependency,foreign key,and normalization.

Match each of the following E-R structures with its relational representation. -Create a relation with primary key and nonkey attributes.

What is second normal form? What conditions determine if a relation is in second normal form?

What are the four key physical database design decisions you will make?

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.) -Referencing storage space,this method has no wasted space.

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.) -Referencing random retrieval on primary key,this method is moderately fast.

Briefly identify the three file organizations.

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.) -Referencing sequential retrieval on the primary key,this method is impractical.

Discuss the rules for normalization.

Match each of the following E-R structures with its relational representation. -Place the primary key of either entity in the relation for the other entity or do this for both entities.

Identify the five properties of a relation.

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.) -Referencing multiple key retrieval,this method is not possible.

How is a binary one-to-one relationship represented?

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.) -Referencing updating rows,this method is easy but requires maintenance of indexes.

Outline the four key steps in logical database modeling and design.