Answer to Question #313639 in Accounting for Jen

Question

The quantity of Item X that is sold to customer Y on September 11th should be an attribute in which table?

A. Sale

B. Customer

C. Sales–inventory

D. Inventory

The list price of inventory item 3399776 should be an attribute in which table?

A. Sales

B. Inventory

C. Supplier

D. Sales–inventory

If a company sometimes only sold parts, sometimes only performed services, and sometimes did both, the minimum cardinalities associated with the inventory table would be

A. zero.

B. one.

C. many.

D. None of these are correct

For a company that rents out construction equipment to building contractors, the rent equipment event is linked to? Check all that apply.

A. at most one return event.

B. at most one receive cash event.

C. at least one receive cash event.

D. at least one return event.

Answer 1

Answers to each question

Question 1

The quantity of Item X that is sold to customer Y on September 11th should be an attribute in which table?

Answer - Sale

Explanation - A sales table gives a description of the information relating to to each sale and the customer who purchases the item. In this case item X is the sale which is sold to customer Y

Question 2

The list price of inventory item 3399776 should be an attribute in which table

Answer - Inventory table

Explanation - The inventory table records the relevant information of the inventory item together with the cost or price of the inventory. Therefore, the list price of the inventory should be attributed to the inventory table.

Question 3

If a company sometimes only sold parts, sometimes only performed services, and sometimes did both, the minimum cardinalities associated with the inventory table would be

Answer- None of these are correct

Explanation- None of the options are correct because the minimum cardinalities associated with the inventory table are three.

Question 4

For a company that rents out construction equipment to building contractors, the rent equipment event is linked to? Check all that apply.

Answer- A, C and D apply

Explanation - A company that rents out its construction equipment will have at most one return event, at least one receive cash event and at least one return event.

References

Yaman, I., & Dalkılıç, T. E. (2021). A hybrid approach to cardinality constraint portfolio selection problem based on nonlinear neural network and genetic algorithm. Expert Systems with Applications, 169, 114517.