ISOM221+Lecture+8+-+Data+Modeling+I

ISOM221+Lecture+8+-+Data+Modeling+I - ISOM221 Information...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
ISOM221 Information Systems Analysis and Design Lecture 8: Data Modeling I 1 Agenda Understand the key definitions of ERD Understand ERD elements Understand the concepts of cardinality and modality 2
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Key Definitions Data model A formal way of representing the data that are used and created by a business system Shows the people, places and things about which Shows the people, places and things about which data is captured and the relationships among them Logical data model (our focus) Shows the organization of data without indicating how it is stored, created, or manipulated 3 Key Definitions Physical data model Shows how the data will actually be stored in databases or files Normalization is the process analysts use to is the process analysts use to validate data models Data models should balance with process models 4
Background image of page 2
What Is an ERD? A picture showing the information created, stored, and used by a business system Entities generally represent similar kinds of information Lines drawn between entities show relationships among the data 5 An ERD Example Entity Relationship Attributes Identifier 6
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Reading ERD DOCTOR is scheduled for APPOINTMENT, APPOINTMENT includes DOCTOR PATIENT schedules APPOINTMENT, APPOINTMENT is scheduled by PATIENT APPOINTMENT generates BILL, BILL is generated by APPOINTMENT PATIENT makes PAYMENT, PAYMENT is made by PATIENT INSURANCE COMPANY insures PATIENT, PATIENT is insured by INSURANCE COMPANY INSURANCE COMPANY makes PAYMENT, PAYMENT is made by INSURANCE COMPANY BILL is paid by PAYMENT, PAYMENT pays BILL 7 Using the ERD to Show Business Rules Business rules are constraints that are followed when the system is in operation ERD symbols can show when one instance of an entity must exist for an instance of another
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/22/2010 for the course ISOM ISOM221 taught by Professor Sheunhhee during the Spring '09 term at HKUST.

Page1 / 18

ISOM221+Lecture+8+-+Data+Modeling+I - ISOM221 Information...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online