Hello everybody,
I'm Wolfgang, recently moved to the states and trying to create a database for inventory of gas stations. I hope you could help me out, even tho im new to this board!
I am also pretty new to databases, it has been a while since i did this at Vienna business university but at least i have some basic knowledge.
What i am trying to do is create a database for gas stations. Every day reports of each station fly in and have to be added to the database to keep track of the gas inventories.
There are about 25 Stations and a bunch of different fuels. I want to keep track of each day's actual inventory, booked inventory (to check overage or shortage) and the transactions of the inventory (sales and delivery)
So far i have a table for
Stations
Product(Gas)
GasInventory
GasInventoryTransactions
I have some problems with the constellation and relationships of those tables as i have the feeling that i might think to complicated.
Do i need a seperated table for transactions? or do i just put everything in one table?
Is there anything you could suggest for that kind of database? has anybody created something similar and has some tips for me?
Kind of getting frustrated with it a little bit, as it has been quite a while and i know that the proper modelling of the tables with their relations is pretty much the most important thing!
Thank you
Wolfgang