Comprehensive Relational Database Design and Development for Local Church: A Teaching Case Study
Exam Elaboration | Education
Comprehensive Relational Database Design and Development for Local Church: A Teaching Case Study
SKU: | Pages: 7 | Year: 2024
Document Brief Description
Muhammed Miah
mmiah@suno.edu
Adnan Omar
aomar@suno.edu
Department of Computer Information Systems
Southern University at New Orleans
New Orleans...Muhammed Miah
mmiah@suno.edu
Adnan Omar
aomar@suno.edu
Department of Computer Information Systems
Southern University at New Orleans
New Orleans, LA
Abstract
Thousands of organizations depend on the accurate recording, updating and tracking of their data on a
real time basis. Employees use this data to complete accounting reports, calculate sales estimates and
invoice customers. Without database management, tasks have to be done manually and take more time.
However, with this database management system the local church will now have the right tool to manage
data efficiently and allows users to perform multiple tasks with ease. Users will now have the ability to
store, organize and manage a large amount of information within a single software application. It will
also increase efficiency of the organization, reduce overall costs, and give more control over data. Staff
members will now be able to keep records and generate reports of contacts, attendance, donations,
involvement in different ministries for members and visitors; records for special events and various
activities.
Keywords: Case Study, Database Design, Database Development, MS Access, SQL.
1. CASE SUMMARY
Established in 1994, this local church (we will call
“the church”) has about couple of hundred regular
members and many visitors who are not listed as
members. It is an event driven ministry focused
on enhancing, fortifying, and sustaining the
integrity of the modern family. The goal of the
church is to impact singles, couples, and families.
However, keeping track of the members and
visitors record has been a challenge over the
years. Currently the church manages everything
manually. Without a database management
system, administration finds it difficult to
organize and control the data. There has also
been issue of concurrency, security, no data
backup and recovery or the integrity of members’
information.
With this new database management system, the
organization will be able to handle multiple types
of data. Some of the data that are easily managed
with this type of system include: employee
records, members’ information, donation, event
management, and pastor sessions. This system is
built to be extremely versatile.
Without database management, tasks have to be
done manually and take more time. Data can be
📄 7-pages detailed model answer (PDF + online view)