Hillcrest Baptist Church (HBC) Facilities Database Capstone project pp

Views:
 
Category: Education
     
 

Presentation Description

No description available.

Comments

Presentation Transcript

Hillcrest Baptist Church (HBC) Facilities Database: 

Hillcrest Baptist Church (HBC) Facilities Database COT6931 - Capstone Project Prepared by Phillip Lee

Problem Overview: 

Problem Overview Information not standardized Mixture of spread-sheets and hard-copies Limited access to information No Access or other database Current data has duplicate information Slow Almost completely manual process

Justification for the Project: 

Justification for the Project Hillcrest Baptist Church was in need of a solution that would provide the following: A database to store facilities data A highly efficient search through the data Standardization of data/information

Application Overview: 

Application Overview Access Database application developed in Microsoft Access A GUI application to query the Access DB developed in JAVA Consists of the following three components: An Access Database Dashboard Report Output Document

Scope of the Project: 

Scope of the Project May 9 th – December 8 th Develop an electronic solution to replace the current processes. Implement the new solution internally within Hillcrest Baptist Church.

Access DB: 

Access Database Teacher data Room data Clacc_Time data Access DB

Accessing the Database Application: 

Accessing the Database Application

Additional Processes: 

Additional Processes Use-Case Scenarios Security Requirements Output reports On-screen Save to a text document or an Excel spread-sheet

GUI Application: 

GUI Application

Stored Procedures: 

Stored procedures/queries developed for client. Used in conjunction with GUI Application. Client trained in basics of Query Design. Stored Procedures

Conclusion: 

The project was a success. The client was pleased with the new program and the possibilities for it’s use. Conclusion