datamodels
DESCRIPTION
datamodelsTRANSCRIPT
Page 1
DATA MODELS
Page 2
Relationships within a data model
Entity
Attributes
Data Value
Key Attributes
Record
Page 3
EntityPerson,place,thing,event or concept about which the information is recorded
AttributesAttributes characterise the entity or describe the entity meaningfully.
Data Value Each attribute of an entity has a value and is called as data value
Page 4
Key AttributesThe key attributes are used to find the values of other attributes
RecordRecord is the collection of the attributes of an entity
Page 5
Relation types
ONE- TO- ONE
ONE – TO- MANY
MANY - TO- MANY
Page 6
Symbols used in E-R Diagram
ENTITY
RELATION
ONE RELATION
MANY RELATION
Page 7
patient bed
occupies
assigned
ONE-TO-ONE
ONE TO ONE RELATION
Page 8
PATIENTHOSPITAL
ROOM
ACCOMADATES
ONE-T0-MANY
ONE-TO-MANY RELATION
Page 9
THANK YOU