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

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

View Full Document Right Arrow Icon
S307 Spring – 2010 1 Design Modeling Data in Organizations II S307: Data Management Vijay Khatri January 26, 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 of the course 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 What are these? [2] SUPPLIER s# sname EMPLOYEE emp# ename first middle last
Background image of page 5

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

View Full DocumentRight Arrow Icon
6 What are these? [3] EMPLOYEE emp# phone supplies SUPPLIER PART qty totqty totqty
Background image of page 6
S307 Spring – 2010 7 Design What degree are these relationships?
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 What is this?
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 02/02/2010 for the course BUS-S 307 taught by Professor Vijay during the Spring '10 term at Indiana.

Page1 / 22

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

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