By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,640 Members | 2,118 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,640 IT Pros & Developers. It's quick & easy.

need help with database design

thatos
100+
P: 105
I need to know which fields must I use when designing a database for a filling company or where can I find any information which can help me with this as I have already googled and I doing get results which I am looking for .The reason for asking this question is that we are given a project to design a database for this topic. Your reply will be of much importance.
Feb 11 '08 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Sorry thatos, it's against the posting guidelines to provide full answers to homework questions. However, if you want to attempt this yourself we will be happy to comment on any problems with your structure.
Feb 11 '08 #2

mshmyob
Expert 100+
P: 903
As msquared says you have to try something first and then we can help. The best way to learn is to try it yourself first even if you make mistakes.

Try reading this article by msquared to get you started.
http://www.thescripts.com/forum/thread585228.html

Before starting your design you MUST first determine your business rules. Business rules will determine your tables, relationships and in limited cases some fields. Business rules are things you want your database to track and the rules that apply to the database.

For instance in your case what do you need to track for a filling station? Ask yourself that and it will get you started. ie: Do you need to track customers, do you need to track type of fuel sold, do you need to track amount of fuel sol for each type, etc. etc. That is if a filling company is a gas station (lol).
Feb 11 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.