One of the more effective places to start is the sales transaction, since sales are what make your Business go
|
salestransaction |
||
|
stxid |
PK |
Not Null |
|
productid |
FK |
Not Null |
|
customerid |
FK |
Not Null |
|
saledate |
Not Null |
|
|
saleamount |
Not Null |
So here is a potential Sales Transaction Table
I am going to sell some Product
To some Customer
On Some Date
For Some amount of Money
And each sale should be Uniquely Identified
This may work for some small businesses but who is the 2nd person in the picture?