Question: An Inventory Type entity has the following attributes: part name, supplier number, part number, purchase date, quantity on hand, and cost. Which attribute is the
-
An "Inventory Type" entity has the following attributes: part name, supplier number, part number, purchase date, quantity on hand, and cost. Which attribute is the best primary key for the Inventory Type entity?
Cost
Quantity on hand
Supplier ID
Part number
1 points
QUESTION 2
-
If you have a many to many association between inventory and sale, where in the database tables should you record the attribute quantity sold?
After the Inventory Stock Number which is posted into the Sale table as a foreign key
Anywhere in the Sale table After the Invoice Number which is posted into the Inventory table as a foreign key
In a table that represents the association between Inventory and Sale (i.e. the Inventory-Sale table)
Anywhere in the Inventory table
1 points
QUESTION 3
-
Identifying external agents is associated with which essential characteristic of business events?
What happened?
What resources were involved and how much?
When did it occur?
Who was involved and what roles did they play?
1 points
QUESTION 4
-
Determine the correct order of the seven steps needed to create a core pattern business level REA model.
- 1. 2. 3. 4. 5. 6. 7.Validate the model with one or more knowledgeable enterprise representatives
- 1. 2. 3. 4. 5. 6. 7.Attach internal agents to economic events
- 1. 2. 3. 4. 5. 6. 7.Attach external agents to economic events
- 1. 2. 3. 4. 5. 6. 7.Identify economic exchange events
- 1. 2. 3. 4. 5. 6. 7.Assign attributes to the classes and associations
- 1. 2. 3. 4. 5. 6. 7.Assign multiplicities to the associations
- 1. 2. 3. 4. 5. 6. 7.Attach resources to economic events
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
