Gossamer Forum
Home : Products : DBMan : Discussions :

Re: [JPWiese] What kind of database should I make - Single or Relational?

Quote Reply
Re: [JPWiese] What kind of database should I make - Single or Relational? In reply to
Just a suggestion but I think unless you were going to have a large number of entries you may just want to have it all in one database.

If you were going to go with the relational I would suggest all the contact information in the main database, and then group all the children information into a second. No need to make a database for each child. For example:

Main:

Username - keyfield
PostDate
ModDate
Validated
Rolle
Last Name
Mothers name
Fathers name
Address (street)
Address (zip)
Address
Town/City
County
Telephone private
Telephone mobile
Telephone mobile
Email (Mother)
Email (Father)
Homepage URL
Presentation

Children:

Username - association between dbs
ChildrenID - keyfield
PostDate
ModDate
ValidatedC

Then repeat these fields for each child

Child_Name1
Birhplace1
Birthdate1
Adoptiondate1
ICBF1 (yes/no)
Orphanage1

Just an idea .. perhaps others will add their ideas.

Unoffical DBMan FAQ

http://creativecomputingweb.com/dbman/index.shtml/
Subject Author Views Date
Thread What kind of database should I make - Single or Relational? JPWiese 3963 Aug 30, 2002, 4:52 AM
Thread Re: [JPWiese] What kind of database should I make - Single or Relational?
LoisC 3876 Aug 30, 2002, 9:31 AM
Thread Re: [LoisC] What kind of database should I make - Single or Relational?
JPWiese 3875 Sep 1, 2002, 12:13 PM
Thread Re: [JPWiese] What kind of database should I make - Single or Relational?
LoisC 3876 Sep 1, 2002, 2:07 PM
Post Re: [LoisC] What kind of database should I make - Single or Relational?
JPWiese 3869 Sep 1, 2002, 10:21 PM