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?
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
Two dimensions that determine the level of environmental uncertainty are the number of factors in the external environment and the of these factors.(a) location(b) rate o...Jul 18 2020
Explain the two main methods used to measure GDP.113) How is interest measured when used in deriving GDP?114) How do GDP and NDP differ? What does it mean if net investme...Dec 07 2019
BB320 Business Strategy Literature Review Word Count: 1,500 words Weight: 20% Due: Week 6Summary of MarksTitle Page, Abstract and Introduction10%Main Body (3 section...Dec 28 2019
Name one piece of evidence that might indicate that an area had been eroded by a glacier. Then, name a piece of evidence that might indicate that an area had been eroded by wind.Nov 27 2019
A model ship propeller is to be tested in water at the same temperature that would be encountered by a full-scale propeller. Over the speed range considered, it is assume...Mar 28 2020
In the engine system shown, l = 10 in and b = 3 in; the crank AB rotates with a constant angular velocity of 750 RPM clockwise. Determine the velocity of thepiston P and ...Jul 03 2020
To make sure you have mastered the use of commas, try your skill on these challenging sentences that cover all levels. Insert needed commas. In the space provided, indica...Jul 10 2021
Projecting NOPAT and NOA Using Parsimonious Forecasting Method Assume the following are 3M's sales, net operating profit after tax (NOPAT), and net operating assets (N...May 02 2020
How can the cause of a locked burner motor be determined?Jun 11 2021
One gene can have multiple effects on an organism. (A) True (B) FalseMar 14 2018