INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

New Database Brief

New Database Brief

(OP)
Hi

So i've been asked at work to create a new database, i've created many in the past but thought i'd get a few ideas from people as to how to best create a good design both in tables and relationships. I think i might need a many to many relationship which i sort of know how to do but... anyways here's what i need to do:

The database is basically a family unit for a play scheme (out of school clubs etc) so i need to record:

all the members of the family
each family member might have a different address
i need to keep a record of each parents employee details

I did think about using:

tblFamily
lngFamilyID

tblParent
lngParentID (PK)
lngFamilyID (FK)
strParentname
lngAddressID

tblAddress   (many to many)
lngAddressID
lngParentID
lngChildID

tblChild
lngChildID (PK)
lngParentID (FK)

So i think i could use the above tables and link them via the respective foreign keys. This would allow me to have each family member could live at different addresses etc.

I also need to keep a record of each parent's employee details.
Is there also a way of copying and inserting an address into another family members details? Say if there was 10 people in a fmaily, i don't want the user to have to type in the address 10 times, so maybe a command button that inserts the main family address into the record.

So is the above table design a good place to start or pretty bad design?

Mikie

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close