Gossamer Forum
Home : Products : DBMan : Discussions :

Relational Database

Quote Reply
Relational Database
I am thinking about making a relational database. Or as relational as a flatfile database can be
Before I start I need some advice: Is this doable?

"One to many" as "Address to Person" as "Database1 to Database2"
* = only visible to Admin

Database1: Address
*UserID #Username
*AddressID #Numer
*Email #For registration
Streetaddress
Zip
City
Telephone
Presentation of the family
-Link to "Add person" = Database2

Database2: Person
*UserID #Username
*PersonID #Numer
*Email #For registration
Type of registration (Choose..., Family, Youth)
FamilyRole (Choose..., Mother, Father, Child)
Firstname1
Firstname2
Lastname1
Lastname2
Birthdate
Birtheplace
Adoptiondate
Adopted from (Choose..., ICBF, Orphanage)
Which Orphanage?
Cellphone
Email
Homepage
Presentation of person

Output1: Family/Youthgroup # All persons and addressinformation attached to UserID
*UserID
*PersonID
*AddressID
Type of Registration: Family
Mother: Firstname1, Firstname2, Lastname1, Lastname2, Output2: (Person - Details)
Father: Firstname1, Firstname2, Lastname1, Lastname2, Output2: (Person - Details)
Child: Firstname1, Firstname2, Lastname1, Lastname2, Output2: (Person - Details)
Child: Firstname1, Firstname2, Lastname1, Lastname2, Output2: (Person - Details) #More Children
#Alternative:
Type Registration: Youthgroup
Youth: Firstname1, Firstname2, Lastname1, Lastname2, Link to Output2 (Person - Details)
Streetaddress
Zip, City
Telephone
Presentation of the family

Output2: Person - Details
*UserID
*PersonID
Type of registration: Family or/and Youthgroup
Role in family: (Mother, Father, Child)
Firstname1, Firstname2, Lastname1, Lastname2
Birthdate, Birthplace
Adoptiondate, Adopted from, Which Orphanage
Streetaddress
Zip, City
Telephone
Cellphone
Email
Homepage
Presentation of person
Link to Output1 - (Family/Youthgroup)
If Type of registration = Youthgroup or If Familyrole = Child - Link to Output3 (Special Days)

Output3: Special Days - Children and Youth
Firstname1, Firstname2, Lastname1, Lastname2, Birthdate, Birthplace, Adoptiondate, Link to Output2 (Person - details)

Output4: Box on frontpage - Birthdays today!
Todays date, Firstname1, Firstname2, Lastname1, Lastname2, Age, Link to Output1 - (Family/Youthgroup)
Bacchus
-----------------------------------------------------------
The only interesting question about red wine is:
Is it enough?
Subject Author Views Date
Post Relational Database Bacchus 2353 Jan 30, 2004, 3:08 AM