Access 2003

Real-world examples of database applications

How do these databases work together? Well, everything in retail begins with the product or item. Each item has a barcode that uniquely identifies it. These items are defined in an item database and are associated with a specific department, defined in a department database.

When a buyer decides to purchase some products for sale in a store, he or she creates an order in a purchase order database, pulling the individual items to buy from the item database. The order might then be transferred to communications databases that electronically transmit the order to the vendor, and also to an accounts payable database to pay for the merchandise.

Trucks deliver merchandise to the store (remember that the vendor has its own database indicating what is shipped), where the products received are input into a receiving database. The received quantities are then matched against the original order database to make sure all ordered products were received.

An inventory database might tell the sales clerk which items to move to the selling floor because the shelves are bare, and what other items might be stored in the stockroom. For items moved to the selling floor, a shelf planning database might tell the clerk exactly where to place the product on the shelf.

When you shop and take items to the checkout counter, the cash register will look up the price of each item in the price lookup database. Want to pay by check or credit card? Databases are used to ensure sufficient funds are available in the account.

Every item sold in the store needs to be removed from inventory so it can be reordered. This adjustment might be made in the inventory table to alert the buyer that a certain amount of items need to be ordered to refresh the store's inventory.

Many things happen, and many databases are used to make sure the products you want make their way from the manufacturer to the stores and then into your home.