Database Information for Businesses
An order entry system for a business, for example, will consist of many tables:
- an orders table to track each order
- an orders detail table for tracking each item in an order
- a customer table so you can see who made the order and who to bill
- an inventory table showing the goods you have on hand
- a suppliers table, so you can see who you need to re-order your stock from
From Databases from Scratch at GeekGirls.com.