473,786 Members | 2,866 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Normalisation help

22 New Member
Hi,

Please Please Pleas could someone just help me and tell me what I should do. No one seems to actually help me don't post any normalization links. I'll give you an example of the problem:

I have a very small online business which has an offer available to customers. The offer is only available to one member of a household and only once from the same IP address. I then want to search for a specific user name in the IP section to see if any other accounts have tried to go in for the offer. Then I can work out if I should give it to the customer or not.

I have attatched my setup for this database as a photo. I have entered User name 1-5 as separate fields which are linked to the IP in the customers details. However I will find it hard if I want to search for a particular username as I will need to search each field individually.


I would like to see if there was a different way that I could set up the database structure in order to:

1 search for a username easily only entering the information once (not five times)
2. Be able to put in an unlimited number of links into the table, allowing a report to display all the user names effectively
Attached Images
File Type: bmp untitled 2 setup.bmp (36.4 KB, 170 views)
Feb 28 '07 #1
4 1501
MMcCarthy
14,534 Recognized Expert Moderator MVP
Hi,

Please Please Pleas could someone just help me and tell me what I should do. No one seems to actually help me don't post any normalization links. I'll give you an example of the problem:

I have a very small online business which has an offer available to customers. The offer is only available to one member of a household and only once from the same IP address. I then want to search for a specific user name in the IP section to see if any other accounts have tried to go in for the offer. Then I can work out if I should give it to the customer or not.

I have attatched my setup for this database as a photo. I have entered User name 1-5 as separate fields which are linked to the IP in the customers details. However I will find it hard if I want to search for a particular username as I will need to search each field individually.


I would like to see if there was a different way that I could set up the database structure in order to:

1 search for a username easily only entering the information once (not five times)
2. Be able to put in an unlimited number of links into the table, allowing a report to display all the user names effectively
Forget about Table2.

If you set properties for IPAddress field in Table1 to Indexed = Yes (No Duplicates) then you won't be able to enter the same IP address a second time. So if IPAddress is already in the database you won't be able to add it again.

Mary
Feb 28 '07 #2
663scott
22 New Member
Hi

Thanks for that. I understand that limitation, that is why I was hoping someone could help me how do I solve the issue ?

663scott
Mar 1 '07 #3
MMcCarthy
14,534 Recognized Expert Moderator MVP
Hi

Thanks for that. I understand that limitation, that is why I was hoping someone could help me how do I solve the issue ?

663scott
Sorry Scott but I really don't understand the question you are asking.
Mar 1 '07 #4
663scott
22 New Member
no problem didn't think you would
Mar 2 '07 #5

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

Similar topics

0
1431
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
1614
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
1339
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
2475
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
2118
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
1711
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
1590
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
1839
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
9647
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
10164
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10110
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7512
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
6745
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();...
0
5397
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4066
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
2
3669
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2894
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.