DBST 651 Project Part 1 Fritz Cenal March 1, 2018 Database Requirement Specification Document Overview This project is about the database requirement specification for Laurel Hospital. The main purpose of the document is to highpoint how the hospital management can track the customers/patients, appointments, billing and employees. In addition the hospitals practitioners need a database to track patients because the patients need a database to track their medication. On the hand the employees need a database to track their benefits and other works related to their job. Objective of the Database Project The purpose of the database will serve as a directory to all of the users of the Laurel Hospital. This document will also provide a …show more content…
To process data into meaningful information that can be used by management in high-level decision making. Project Scope Purpose and Justification of the Project The laurel hospital Database Project will create a centralized database to manage all its daily operations. The primary goal of this project is to integrate all the operations of laurel hospital into a common managing system that will be maintained by one central database. With this system the hospital will be better managed by achieving their short terms and long term goals. It will also reduce the problems of finding the right resources on a timely manner and mitigating risks before they become uncontrollable. • The scope of the Database Project is to create a plan, design, upgrade and a MySQL database. • Management will be able to track patients, scheduling, transactions, employees as well as other hospital related activities. • Some users may have different roles based their duty so they can update, delete and insert data. • There will be dashboard for each application interacting with the database. 4. Databases Goals, Expectations and deliverables High Level Project …show more content…
The database will be accessible remotely or in the hospital for all of the employees. 3. Create a number of application in order for the database to be user friendly. 4. On demand question and answers for any problems without contacting the staff There will be a project team created from the hospital’s IT department. Some of the IT professionals will be part of the project team. However, the project manager will be subcontracted to another company. His role will involve making sure that IT professionals include all the requirements specified in the requirements document. In some instances when needed in a full recovery mode the main task is to restore the database or keep it offline for a while. It will be brought online only after the data is recovered to a certain access point. In addition the user has to restore all succeeding transaction logs backup and finally recover the database. By utilizing this model, the SQL Server s keeps the transaction log until that time it is backed up. Project Hardware and Software Tools 1. The project should be complete within the hospital minimal budgets. 2. The database must conform to the current hardware and software requirements to evade additional