Click here to Skip to main content
12,693,891 members (33,327 online)
   

Database

 
GeneralThe "bug" is actually in the Fill() method Pin
Allan Watkins16-Oct-12 17:09
memberAllan Watkins16-Oct-12 17:09 
AnswerRe: Bug in SQLBulkCopy? Truncates decimal digits after 26 records Pin
Aadhar Joshi17-Oct-12 2:31
memberAadhar Joshi17-Oct-12 2:31 
QuestionConfigure SQL Server 2005 Remote Access Pin
Kevin Marois11-Oct-12 12:35
memberKevin Marois11-Oct-12 12:35 
AnswerRe: Configure SQL Server 2005 Remote Access Pin
Marcus Kramer11-Oct-12 13:06
memberMarcus Kramer11-Oct-12 13:06 
AnswerRe: Configure SQL Server 2005 Remote Access Pin
Eddy Vluggen11-Oct-12 13:37
memberEddy Vluggen11-Oct-12 13:37 
AnswerRe: Configure SQL Server 2005 Remote Access Pin
Bernhard Hiller12-Oct-12 4:24
memberBernhard Hiller12-Oct-12 4:24 
QuestionGlobal Database Design for example to store Addresses Pin
LiQuick10-Oct-12 22:38
memberLiQuick10-Oct-12 22:38 
AnswerRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson10-Oct-12 23:59
memberJörgen Andersson10-Oct-12 23:59 
Cool problem.

The answer is to normalize properly.
One table for countries. One for address types, such as delivery addresses or box addresses and so on, per country.
One for address parts with one row per street housenumber, town, zip and so on.
Another one for holding the combination of addressparts and addresstypes, with ordering, or rather placement on the letter.
You'll need one table to hold the addresses as an entity, with an address type reference, not the actual data.
This table could of course be combined with a person or company if that's fitting, but I woud split it as a company might have more than one address.
And lastly one for holding the actual data with one row per address_type_part and address.

Make a model of this and check if I've forgotten anything.
Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions


modified 11-Oct-12 6:18am.

GeneralRe: Global Database Design for example to store Addresses Pin
Eddy Vluggen11-Oct-12 0:48
memberEddy Vluggen11-Oct-12 0:48 
GeneralRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson11-Oct-12 1:16
memberJörgen Andersson11-Oct-12 1:16 
GeneralRe: Global Database Design for example to store Addresses Pin
J4amieC11-Oct-12 1:36
memberJ4amieC11-Oct-12 1:36 
AnswerRe: Global Database Design for example to store Addresses Pin
ihoecken11-Oct-12 0:04
memberihoecken11-Oct-12 0:04 
AnswerRe: Global Database Design for example to store Addresses Pin
Eddy Vluggen11-Oct-12 1:44
memberEddy Vluggen11-Oct-12 1:44 
GeneralRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson11-Oct-12 2:36
memberJörgen Andersson11-Oct-12 2:36 
GeneralRe: Global Database Design for example to store Addresses Pin
Eddy Vluggen11-Oct-12 2:51
memberEddy Vluggen11-Oct-12 2:51 
GeneralRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson11-Oct-12 2:59
memberJörgen Andersson11-Oct-12 2:59 
GeneralRe: Global Database Design for example to store Addresses Pin
Eddy Vluggen11-Oct-12 5:42
memberEddy Vluggen11-Oct-12 5:42 
GeneralRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson11-Oct-12 9:24
memberJörgen Andersson11-Oct-12 9:24 
GeneralRe: Global Database Design for example to store Addresses Pin
Eddy Vluggen11-Oct-12 11:09
memberEddy Vluggen11-Oct-12 11:09 
AnswerRe: Global Database Design for example to store Addresses Pin
jschell11-Oct-12 10:20
memberjschell11-Oct-12 10:20 
AnswerTHX: Global Database Design for example to store Addresses Pin
LiQuick12-Oct-12 5:21
memberLiQuick12-Oct-12 5:21 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Eddy Vluggen12-Oct-12 6:37
memberEddy Vluggen12-Oct-12 6:37 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Jörgen Andersson12-Oct-12 9:15
memberJörgen Andersson12-Oct-12 9:15 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Eddy Vluggen12-Oct-12 11:54
memberEddy Vluggen12-Oct-12 11:54 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Jörgen Andersson12-Oct-12 12:34
memberJörgen Andersson12-Oct-12 12:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.170118.1 | Last Updated 16 Jan 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid