Assignment: HOSPITAL MANAGEMENT SYSTEM DATABASE
Data Management Project Requirements:
This will be an individual project. The final project plan with all design, research, and work should be completed by each student individually. Students will become familiar with data management, database modeling and design, and the skills to develop a final project plan. These requirements include (Requirements Analysis - Data model - In physical design format):
• Background
• Purpose
• Business goals and rules
• User requirements
• Data requirements
• Reporting requirements
• Project schedule and project costs.
• Data dictionary for all tables in data model
• SQL statements: Identify the database management system (DBMS) that will be used for the database design
• minimum of two CREATE TABLE statements (for entities defined in model)
• minimum of two SELECT statements
• One insert, update or delete statement.
Each Part there will be a deliverable due for different components. The deliverables are as follows:
Part 1 - Data Management Project Description
o Provide the background information of the data model to be developed.
o Identify the purpose of the project and the data model.
Part 2 - Data Management Project Outline
o Define Entities, primary keys, and relationships that are used to define the data model for your project.
Part 3 - Data Management Project Initial Rough Draft
o Submit a rough draft or conceptual model.
o Use the entities, primary key, and relationships identified in Part 2 to develop this model.
Part 4 - Data Dictionary
o Use one or two entities from Part 3 submission of data model.
o Provide the following information for the data dictionary: attribute name, data type, size, and definition.
o Sample formats are provided.
Part 5 - ERD Diagram
o For all tables: primary keys, attributes, data types Define all relationships
o Define all foreign keysThis database should be normalized in 3rd normal form.
Part 6 - Final Project Rough Draft Submission (before Final Draft Submission in Part 7)
o All project requirements identified above should be submitted in this "final rough draft"
o This will give students the capability to get feedback and identify any issues before submitting final project in Part 7.