Help me with MS Access

[justinoh]

Hey dudes!

I've got a college assignment to construct a DBMS for a petrol station. I hope all of you experts out there can help me by giving ideas to construct a relationship diagram. The Information System should cover at least one of these: petrol pumping, car wash or shop. It would be better if all 3 can be linked together but one will do. Hope you guys can give me some input on the required key fields, links and relationships.

Thanks a bunch!

 

[justinoh]

Guys? Some help here please?

 

[joinT]

no offense, but seeing as how this is *YOUR* college assignment, I don't think someone is gonna try to think of all the required fields & their relations to others. You need to do some work first, post your ideas & we'll help you.
Start off by thinking of all the fields you'll require to track gasoline purchasing & sales.

 

[EagleKeeper]

Approach the problem logically. As JointT stated, figure out all the information that you need for each are, common items can then be linked together. Half of the learning battle is to analyze the problem, otherwise you will just ask/require help for the next item. Help is never available on finals.