Re: New Small Business Taxi Cab Database

On Jun 27, 1:34 pm, Knowledge <knowled...@xxxxxxxxxxx> wrote:
Good day mates,

I'm trying to build a database to keep track of information that will
be stored when my client kicks off his brand new Taxi Cab business.
Initially it will be a one person operation.

The fellow is starting on a shoe string. He has no clients at the
moment.

He will be carrying people within a 50 mile radius at most. 99% of the
time he will be moving passengers within a ten mile radius.

These are the fields I have decided to use for the database so far:


Entity names??
ID

First name of caller

Middle Initial of Caller

Last Name of Caller

ID
Time of Call
Date of Call
Telephone number of Caller
First Name of Caller
Last Name of Caller
Why the redundant data: caller name?

Address
City
State

Address information will be redundant (repeated) is caller has mmore
than one phone number!
Learn to normalize you database

Destination
Charged
mileage to pickup point
mileage to destination
Mapquest URL to their home location
Comments
Mapquest URL to Destination
---------------------------------------------------------------------------­---------------------------
I have three different programs I can use for the database.

Which one do you think will do the best job for a one person
operation? The person who will be doing the data entry, driving,
bookkkeeping, mopping, cleaning is very proficient with most aspects
of computers.

I could use:

Microsoft Access 2007

ACT! by Sage 2006

Goldmine 6.0

Which program do you reccommend and why?

Thanks for taking the time to help me out with this?

www.telebay.com/7777


It looks like you haven't decided what entities you are dealing with.
Instead as is typical with beginners, you are just throwing fields at
the problem. The choice of program is less important at this point.

Do a google search and read up on normalization
search for
relational database normalization

HTH.
Ed

.

Relevant Pages

  • Re: Statement handle side effects of swap_inner_handle?
    ... > the existing database handle. ... > the error warrants it, return false to the caller, which then ... The inner handle carries all the DBI info, ... So swap_inner_handle is a simple and total brain transplant. ...
    (perl.dbi.users)
  • Need some questions answered in building a Taxicab Database
    ... I'm trying to build a database to keep track of information that will ... be stored when my client kicks off his brand new Taxi Cab business. ... Middle Initial of Caller ... Mapquest URL to Destination ...
    (comp.databases.ms-access)
  • New Small Business Taxi Cab Database
    ... I'm trying to build a database to keep track of information that will ... be stored when my client kicks off his brand new Taxi Cab business. ... Middle Initial of Caller ... Mapquest URL to Destination ...
    (comp.databases)
  • Start SQLServerAgent job Synchronously
    ... Is there a SQL command that allows you to start a SQLServerAgent job such ... call and the caller resumes processing as soon as the call is made. ... I have a set of SQLServerAgent jobs, each of which runs a BACKUP DATABASE ...
    (microsoft.public.sqlserver.programming)
  • Re: Need some questions answered in building a Taxicab Database
    ... You are getting muddled between a database and tables. ... Each table should have similar sorts of information such as client ... mileage to destination ... Middle Initial of Caller ...
    (comp.databases.ms-access)
Loading