Normalisation Help

[ob1kenobi]

I'm struggling with the normalisation process for my database in Access here is my UNF. I'm stuck on the 1NF.

Internal Reference Number
Customer Name
Customer Address 1
Customer Address 2
Customer Address 3
Customer Address 4
Customer Address 5
Customer Telephone Number
Internal Reference Number
Client Reference Number
Client
Invoice Date
Invoice Total
Invoice Number
Payment Received
Item ID Number
Title Register
Title Register and Plans Ordered
Title Register and Plans Received
Title Register And Plans Price
EPC
EPC Booked
EPC Price
Commercial EPC
Commercial EPC Booked
Commercial EPC Price ?
Land Authority
Land Authority Search Ordered
Land Authority Search Received
Land Authority Serch Price
Water Search
Water Search Ordered
Water Search Received
Water Search Price
PIQ
PIQ Sent
PIQ completed and received
PIQ Price
Floor Plan
Floor Plan Drawn
Is printing required
Floor Plan Price
Commercial Floor Plan
Commercial Floor Plan Drawn
Commercial/Is printing required
Commercial Floor Plan Price ?
HIP
HIP Completed and Sent
HIP Price

[Jim Doherty]

I'm struggling with the normalisation process for my database in Access here is my UNF. I'm stuck on the 1NF.

Internal Reference Number
Customer Name
Customer Address 1
Customer Address 2
Customer Address 3
Customer Address 4
Customer Address 5
Customer Telephone Number
Internal Reference Number
Client Reference Number
Client
Invoice Date
Invoice Total
Invoice Number
Payment Received
Item ID Number
Title Register
Title Register and Plans Ordered
Title Register and Plans Received
Title Register And Plans Price
EPC
EPC Booked
EPC Price
Commercial EPC
Commercial EPC Booked
Commercial EPC Price ?
Land Authority
Land Authority Search Ordered
Land Authority Search Received
Land Authority Serch Price
Water Search
Water Search Ordered
Water Search Received
Water Search Price
PIQ
PIQ Sent
PIQ completed and received
PIQ Price
Floor Plan
Floor Plan Drawn
Is printing required
Floor Plan Price
Commercial Floor Plan
Commercial Floor Plan Drawn
Commercial/Is printing required
Commercial Floor Plan Price ?
HIP
HIP Completed and Sent
HIP Price

Welcome to Bytes

Rather than just rely on someone doing your work for you, what exactly is it that you are struggling with please? what it is you do not understand about the normalisation process as it applies to your scenario?

The various normalisation forms are well documented on the web. wikipaedia for one has more information on this than you can shake a stick at

http://en.wikipedia.org/wiki/Database_normalization

[NeoPa]

Designing a database is far more involved than simply going through a list of field names. This is something you will need to do yourself fundamentally. Others may offer tips or hints, but this is for you to do.

Another very useful link is Normalisation and Table structures.

[ob1kenobi]

Thanks. WIll check this out.

[NeoPa]

I hope it's helpful. We can offer more help for more specific questions.

Welcome to Bytes!