ase: 1) A very famous example in real life about database system would be "Hospital Management system" 2) Problems in the business process without database system approach: - Redundant data : Managing so much of redundant data in a hospital would be tough without DBMS - Memory management : Without DBMS, managing the whole memory would be quite tough - Managing shared data - Managing the access control 3) Stages in Database System Development Life Cycle: - Stage 1: Area selection and problem definition : Defined the problem as "Hoepital management system" - Stage 2: Gathering data : Gathering data through various sources in the hospital - Stage 3: Creating alternatives : If any - Stage 4: Feasibility study : Studying how feasible this plan is. - Stage 5: Development plan : Planning the whole development procedure - Stage 6: Equipement evaluation - Stage 7: Design & development : Actual development - Stage 8: Testing : Final testing - Stage 9: System implementation - Stage 10: Maintainence - Stage 11: Review and follow up 4) Fact finding technique for requirement collection : In the case of hospital management, the technique used for data collection was both online and offline: - Taking manual surveys from hostpital employees - Taking online surveys and feedbacks from staff 5) In this case, Centralized approach worked as all the views were merged together in order to form a proper full fledged system. Question: Case: Hospital Management system Based on the case study at above create: Conceptual Entity Relationship Diagram Identify Entities and attributes Identify relationship and multiplicity Identify Candidate Key and Primary Key Identify Domain Constraint Logical Entity Relationship Diagram: Derive relations
Case:
1)
A very famous example in real life about
2)
Problems in the business process without database system approach:
- Redundant data : Managing so much of redundant data in a hospital would be tough without DBMS
- Memory management : Without DBMS, managing the whole memory would be quite tough
- Managing shared data
- Managing the access control
3)
Stages in Database System Development Life Cycle:
- Stage 1: Area selection and problem definition : Defined the problem as "Hoepital management system"
- Stage 2: Gathering data : Gathering data through various sources in the hospital
- Stage 3: Creating alternatives : If any
- Stage 4: Feasibility study : Studying how feasible this plan is.
- Stage 5: Development plan : Planning the whole development procedure
- Stage 6: Equipement evaluation
- Stage 7: Design & development : Actual development
- Stage 8: Testing : Final testing
- Stage 9: System implementation
- Stage 10: Maintainence
- Stage 11: Review and follow up
4)
Fact finding technique for requirement collection :
In the case of hospital management, the technique used for data collection was both online and offline:
- Taking manual surveys from hostpital employees
- Taking online surveys and feedbacks from staff
5)
In this case, Centralized approach worked as all the views were merged together in order to form a proper full fledged system.
Question:
Case: Hospital Management system
Based on the case study at above create:
Conceptual Entity Relationship Diagram
- Identify Entities and attributes
- Identify relationship and multiplicity
- Identify Candidate Key and Primary Key
- Identify Domain Constraint
Logical Entity Relationship Diagram:
- Derive relations
Step by step
Solved in 3 steps with 1 images