Data Storage Design/ implementing an application into a hospital (EPIC)
n the previous assignment, you completed the detailed requirements and user interface design for the project, and you can now turn your attention to the data that your application will handle. Most business applications deal with significant amounts of data, and these data must be stored, retrieved, and manipulated in efficient ways. Database engines provide the power that is necessary for this data manipulation, but the efficiency depends on a good database design.
For this assignment, you will continue your work on the Software Design Document with a database design for the application. The database design starts with entity–relationship (ER) diagrams, and these models are used to create the database schema.
Note:It is suggested to use Visio for the diagrams that are necessary for this assignment. After a diagram is created, it can be selected, and then copied and pasted into your Software Design Document. A database engine, such as MS SQL Management Tool, may be used for construction of database schema diagrams, but these should also be pasted into the Software Design Document.
The project deliverables for Week 3 are as follows:
- Update the Software Design Document title page with the new date
Data Storage Design
- Entity–relationship diagrams
- Provide the necessary entity–relationship diagrams to model the data storage needs for the application.
- Describe the diagrams that you have created, and discuss how they provide a comprehensive model for the data storage requirements.
- Database schema
- Using the data model that was created in the first part of this assignment, construct a database schema that will efficiently support the data storage model.
- Discuss the steps that are necessary to normalize the database, and complete first- and second-form normalization if necessary.