Dynamic contacts database

Question

I'm trying to create a database for contacts. I must have many categories for every contact, like Home, Office, Emails, Phones. In every category one can add more than one value. Also the categories can be dynamic. How can this be designed in a database?

Answer 1

Check out relational database design. It's an art and a science, and something that really can't be explained to the fullest in a post. But what you should do is create relationships between contacts and all possible data that will be related to it. This is most prevalent through the use of primary and foreign key relationships.

Answer 2

Have a look at "free data models" on databaseanswers.org. For example, "Contact Management"

Your question is too broad: you can hire me to do it of course :-)

Answer 3

Sounds like a pretty traditional relational database design.

CREATE TABLE Contact
(ContactId INT IDENTITY(1,1) PRIMARY KEY,
FirstName nvarchar(255),
LastName nvarchar(255))
GO
CREATE TABLE Methods
(MethodId INT IDENTITY(1,1) PRIMARY KEY,
MethodDescription VARCHAR(25))
GO
INSERT INTO Methods
(MethodDescription)
VALUES
('Work Phone'), ('Home Email'), ('Home Phone'), ('Work Email')
GO
CREATE TABLE ContactMethods
(ContactMethodsId INT IDENTITY(1,1) PRIMARY KEY,
ContactId INT,
MethodId INT)
GO

Answer 4

You should look at Universal Data Models for Party Contact Mechanism, which allows you to store as many contacts and category of contacts that you want.