day6 - S307: Data Management Modeling Data in Organizations...

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

View Full Document Right Arrow Icon
S307 Spring – 2010 1 Design Modeling Data in Organizations III S307: Data Management Vijay Khatri January 28, 2010
Background image of page 1

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

View Full DocumentRight Arrow Icon
S307 Spring – 2010 2 Design Overview Requirements Analysis Requirements Specification Conceptual Design Conceptual Schema Logical Design Logical Schema Physical Design Physical Schema Implementation Maintenance Database Evolving Database DBMS-Specific DBMS-Independent
Background image of page 2
S307 Spring – 2010 3 Design Modeling Data in the Organization Data Management Data Management Introduction Design Conceptual Physical Implementation Entity Type what? strong vs. weak Attribute what? simple vs. composite single vs. multi-valued stored vs. derived identifier Relationship Type degree cardinality a ssociative entity Modeling Data in the Organization Logical
Background image of page 3

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

View Full DocumentRight Arrow Icon
S307 Spring – 2010 4 Design What are these? EMPLOYEE DEPENDENT has emp# ename salary dname gender
Background image of page 4
S307 Spring – 2010 5 Design Weak Entity Type STUDENT GUARDIAN has SID name STUDENT (SID , name) name has GUARDIAN (name) s1 (1, John) s2 (2, Jack) s3 (3, Becky) g1 (Harry) g2 (Jane) g3 ( Harry ) g4 (Tom)
Background image of page 5

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

View Full DocumentRight Arrow Icon
S307 Spring – 2010 6 Design Weak Entity Type [2] STUDENT GUARDIAN has SID name name has s1 (1, John) s2 (2, Jack) s3 (3, Becky) g1 (Harry) g2 (Jane) g3 (Harry) g4 (Tom) STUDENT (SID , name) GUARDIAN (name)
Background image of page 6
S307 Spring – 2010 7 Design Weak Entity Type [3] STUDENT GUARDIAN has SID name name has s2 (2, Jack) s3 (3, Becky) g3 (Harry) g4 (Tom) STUDENT (SID , name) GUARDIAN (name)
Background image of page 7

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

View Full DocumentRight Arrow Icon
S307 Spring – 2010 8 Design Weak Entity Type [4] STUDENT GUARDIAN has SID name name studied SCHOOL name STUDENT has GUARDIAN s1 (1, John) s2 (2, Jack) s3 (3, Becky) g1 (Harry) g2 (Jane) g3 (Jerry) g4 (Tom) studied SCHOOL s1 (IU) s2 (PU) s3 (ISU) s4 (ND)
Background image of page 8
S307 Spring – 2010 9 Design Weak Entity Type [5] STUDENT GUARDIAN has SID name name studied SCHOOL name STUDENT has GUARDIAN s1 (1, John) s2 (2, Jack) s3 (3, Becky) g1 (Harry) g2 (Jane) g3 (Jerry) g4 (Tom) studied SCHOOL s1 (IU) s2 (PU) s3 (ISU) s4 (ND)
Background image of page 9

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

View Full DocumentRight Arrow Icon
S307 Spring – 2010 10 Design Weak Entity Type [6] STUDENT GUARDIAN has SID name name studied SCHOOL name STUDENT has GUARDIAN s2 (2, Jack) s3 (3, Becky) g3 (Jerry) g4 (Tom) studied SCHOOL s1 (IU) s2 (PU) s3 (ISU) s4 (ND)
Background image of page 10
S307 Spring – 2010 11 Design Multi-valued attribute weak entity type STUDENT GUARDIAN has SID name name studied SCHOOL name
Background image of page 11

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

View Full DocumentRight Arrow Icon
S307 Spring – 2010 12 Design What are these?
Background image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 47

day6 - S307: Data Management Modeling Data in Organizations...

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

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