HIM650 Health Care Data Management

Week 5 Assignment  

Database Project Proposal – Part 3 Assessment Description

The purpose of this assignment is to provide learners a basic understanding for identifying a proposal for collecting data, designing and developing a small database, and presenting the proposal to stakeholders. To complete Part 3 of the Database Project Proposal assignment, create a PowerPoint (10-15 slides) presentation video discussing your database proposal. Using Loom, record your presentation and submit the unrestricted Loom link on the first page of your PowerPoint presentation to the instructor. Refer to the topic Resources for additional guidance on recording your presentation with Loom. Part 1   Apply principles of the systems development life cycle (SDLC) in your proposal by including the SDLC phases listed below into your presentation. You may copy and paste elements from past assignments that apply to the SDLC. Planning Analysis (What are the requirements of the current system’s end user?) Detailed Systems Design (Completes the design of the system’s processes, technical specifications, data dictionary, ERD diagram, training principles, and methodologies.) Implementation (Database is actually created and is customized by the creation of tables and views, user authorizations, etc. During this implementation phase, the database enters into a cycle of coding, testing, and debugging until it is ready.) Maintenance (During this phase, end users can begin to request change in it.) Part 2 The presentation must also include the following elements of the proposal: State the project problem and explain the role of the database in the organization. Identify database users (personnel/credentials): Who are they? What are their competencies and background? What training might the database end users need to utilize the database? Discuss the types of data that users will collect for the proposed database and the types of reports that will be generated for analysis, including  an explanation of their use as well as an explanation of who will use the reports. Describe the project goals and clear measurable objectives for the database. Provide examples of database schema components: database dictionary and ERD diagram. Demonstrate database functions by providing a screenshot of basic MySQL statements and their outcomes for at least four rows: Statements include: CREATE TABLE, ALTER TABLE, QUERY TABLE, ADD A NEW COLUMN, QUERY – COLUMN FUNCTIONS, ADD A NEW ROW, QUERY – AGGREGATION, MULTI-TABLE-QUERIES – JOINING, and QUERY – MULTI-TABLE. Explain policies, procedures, and regulations (HIPAA) to assure security, privacy, and integrity of the database proposal. Forecast any potential problems or barriers to meeting the project goals and objectives. Are there any specific assumptions that need to be made? Conclude with the value of the project, emphasizing feasibility, cost (including future costs, security costs, and hosting costs), necessity, usefulness, and the benefit of the expected results. Make sure to include an explanation on how this database will save the organization time and money and improve patient care/treatment with the data it will store and query both now and in the future. General Requirements Refer to the resource, “Creating Effective PowerPoint Presentations,” located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style. While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to LopesWrite. CAHIIM This assignment aligns to the following AMIA 2017 Core Competencies for Health Informatics Curricula at the master’s degree level: F2: Information Science and Technology: Does F4: Health Information Science and Technology: Does