Chapter4_Addendum

Chapter4_Addendum - 2/23/11 07:38:57 AM Data Modeling ERD...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2/23/11 07:38:57 AM Data Modeling ERD Overview 2/23/11 07:38:57 AM 11 Click to edit Master subtitle style 2/23/11 07:38:57 AM Representing enterprise economic reality with symbol- based (semantic) 2/23/11 07:38:57 AM 22 2/23/11 07:38:58 AM green red blue yellow purple Reality Symbol (type) COLOR Symbol (instance) 2/23/11 07:38:58 AM 33 Click to edit Master subtitle style 2/23/11 07:38:58 AM Peter Townsend Chuck Berry Garth Brooks Dolly Parton Mick Jagger John Lee Hooker Tina Turner 2/23/11 07:38:58 AM 44 2/23/11 07:38:58 AM NAME Peter Townsend Chuck Berry Garth Brooks Dolly Parton Mick Jagger J. L. Hooker Tina Turner SINGERS SINGERS Entity or represented object table representation 2/23/11 07:38:58 AM 55 2/23/11 07:38:58 AM NAME Peter Townsend Chuck Berry Garth Brooks Dolly Parton Mick Jagger J. L. Hooker Tina Turner SINGERS NAME DATE Johnny B. Goode 1958 Carol 1958 Roll Over Beethoven 1956 Rock and Roll Music 1957 Sweet Little Sixteen 1958 No Particular Place To Go 1964 You Never Can Tell 1964 School Days 1958 Maybelline 1958 Carol 1964 SONGS 2/23/11 07:38:58 AM 66 2/23/11 07:38:58 AM Singers Songs perform A Simple Model: Boxes = Entities Links = connections between Entities 2/23/11 07:38:58 AM 77 2/23/11 07:38:58 AM hous ed i n museu m do ne b y Paintin gs Arti st Na me Addr ess Na me Y ea r Market- Value Na me National ity D.O. B. attributes (o,n) (1,1) (o,n) (0,1) cardinaliti es cardinaliti es cardinaliti es 2/23/11 07:38:58 AM 88 2/23/11 07:38:58 AM REA Business Models Patterns Wedding Business Process Commitment & Type extensions Script Romance 2/23/11 07:38:58 AM 99 2/23/11 07:38:58 AM Irish Wedding pattern 2/23/11 07:38:58 AM 1010 2/23/11 07:38:59 AM Pattern = a stereotypical constellation of concepts Priest Church Rings Music Bride Wedding Groom drunk en relativ e old flame 2/23/11 07:38:59 AM 1111 2/23/11 07:38:59 AM College 2/23/11 07:38:59 AM 1212 2/23/11 07:39:01 AM Pattern = Stereotypical College Entities College Pattern Dorms Academic Building Course Offering Students Professors 2/23/11 07:39:01 AM 1313 2/23/11 07:39:01 AM 1. ENTITY : Entities are named objects in the universe of discourse Types of entities Thing (truck, building) Person (customer, employee) Event Instant duration (sale, purchase, cash receipt) Extended duration (month-long use of a truck, a course offering that starts on AUG 31 & ends on 16 DEC) Concept (category of customer, course) Customer Course offering 2/23/11 07:39:01 AM 1414 2/23/11...
View Full Document

This note was uploaded on 02/21/2011 for the course ACG 4401 taught by Professor Lynch during the Fall '10 term at FIU.

Page1 / 51

Chapter4_Addendum - 2/23/11 07:38:57 AM Data Modeling ERD...

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

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