By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,011 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

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

P: 1
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
Share this question for a faster answer!
Share on Google+

Post your reply

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