Syed and Marino Li Own a Small Furniture Consignment Shop

question 58

Multiple Choice

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?

• A) ItemID
• B) SellerLName
• C) SellerCode
• D) ItemPrice

---

Definitions:

Nominal Interest Rate

The rate of interest before adjustment for inflation, as opposed to the real interest rate, which is adjusted.

Expected Rate

The anticipated return or yield on an investment, saving account, or financial product, often used in planning and financial projections.

Inflation

The hike in the broad cost of goods and services, resulting in a reduction of purchasing leverage.

Labor Force

The sum of all individuals who are either working or actively searching for work within a specific country or area.