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
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
Homepage URL
Field_name
IDFather
Username
Date (new)
Date (modefied)
Validated
Name
Telephone mobile
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
Homepage URL
Similar DB for child 2 to 6 using IDChild2 - 6)
Jan Peter