logo

Introduction to Data Modelling - Assignment

6 Pages1270 Words284 Views
   

Added on  2021-02-21

Introduction to Data Modelling - Assignment

   Added on 2021-02-21

ShareRelated Documents
Infosys - datamodelling
Introduction to Data Modelling - Assignment_1
Table of ContentsINTRODUCTION...........................................................................................................................1Overview of case.........................................................................................................................1Some assumptions have been made:...........................................................................................2Conclusion.......................................................................................................................................3References........................................................................................................................................3
Introduction to Data Modelling - Assignment_2
INTRODUCTIONThe process of creation of data model for storing data within database is referred to asdata modelling. In this data is formulated within well-configured as well as specified form whichpresents data objects as well as associations with different data objects (Al-Masree, 2015).Through this data can be analysed in an effectual manner which further assists withinacknowledgement of requirements of business. Entity relationship diagram is defined as a datamodelling technique which is used for graphical illustration of entities of information systemsalong with relationship among those entities. This assignment is based on Auckland CityHospital that is present within suburb of Grafton. On the annual basis they have near about80,000 patients.Overview of caseEntity relationship diagram comprises of diverse connectors as well as symbols that areliable for visualisation of crucial information. There exists four groups of people, they includesphysician, employees, volunteer and patients. Each have their own set of attributes and sharerelationship among each other. They been specified below:Patient: They can be either resident or outpatient depending on their requirements. Eachpatient have their own unique_id which differentiates them from others present within thehospital. This is often known as primary key. The special relational database table that is beingused for uniquely identifying all table records present within entity, it is known as primary key. Itcomprises of unique value for data with row as well as do not have null values. Along with this,other attributes are name, address, sex, age, contact number, date when they were admitted anddate related with their discharge. Contact number is within double dotted oval shape, the reasonfor this is that patient can have multiple number through which contact can be made with them. Employee: They lies within three categories which includes doctor and nurse. Againeach have different set of attributes which makes them different from other. Each employee havetheir own id, type, name, email address, date of birth (dob), salary as well as address whichmakes them different from others. Attributes of each employee has been illustrated below:Doctor or physician: Each patient has unique physician assigned to them who is liablefor treating them in an appropriate manner. They have their unique id, qualification as well as
Introduction to Data Modelling - Assignment_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Data Modelling: Entity Relationship Diagram for Auckland City Hospital
|6
|1172
|45

Development and Implementation Assignment
|12
|1025
|201

Enterprise Rules - Hospital Management System
|22
|1437
|45

Database Design and Development
|6
|968
|378

Science of Data Modelling and Database Design
|3
|593
|22

Information System for Healthcare: Applications, Tools, Challenges, and Developed System Modules
|14
|866
|201