Critiquing database tables. Bumble Beasley attempted to design a database to capture data about inventory purchases. He thought it would be easier to create one table with all the data rather than separate tables for different data items. The table he created contained the following fields:
Vendor phone | Inventory description |
Purchasing agent ID | Cost per item |
Vendor ID | Vendor code |
Purchasing agent home address | Invoice total (number of items × cost per item) |
Vendor state | Payment terms (e.g., 2/10, n/30) |
Vendor address | Inventory ID |
Vendor city | Purchasing agent first name |
Purchasing agent last name | Transaction number |
Transaction date | Quantity purchased |
Vendor ZIP |
|
a. Is Bumble’s database table in normal form? Discuss.
b. How many normalized database tables would be required for the data?
c. Group the data into the required number of normalized database tables. Specify a primary key for each table.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.