IT 204 Final Project.docx - IT 204 Final Project Business...

This preview shows page 1 - 6 out of 12 pages.

IT 204 Final Project Business Case and Gap Analysis 1. Background Birchwood Lane Schools must implement an application system to meet new federal and state requirements to record all student, instructor, and course information electronically. The school currently records the data manually on paper. 2. Desired results Implementing a database management system (DBMS) for recording and tracking data will bring the school into compliance with the new requirements and improve the school’s efficiency, accuracy, and security. 3. Current performance Manually recording data on paper takes up valuable space, is susceptible to damage and being misplaced, is challenging to make changes, is time-consuming for storing and accessing, and does not have proper security to records 4. Deficiencies and solutions A DMBS can solve all of the current issues. The DMBS takes up less physical space than paper records freeing up space to be better utilized by the school. With a proper backup system, the DBMS can maintain an off-site image, ensuring limited data loss in case of damage to the on- site system. Users with the correct access can make necessary changes to records in real-time. Electronic records can be stored and retrieved from any computer with access to the DBMS. Security to data is established through user roles, and activities are logged.
5. Implementation During the initial stage of implementation, the school board and staff will be interviewed to determine the budget, desired outcomes, and to outline the current business processes. During this information gathering, user roles within the DBMS will be identified and established.
Relational Database Model 1. Conceptual Model
Relational Database Model 2. Logical Model
Database Selection I chose MySQL as the DBMS for this project. MySQL is an open-source database, is available under the GPL license, and is supported by a large and active open source community. The following information corresponds to the DBMS specification table.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture