473,799 Members | 3,212 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Normalisation Help

2 New Member
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
4 1566
Jim Doherty
897 Recognized Expert Contributor
@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
32,579 Recognized Expert Moderator MVP
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
ob1kenobi
2 New Member
Thanks. WIll check this out.
May 4 '10 #4
NeoPa
32,579 Recognized Expert Moderator MVP
I hope it's helpful. We can offer more help for more specific questions.

Welcome to Bytes!
May 4 '10 #5

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

Similar topics

0
1432
by: Michael Lauzon | last post by:
Database Normalisation Advisor Designated Contact: thox, xpl2 Status: Open Open Date: 2004-10-26 11:53 For Project: Lands of Myths & Legends (http://sourceforge.net/projects/lamyle/) Long Description: Our project requires someone to advise us on the database structure for a game that we are planning to create. The key requirements are
1
1615
by: Michael Lauzon | last post by:
Database Normalisation Advisor Designated Contact: thox, xpl2 Status: Open Open Date: 2004-10-26 11:53 For Project: Lands of Myths & Legends (http://sourceforge.net/projects/lamyle/) Long Description: Our project requires someone to advise us on the database structure for a game that we are planning to create. The key requirements are
0
1340
by: Michael Lauzon | last post by:
Database Normalisation Advisor Designated Contact: thox, xpl2 Status: Open Open Date: 2004-10-26 11:53 For Project: Lands of Myths & Legends (http://sourceforge.net/projects/lamyle/) Long Description: Our project requires someone to advise us on the database structure for a game that we are planning to create. The key requirements are
2
3826
by: James W. | last post by:
Hi everyone, I would like to ask you lot if you know of a great place on the internet for a fool proof idiots guide to Normalisation 1st, 2nd, 3rd. I looked at webopedia but that is just as confusing. I am looking for a complete idiots guide that really is so simple all it needs is pictures to turn it into a kiddies book
11
2476
by: Michael Thomas | last post by:
Hi everyone Not sure if this is the right newsgroup to be posting to for this question, but I am using Access 2002 to develop a database solution for the company that I work for. It's basically as stock control system where I need to keep track of the quantities of products. Our company is a retail chain, and we have eight shops or locations and a head office. The tables that I've set up are as follows
3
1472
by: Macbane | last post by:
Hello All, This has been bugging me for too long. I have a database that records medical interventions. I am familiar with the theory behind normalisation but am unsure what to do with the following data. Firstly, I have a main table which records the specifics of the intervention (date, reporter, details, location etc). It has links and the database is normalised ok as far as I can make out. However, I have 6 check box fields in...
1
2119
by: shauna | last post by:
hi, i am an As level student studying Applied ICT, im having problems with normalisation. our problem is to computerise a made up business.mine for example is a beauty salon. below are my attributes and they need to be normalised to 3rd normal form! i have also shown what i have come up with but i am unsure as to whether it is correct! please help as im finding this very difficult. Normalisation The goal of normalisation is to create a...
2
1713
by: hiyamwah | last post by:
Hi i am a little unsure of how you do this problem: A company wishes to allocate staff to a new project that as been proposed by the company. As a result, a new relation was created for this propose as follows: Staff_Project (Staff_No, Proj_Id, Proj_Name Proj_Location, Staff_Hours, Staff_Name, Staff_Address) Assuming that, Staff_No stands for staff number of the employee; Proj_Id is identifies of one of the projects that the...
1
1592
by: mlewis | last post by:
Hello I would be most grateful for a little help / discussion on a normalisation / db structure question I have. I think the issues are pretty well explained graphically on my link (below) but the main question is I'm wondering whether the tables items and services should be in one table with an identifier and whether service providers and service customers should be in one customer table for the purpose of ordering. View of my design ...
2
1842
mikek12004
by: mikek12004 | last post by:
I have a table for categories (id->the primary key, and name) and I want to add another column parent (one category might be inside another) with the id's range of values so in fact parent will be a foreign key of the id right?Can I declare a foreign key of a primary key in the same table as that primary key or it is better make a seperate table for the relationships between categories? (lately been reading about db normalisation and wandering...
0
9687
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9541
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10485
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10027
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9073
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7565
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6805
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4141
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2938
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.