Gossamer Forum
Home : Products : DBMan : Discussions :

What kind of database should I make - Single or Relational?

Quote Reply
What kind of database should I make - Single or Relational?
I am the webmaster of http://www.colombiaklubben.no. It is the web for Colombiaklubben (Norway/Europe) - A club for families with children adopted from Colombia.

I want to make a database to hold the members addresses and personal info.
All the members will not use all the fields. We have for instance families who are waiting for their first child, members with 2, 3, 4 or 5 children (6 is in case someone gets 6 children) Other fields some people will not use are Email, phone ...

What kind of database should I make - Single or Relational?
The database will in single DB hold a lot of fields.

Is there other things I should take into consideration?


These are the fields I want to use:

Single DB:

Field_name
ID
Username
Date (new)
Date (modefied)
Validated
Rolle
Mothers name
Fathers name

Name 1st child
Birhplace 1st child
Birthdate 1st child
Adoptiondate 1st child
ICBF or private orphanage
If private orphanage - Name of orphanage
- Similar fields for child 2 - 6
Address (street)
Address (zip)
Address
Town/City
County
Telephone private
Telephone mobile
Telephone mobile
Email (Mother)
Email (Father)
Homepage URL
Presentation


Relational DB:

Field_name
IDFamily
Username
Date (new)
Date (modefied)
Validated
Rolle
Address (street)
Address (zip)
Address
Town/City
County
Telephone private
Homepage URL
Presentation

Field_name
IDMother
Username
Date (new)
Date (modefied)
Validated
Name
Telephone mobile
Email
Homepage URL

Field_name
IDFather
Username
Date (new)
Date (modefied)
Validated
Name
Telephone mobile
Email
Homepage URL

Field_name
IDChild1
Username
Date (new)
Date (modefied)
Validated
Name
Birhplace
Birthdate
Adoptiondate
ICBF or private orphanage
If private orphanage - Name of orphanage
Email
Homepage URL

Similar DB for child 2 to 6 using IDChild2 - 6)

Jan Peter
Subject Author Views Date
Thread What kind of database should I make - Single or Relational? JPWiese 3901 Aug 30, 2002, 4:52 AM
Thread Re: [JPWiese] What kind of database should I make - Single or Relational?
LoisC 3817 Aug 30, 2002, 9:31 AM
Thread Re: [LoisC] What kind of database should I make - Single or Relational?
JPWiese 3817 Sep 1, 2002, 12:13 PM
Thread Re: [JPWiese] What kind of database should I make - Single or Relational?
LoisC 3817 Sep 1, 2002, 2:07 PM
Post Re: [LoisC] What kind of database should I make - Single or Relational?
JPWiese 3811 Sep 1, 2002, 10:21 PM