Introduction to Data Modelling - Assignment

Added on - Feb 2021

Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 3 of 6 pages
Infosys - datamodelling
Table of ContentsINTRODUCTION...........................................................................................................................1Overview of case.........................................................................................................................1Some assumptions have been made:...........................................................................................2Conclusion.......................................................................................................................................3References........................................................................................................................................3
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
Desklib Logo
You are reading a preview
Upload your documents to download or

Become a Desklib member to get access