Help Normalize

JahJr

Andy
Local time
, 20:57
Joined
Dec 3, 2008
Messages
93
I'm continuing a post that I had under Queries but it turns out it is a table issue.
Link to other post:http://www.access-programmers.co.uk/forums/showthread.php?p=1228190#post1228190
I have created 4 tables now
tblPOS
tblOpenClose
tblBartenders
tblBartenderTips

tblPOS has the following fields:
TransactionID, BusinessDate, Food Sales, Liquor Sales, Beer Sales, Daiquiri Sales, Wine Sales, T-Shirt Sales, Tax, Comp, Disc, Visa, American Express, Discover, Master Card, Cash Paid Out, Cash Paid In, Total Cash, Donations, Gift Certificates, Credit Card Tips

tblOpenClose has the following fields:
TransactionID, BusinessDate, Open Drawer, Close Drawer, Cash Tips, Open Bartender, Close Bartender, Number of Bartenders

tblBartenderTips has the following fields:
TransactionID, BusinessDate, EmployeeID, Amount

tblBartenders has the following fields:
EmployeeID, Name

I don't know if this is right or wrong or if it should be split up some more. I'm also unsure about the primary keys and relationships> Any pointers or direction will be greatly appreciated.
 
Wow, this is all becoming a little clearer now. A few questions...
1. In tblOpenClose I can't picture how your recommendation is going to work. I might not have been very clear in my original post. In my current data. I have the following fields. Open, Close, Open Amount, and Close Amount. Open and Close are just the name of the employee who opened and who closed. Open Amount and Close Amount are the totals for the cash register at the beginning of the night and at the end of the night. Not sure how drawer type will work into this.
2. What would be the keys in each table and would ...ID be the AutoNumber?
 

Users who are viewing this thread

Back
Top Bottom