Data Model ~ Purchase Orders with Inventory...
This data model was designed to handle Purchase Orders with Inventory management. (Note, there only tables included in this database the balance is up to you!) To download the Data Model click here.
This data model was designed to handle Purchase Orders with Inventory management. (Note, there only tables included in this database the balance is up to you!) To download the Data Model click here.
Business Rules...
You may want to sort your Inventory by Category
Inventory will need to be stored
There many Purchase Orders
Each Purchase Order will have a Vendor
You will want to know who ordered (requisitioned) the Inventory
Purchases may require an Expenditure Code
Main Entities...
Purchase Orders
Inventory
Vendors will have Types
The difficult I do immediately, the impossible takes a little bit longer.
Data Models
| Tips (Main) |
| Home |
| Access Basics |
| Data Modeling 101 |
| Utter Access - Design Strategies |
| Naming Conventions |
| Modeling Human Relationships |