ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

1 Q & A posts tagged with tables

Sun
Nov 13
2011

How many tables needed? urgent plz?

A Manager of CNG station is interested to design a database to accommodate all CNG relevant information. He wants to keep the record of all vehicles, regular customers and all transaction relevant to customer and suppliers. Moreover manager is interested to generate different report relevant to see information about daily weekly or monthly sale and profit record. On some occasion manager of CNG station offer different sale discounts, so he is also interested to keep the record of all discounts. Similarly, manager also using monthly billing system for some type of regular customers.
Q1. How many tables needed.
Q2. design tables.(optional for you viewer :P )


Answer

I would say at least 5 tables
Customers
Vehicles (one customer can have more than one vehicle)
Supplies
Services (To have actual service provided with Customer id, supply id, vehicle id, billing id, etc)
Discounts

And you can add
Billings (to have bills, with Costumer Id, amount, service id, discount id, etc)
Employees



let me know

Sunday 11/13/2011 7:12:14 AM

Tags

History