Solved

Case-Based Critical Thinking Questions Case 2-3

question 32

Multiple Choice

Case-Based Critical Thinking Questions Case 2-3
Syed and Marino Li own a small furniture consignment shop in Atlanta, GA. Syed is designing a database that will allow them to keep track of item information and seller information. Each item is assigned to one seller; however, each seller may be assigned multiple items in the database. The database will contain the following information: item identification number, item description, seller code, condition of item, retail price of item, item quantity, date item received, condition of item, date the item is sold, the final sale price of the item, seller name, seller address, and seller contact information. Using appropriate database design guidelines, answer the following questions.
Based on the information to be included in the database, which of the following possible field names would be the best common field to include in two or more tables?

Definitions:

Operating Cycle

The operating cycle is the duration of time it takes for a company to purchase inventory, sell it to customers, and collect the cash from the sales, reflecting how quickly a company can convert its products into cash.

Readily Marketable

Assets that are considered readily marketable are those that can easily be converted into cash because there is a high demand and an active market for them.

Short-Term Investments

Financial assets that are expected to be converted into cash or sold within a year.

Seasonal Fluctuations

Variations in business activity, sales, or performance that occur regularly at certain times of the year due to the season.