The business manager of a Church identifies the need for a computerized system to help the Church better meet its information needs and manage its activities. The Church has three services on Sundays where it collects revenue from the congregation in the form of weekly contributions. The other source of revenue for the Church is fees paid by households for ceremonies performed by the Church. The new system must manage all revenue derived from contributions and fees paid for ceremonies.
The system must also keep track of records of its ceremonies such as baptisms, weddings, and funerals. A baptism is a formal initiation ceremony into the Church for infants and some adults. For couples who wish to get married in the Church, at least one member of the couple must be a member of the Church. For funerals, the deceased does not have to be a member of the Church. Data will be maintained about households and their members, the various types of contributions, and the ceremonies performed by the church.
The management of the Church is concerned with registering new members. When a prospective member wants to join, the reverend holds a personal meeting with that person and his/her family to get better acquainted. The head of the household must use a website to register the household and the members of the household. The data from each household is stored in a database. The household serves as the primary financial contact between the family and the Church. That is, the household makes weekly contributions. Data is maintained about all individuals who comprise the household in the “family member” database. The Church itself is registered as a household and has a record in the household database with a unique identifier.
After registration, the household is mailed pre-numbered envelopes for use in the regular Sunday collections. The contributions from the head of the household are made to the Church using these envelopes. It is assumed that...