L20 - Methodology

L20 - Methodology - Yeh-Roussopoulos Methodology Goal:...

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

View Full Document Right Arrow Icon
Yeh-Roussopoulos Methodology •G o a l : Given an English description of an enterprise, build a system to automate it and document the system Methodology is modular, with four phases: 1) Environment & requirements Analysis 2) System Analysis and Specification 3) Conceptual Data Modeling 4) Logical Access Schema Derivation
Background image of page 1

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

View Full DocumentRight Arrow Icon
Step 1: Environment and Requirements Analysis • Objectives: – Understand the state of the enterprise and collect the information needed by later steps, including: • information flow requirements (needed later by conceptual modeling) • data processing requirements (needed later by access path specification)
Background image of page 2
• Step 2: System Analysis and Specification – Objective: • Identify applications that will use the database • Output is a set of tasks and data requirements • Step 3: Conceptual Data Modeling – Translate to a conceptual data model (such as the ER model) • Step 4: Logical Access Schema Derivation – Map to the DBMS’s data model – Generate access methods for tasks – Implement the product
Background image of page 3

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

View Full DocumentRight Arrow Icon
Environment Analysis System Analysis & Specification Conceptual Modeling Logical Schema Design Top Level Information Flow Application Area List Task Flow Diagram Data Usage Matrices Task Specifications Document List Conceptual Model Database Schema
Background image of page 4
Phase 1
Background image of page 5

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

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

Page1 / 17

L20 - Methodology - Yeh-Roussopoulos Methodology Goal:...

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

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