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

Normalisation Help

P: 2
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
Apr 29 '10 #1

✓ answered by 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.

Share this Question
Share on Google+
4 Replies


Jim Doherty
Expert 100+
P: 897
@ob1kenobi
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
Apr 30 '10 #2

NeoPa
Expert Mod 15k+
P: 31,186
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.
Apr 30 '10 #3

P: 2
Thanks. WIll check this out.
May 4 '10 #4

NeoPa
Expert Mod 15k+
P: 31,186
I hope it's helpful. We can offer more help for more specific questions.

Welcome to Bytes!
May 4 '10 #5

Post your reply

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