This is also your Big Project for the class, so I will be looking at this to see what you have learned
1) Create your Initial Design in the form of an ERD. You are going to turn in an ERD for this exercise, it should include:
a) All of your Tables
b) Identify all Keys
c) Identify Field types of your Data
d) Identify all relationships
e) Identify Not Null fields
2) There really is no required part 2 for this lab since part 1 should take you several hours to complete (if you did it in less than an hour, trust me, it is incomplete) . However, a good idea (worth extra credit) is to load some sample data into the model to see if it works the way you wanted it to.
Your Database should be able to handle:
I) Customers
II) Vendors
III) Employees
IV) Purchase Transactions
V) Sales Transactions
VI) Inventory or JIT System