day4+on+1+page

day4+on+1+page - S307: Data Management Modeling Data in...

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

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

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

View Full DocumentRight Arrow Icon
Database Environment Data Management ntroduction Database Environment Introduction Design Definitions: Data Vs. Information, Metadata Database System Conceptual Database Hardware DBMS People Logical Physical Implementation Phases of Database Design Database vs. File System S307 Spring – 2010 2 Introduction Evolution of Database System
Background image of page 2
Database Development Process p Data Management ntroduction Database Development Process Introduction Design Information Systems Architecture Conceptual SDLC and Database Development Process Logical Physical Implementation ANSI/SPARC Model: Three Schema Architecture S307 Spring – 2010 3 Introduction What? Physical and Logical Data Independence
Background image of page 3

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

View Full DocumentRight Arrow Icon
hapter 2 Chapter 2 • What is ISA? What are the components of ISA? • What is SDLC/DDLC? • What is logical data independence? What is physical data independence? S307 Spring – 2010 4 Introduction
Background image of page 4
Three Schema Architecture: Example l EMPLOYEE_EXTERNAL_1 EMP_NO CHAR(6) DEPARTMENT CHAR(4) EMPLOYEE_EXTERNAL_2 EMPNO PIC X (6) ENAME PIC X(4) Externa EMPLOYEE EMPLOYEE_NO CHARACTER(6) eptual DEPARTMENT CHARACTER(4) EMP_NAME CHARACTER(20) Conc e EMPLOYEE_INTERNAL BYTES=30 EMP# TYPE=BYTE(6), OFFSET=0, INDEX=EMPX DEPT# TYPE=BYTE(4), OFFSET=6 ENAME TYPE=BYTE(20), OFFSET=10 Internal S307 Spring – 2010 5 Introduction
Background image of page 5

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

View Full DocumentRight Arrow Icon
ANSI/ SPARC: Three Schema Architecture User View User View User View External Level (External View) (External View) (External View) External/Conceptual Mapping Data Conceptual Schema Conceptual Level Conceptual/ Internal i Descriptions of D DBMS Internal Schema Internal Level Mapping ata Quiz I: review chapters 1 and 2 S307 Spring – 2010 6 Introduction Stored Database
Background image of page 6
Modeling Data in the Organization gg Data Management ntroduction ntity Type Modeling Data in the Organization Introduction Design Entity Type what? strong vs. weak ttribute Conceptual Attribute what? simple vs. composite single vs. multi-valued tored vs. derived Logical Physical Implementation stored vs. derived identifier Relationship Type egree S307 Spring – 2010 7 Introduction degree cardinality a ssociative entity
Background image of page 7

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

View Full DocumentRight Arrow Icon
Overview Requirements Analysis Requirements Specification onceptual Design Conceptual Schema
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 / 33

day4+on+1+page - S307: Data Management Modeling Data in...

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