100%(1)1 out of 1 people found this document helpful
This preview shows page 1 - 6 out of 12 pages.
IT 204 Final ProjectBusiness Case and Gap Analysis1. BackgroundBirchwood 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 resultsImplementing 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 performanceManually 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 records4. Deficiencies and solutionsA 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. ImplementationDuring 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 Model1. Conceptual Model
Relational Database Model2. Logical Model
Database SelectionI 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.