Hello,
Could someone please point me in the right direction regarding a
relational design question.
The situation is holding contact addresses for Individual contacts and
their organisations, where each organisation could have several
contacts with different addresses or the same address. Not wanting to
duplicate addresses if possible, I am thinking about a table holding
only the address info and separate tables for organisations and
contacts. But I then need to make a link from the Org and Individual
to a shared address (ie where they are the same thing).
I would greatly appreciate any guidance that can be thrown my way.
Many thanks, and I look forward to reading any responses.
Kev 4 1298
Hi!
I'll give it a try :-)
I have a similar construction in a db.
I used four tables:
tblIndividualsC ontacts
tblZipCodes
tblOrg
tblRegistration
tblRegistration is used for, that's right!, registration of contacts
and what organization they belong to.
tblZipCodes holds: ZipCodeID,ZipCo de, City
and the rest is obvious I think.
Don't know really if this is the optimal design, but it works fine for
our company.
I think you could do without tblRegistration , if your goal is only to
register when creating a new contact. Then all registration would take
place in tblIndividualsC ontacts.
Hope this can help you out :-)
Kev.T skrev: Hello,
Could someone please point me in the right direction regarding a relational design question.
The situation is holding contact addresses for Individual contacts and their organisations, where each organisation could have several contacts with different addresses or the same address. Not wanting to duplicate addresses if possible, I am thinking about a table holding only the address info and separate tables for organisations and contacts. But I then need to make a link from the Org and Individual to a shared address (ie where they are the same thing).
I would greatly appreciate any guidance that can be thrown my way.
Many thanks, and I look forward to reading any responses.
Kev
Possibilities:
tblContact
ContactID autonumber
first name
last name
other fields
CompanyID foreign Key to Company table
AddressID foreign key to Address Table
tblCompany
CompanID autonumber
Company name
other company info
AddressID foreign key to Address Table
tblAddress
AddressID autonumber
addressline1
addressline2
addressline3
ZipcodeID foreign key to Zipcode table
tblZipcode
ZipcodeID autonumber
Zipcode
City
State
Country
If you make the zipcode table as above then you can
have to city names for same zipcode which can occur. If you use the
ZipCode as the key then ONLY ONE name can be associated with zipcode.
Will need to allow for changing the address for the contact, but can
default to the company address when originally created. How to present
the possibility or recognizing the potential may take some thought.
Thanks Krij I will give your suggestion a try, and let you know how I
got on.
Krij wrote: Hi! I'll give it a try :-)
I have a similar construction in a db.
I used four tables:
tblIndividualsC ontacts tblZipCodes tblOrg tblRegistration
tblRegistration is used for, that's right!, registration of contacts and what organization they belong to.
tblZipCodes holds: ZipCodeID,ZipCo de, City
and the rest is obvious I think.
Don't know really if this is the optimal design, but it works fine for our company.
I think you could do without tblRegistration , if your goal is only to register when creating a new contact. Then all registration would take place in tblIndividualsC ontacts.
Hope this can help you out :-)
Kev.T skrev:
Hello,
Could someone please point me in the right direction regarding a relational design question.
The situation is holding contact addresses for Individual contacts and their organisations, where each organisation could have several contacts with different addresses or the same address. Not wanting to duplicate addresses if possible, I am thinking about a table holding only the address info and separate tables for organisations and contacts. But I then need to make a link from the Org and Individual to a shared address (ie where they are the same thing).
I would greatly appreciate any guidance that can be thrown my way.
Many thanks, and I look forward to reading any responses.
Kev
Thanks Ron, I will have a play with this one and let you know how I
get on.
Ron2006 wrote: Possibilities: tblContact ContactID autonumber first name last name other fields CompanyID foreign Key to Company table AddressID foreign key to Address Table
tblCompany CompanID autonumber Company name other company info AddressID foreign key to Address Table
tblAddress AddressID autonumber addressline1 addressline2 addressline3 ZipcodeID foreign key to Zipcode table
tblZipcode ZipcodeID autonumber Zipcode City State Country
If you make the zipcode table as above then you can have to city names for same zipcode which can occur. If you use the ZipCode as the key then ONLY ONE name can be associated with zipcode.
Will need to allow for changing the address for the contact, but can default to the company address when originally created. How to present the possibility or recognizing the potential may take some thought. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Pritcham |
last post by:
Hi
I'm currently having to design a database for a recruitment agency
that's just started up and have one area where I'm a little unsure
where to go.
Basically I've implemented the 'standard' Customer, Contacts tables
linked on CustomerID, and also have CallRecords (for phone calls etc
made to contacts) Linked on ContactID.
|
by: Steve |
last post by:
Hi all
Ok then I have searched through the back postings for a while now on google
and read some interesting stuff on how to model a typical client / order db
however....
My problem is that I have a client who wants to have multiple contacts &
multiple address for each client. (about 2,000 client) He also has about 10
standard access driven letters he sends out to them periodically - however
he wants the ability to set up multiple...
|
by: Mark H. |
last post by:
Hello ppl,
I d like some help designing a customized contact list.
I have a table for people and a table for addresses.
In 99% of the cases one person will have one or more addresses so we have 1
to many there.
In very very rare cases one address will belong to more than one person. For
example, a husband and wife may be individual contacts but have the same
address.
|
by: Tim Fierro |
last post by:
Hello,
I have had many years using flat file databases (File Express from way back)
but am now at a company where a relational database is needed and would
carry us into the future. Since I know some basics on databases, have VB
Pro programming experience over the years, and I know most of what we need
to carry as far as data; I have decided to create a database for our needs
instead of finding an off the shelf program that may not be...
|
by: stormogulen |
last post by:
Hi!
I'm hoping someone can help me come up with a 'best possible solution'
for the following problem:
I'm trying to design an addressbook, i.e a storage for adresses. I
would like my adresses to have a random number of fields, all of which
are strings. Futhermore every address can belong to zero or more
categories (ie. friend, family etc.)
| |
by: Allen Anderson |
last post by:
Hi,
I'm trying to design contact (names and addresses) tables in an Access
database. Some of the contacts represent vendors, some are board members of
the organization, some are donors, some are neighbors of the organization,
some are politicians, etc. Rather than create separate tables for each type
of contact, I thought it would be better to have:
one table with names/addresses
one table with kinds of lists (vendors, board...
|
by: deekay |
last post by:
At the moment I have simple Access DB with 3 tables Companies,
Contacts and Activities.
In the Company table we have stored the address fields
Address
Street
Suburb
City
Code
|
by: Ant Grinyer |
last post by:
Having worked in software development for over 15 years in many
organisations using different development methodologies such as
waterfall, RUP, Scrum and XP, I'm still not sure if there is a
specific 'type' of organisation that is more likely to adopt agile
approaches than others?
I guess it could be argued that those organisations that are more
innovative or open to change are more likely to adopt agile methods?
To try and gain more...
|
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...
|
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,...
|
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...
| |
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...
|
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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
| |