I work at a warehouse distributor and have chosen to use this as the basis for my project. To start with, I've limited myself to 3 tables--Orders, Products, and Customers. OrderNumber, ItemNumber, and CustomerID are the primary keys for each table respectively. Each of these keys identify each entry uniquely, and can easily be swung around between the tables to borrow information.
Here is my ERD:
https://drive.google.com/open?id=0B5hBlRd1P7vEaTJDc2pmVW8yRTg
Here is my ERD:
https://drive.google.com/open?id=0B5hBlRd1P7vEaTJDc2pmVW8yRTg