normalisation problem

hi guys

i really need you tech boffins help for normalising some tables for my a database for my taxi company that i have brought. i'm quite a technical inthusiast and hope to be able to create a oracle dataase in oracle .i have read on many websites that when designing a database it is important to have normalised tables. so can any one help me normalise my fields i have it in unormalised form. (below). i have looked at tutorials on websites and they don't seem relevant to my database and i would like to learn how to do this for my database. so could some one show me how to do first normal form and then second normal form and then third normal for please.i have already done UNF and i think i have done 1NF below. is this right so far

here is unnormalised form.


we have a number of offices located in the main cities of Scotland

office number
address
street city
postcode
phoneno.

Each office has four kinds of staff: a Manager, several taxi owners, administrators and a number of drivers. Staff can be located at more than one office


manager
first name
last name
address
salary
d.o.b


An owner provides one or more taxis

taxi owner
first name
last name
address
salary
d.o.b

administrator
first name
last name
address
salary
d.o.b

driver
first name
last name
address
salary
d.o.b

taxi
registration no.
model
make
colour
milage
M.O.T due date
capacity


taxis are not available for hire by the public hailing a taxi in the street but must be requested by first phoning the us to attend a given address. There are two kinds of clients-private and business


The business provided by private clients is on an ad hoc basis. The details of private clients are collected on the first booking of a taxi

Private customer
First name
last name
telephone no.
client no.


business provided by business clients is more formal and involves agreeing a contract of work with the business.A contract stipulates the maximum number of jobs that Critter-Cabs will undertake for a fixed fee


business customer
max jobs
fixed fee
start date
end date
Description //whether it is a night job or a day job
name
address
telephone no.
fax
contract no.

When a job comes in the appropriate details are recorded for either a private client or a business client.

If the job is requested by a business client then the contract number is also recorded

jobs
contract no.
pickup date
pick up time
pick up address
drop off address
milage used
charge made
job completed / yes or no


1NF
* = primary key ** = foriegn key// i was'nt sure what to put down for foriegn keys ,so i don't think they are all there
-----------------
*office id
street
city
postcode
phoneno

----------------

*Staff_id
Staff Type
first name
last name
street
city
postcode
salary
d.o.b
------------------

*taxi_id
registration no.
model
make
colour
milage
M.O.T due date
capacity

--------------------
//private clients

*client no.
First name
last name
telephone no.

-------------------
//business clients

*contract no.
max jobs
fixed fee
start date
end date
Description //whether it is a night job or a day job
name
street
city
postcode
telephone
fax
------------------------------

*job_id
**contract no.
pickup date
pick up time
pick up address
drop off address
milage used
charge made
job completed / yes or no

Two things,

Who owns the taxi's being used? You didn't make any reference for that.


Second, better re-think you desire to use an Oracle DB. By the looks of you data, that is overkill for your needs (to expensive)

S-