Hi,
I'm new to this forum. We're trying to set up a simple database for maintaining church members records.
After some googling we thought that this design could suit us. Could some of you let us know if this design makes sense ?
*Tbl_Family*
Fam_ID (PK)
Family_LstName
Address
Area
No of Members
City
State
PinCode
Phone
Anniv Date
>
*Tbl_Individual*
Ind_Id (PK)
Fam_Id (Foreign Key from table family)
fname
mdname
Gender
Relnship with Family
DOB
DOBaptism
Death_Date
Contact
*Tbl_Ministry*
Min_ID(PK)
Min_Name
Min_Desc
*Tbl_MinMembers*
Min_Mem_ID(PK)
Min_ID (Foreign Key from Tbl_Ministry)
Ind_ID (Foreign Key from Tbl_Individual)
Min_POS (teacher, director, etc.,)
Thank you,
Carl