Create an Account

Already have account?

Forgot Your Password ?

Home / Questions / 1. Of the following, select the attribute that would be the bestprimary key in an inventor...

1. Of the following, select the attribute that would be the bestprimary key in an inventory table. a. Item NAME b. Item NUMBER c. Item COST d. Item LOCATION e. ITEM SUPPLIER 2. The advantages to

1. Of the following, select the attribute that would be the bestprimary key in an inventory table.

a. Item NAME

b. Item NUMBER

c. Item COST

d. Item LOCATION

e. ITEM SUPPLIER

2. The advantages to using a partitioned database approachinclude all of the following EXCEPT that

a. The possibility for the deadlock phenomenon is reduced.

b. user control is increased.

c. transaction processing time is decreased.

d. the potential for the wide-scale disaster is reduced.

e. these are all advantages of the partitioned databases.

3. A partial dependency

a. is the result of simultaneous user requests for the same datain a partitioned database environment.

b. is a name given to one of the three anomalies that resultfrom unnormalized database tables.

c. can exist only in a table with a composite primary key.

d. may exists kin tables that are normalized at the 2NFlevel.

4. Repeating group data

a. occur as a form of data redundancy common to replicateddatabases in a distributed database environment.

b. refer to one of the three anomalies that result fromunnormalized database tables.

c. can exists only in a table with a composite primary key.

d. cannot exist in tables that are normalized at the 2NFlevel.

e. are none of the above.

5. What term describes the following data items: part number,description, quantity on hand, and reorder point?

a. Attributes

b.Relations

c. Entities

d. Occurrences

6. One of the first steps in the creation of a relationaldatabase is to

a. perform view integration

b. normalize the tables

c. create a data model for the entities in the system

d. identity attributes and add foreign keys

e. construct the physical user view using SQL.

7. Entities in a data model

a. may contain zero or many occurrences.

B.are represented as verbs in an ER diagram.

c. may represent both physical assets and intangiblephenomena

d. are often defined by common attributes that also define otherentities

e. are unique to a specific user view.

8. Which of the following is least likely to be an attribute ofan employee table in a normalized database?

a. Employee name

b. Employee address

c. Employee number

d. Employee supervisor

May 25 2021 View more View Less

Answer (Solved)

question Subscribe To Get Solution

Related Questions