What Is a Database? Name a Sample Use for a Database

question 37

Essay

What is a database? Name a sample use for a database and two tables that database might contain. Name one similarity and one difference between Access and Excel. What is a relational database and how is it used?

---

Definitions:

Inventory Control

A system used to oversee and manage the ordering, storage, and use of inventory in a business.

Initial Record

Initial record refers to the first entry of a transaction into the accounting system. This record is crucial for maintaining the accuracy and integrity of financial data.

Perpetual Inventory

An inventory management system that updates item records on a continuous basis as transactions occur, providing real-time inventory levels.

Weighted Average

A calculation that takes into account the varying degrees of importance of the numbers in a dataset, often used in accounting to determine inventory costs.