ch10.12%20chapter07datamodeling

Ch10.12 chapter07d - Chapter 7 Chapter Data Modeling Outline Notation basics Understanding relationships Generalization hierarchies Problem solving

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

View Full Document Right Arrow Icon
Chapter 7 Chapter 7 Data Modeling
Background image of page 1

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

View Full DocumentRight Arrow Icon
Outline Outline Notation basics Understanding relationships Generalization hierarchies Problem solving strategies
Background image of page 2
Basic Symbols Basic Symbols Entity Type symbol Relationship symbol Primary Key Attributes Relationship name Entity Type name CourseNo CrsDesc CrsUnits Course OfferNo OffLocation OffTime Offering Has
Background image of page 3

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

View Full DocumentRight Arrow Icon
Cardinalities Cardinalities Course Offering Course1 Offering1 Course2 Course3 Offering2 Offering3 Offering4
Background image of page 4
Cardinality Notation Cardinality Notation Inside symbol: minimum cardinality CourseNo CrsDesc CrsUnits Course OfferNo OffLocation OffTime Offering Has Single line: one cardinality Outside symbol: maximum cardinality Circle: zero cardinality Crow's foot: many cardinality
Background image of page 5

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

View Full DocumentRight Arrow Icon
Classification of Cardinalities Classification of Cardinalities Minimum cardinality based Mandatory Optional Maximum cardinality based Functional 1-M M-N 1-1
Background image of page 6
More Relationship Examples More Relationship Examples FacSSN FacSalary FacRank FacHireDate Faculty OfferNo OffLocation OffTime Offering TeamTeaches OfficeNo OffPhone OffType Office WorksIn
Background image of page 7

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

View Full DocumentRight Arrow Icon
Comparison to Access Notation CourseNo CrsDesc CrsUnits Course OfferNo OffLocation OffTime Offering Has ERD (Crow's Foot) Course Courseno CrsDesc CrsUnits 1 8 Offering OfferNo CourseNo OffLocation OffTime ... Access Relationship Diagram
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/05/2011 for the course IST 352 taught by Professor Staff during the Fall '10 term at Syracuse.

Page1 / 27

Ch10.12 chapter07d - Chapter 7 Chapter Data Modeling Outline Notation basics Understanding relationships Generalization hierarchies Problem solving

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

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