469,578 Members | 1,821 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,578 developers. It's quick & easy.

creation of a church database to keep track of faithfuls,enrolment,activities and gif

The management of a big church would like database to keep track of people (faithful or devoted), enrollment, activities and gifts. The following assertions describe the data relationship:  Each devoted (faithful) has one matriculate number, which is assigned at the first enrolment.  Each faithful (devoted) can renew his enrollment every year, if he will continue at the same parish. The matriculate number should not change.  Each faithful appear in at least one group (ancient, councilor, deacon, chorister, without group) and many devoted may belong to the same group.  Each devoted may give a crop (special and annual gift), but only one devoted may place a particular crop.  Each group has many project they work on, they can use knowledge from any group, but each project is managed by only one group. For physical design it is necessary to determine what kind of processing needs to be done on the data; that is, what are the queries and updates needed to satisfy the user requirements, and what are their frequencies.
May 24 '18 #1
0 1599

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by d.schulz81 | last post: by
3 posts views Thread by Alan Wang | last post: by
11 posts views Thread by Andrew G. Koptyaev | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.