Identify the purpose of the project and the data model

Assignment Help Database Management System

Reference no: EM131564407

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.

Reference no: EM131564407

Questions Cloud

Describe important aspects of unobtrusive research : State, in your own words, what you think are the most important aspects of unobtrusive research.

Sales revenue-consumer surplus : In a market with Qd = 4200 - 4P and Qs = -300 + P, determine: (a) equilibrium price, (b) equilibrium quantity, (c) sales revenue, (d) consumer surplus

Comment on culturally bound syndromes : Explain how the selected disorder is treated. Be sure to include all the views on appropriate treatment and comment on diversity of views or dissent.

How have you had to use threats in your daily life : How have you had to use threats in your daily life? Are they effective? minimum250

Identify the purpose of the project and the data model : Provide the background information of the data model to be developed. Identify the purpose of the project and the data model.

Propose one security control that a business could consider : Propose at least one security control that a business could consider implementing in order to protect against the IT security concern in question.

Major ways this will effect islands or coastal areas : And What can the expected rise be by 2050? What are three major ways this will effect islands or coastal areas?

Holding period yield and rate of return : If you actually sell the bond before it matures, your realized return is known as the holding period yield (HPY). What price will your bond sell for?

Write a essay about self-reliance : Write a essay about " Self-Reliance" you can find this article on internet. Read it and write 2 pages essay what you think .

User Account

All Pages