ch12-Practical Database Design Methodology and Use of UML Diagrams

Ch12-Practical Database Design Methodology and Use of UML Diagrams

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

View Full Document Right Arrow Icon
Slide 12- 1 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe
Background image of page 1

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

View Full DocumentRight Arrow Icon
Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Chapter 12 Practical Database Design Methodology and Use of UML Diagrams
Background image of page 2
Slide 12- 3 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Chapter Outline Information System Life Cycle Phases of Database Design UML Diagrams Rational Rose Other tools Design Tools
Background image of page 3

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

View Full DocumentRight Arrow Icon
Slide 12- 4 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Organizational Context for using Database Systems Consolidation and integration of data across organization Maintenance of complex data Simplicity of developing new applications Data independence Protecting application programs from changes in the underlying logical organization and in the physical access paths and storage structures External Schemas Allow the same data to be used for multiple applications with each application having its own view of the data
Background image of page 4
Slide 12- 5 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Information System Information System includes all resources involved in the collection, management, use and dissemination of the information resources of the organization We consider two systems life cycles: Macro Life Cycle Information System Life Cycle Micro Life Cycle Database System Life Cycle
Background image of page 5

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

View Full DocumentRight Arrow Icon
Slide 12- 6 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Phases of Information System Life Cycle Feasibility Analysis Analyzing potential application areas Identifying the economics of information gathering and dissemination Performing cost benefit studies Setting up priorities among applications Requirement Collection and Analysis Detailed Requirements Collection Interaction with Users Design Design of Database System Design of programs that use and process the database
Background image of page 6
Slide 12- 7 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Phases of Information System Life Cycle (contd.) Implementation Information system is implemented Database is loaded & its transactions are implemented and tested Validation and Acceptance Testing Testing against user’s requirements Testing against performance criteria Deployment, Operation and Maintenance Data conversion Training System maintenance Performance monitoring Database tuning
Background image of page 7

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

View Full DocumentRight Arrow Icon
Slide 12- 8 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Database System Life Cycle System definition Defining scope of database system, its users and applications Database Design Logical and physical design of the database system on the chosen DBMS Database implementation Specifying conceptual, external and internal database definitions Creating empty database files Implementing software applications
Background image of page 8
Slide 12- 9 Copyright © 2007 Ramez Elmasri and Shamkant B. Navathe Database System Life Cycle (contd.) Loading or data conversion Populating the database
Background image of page 9

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

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

This note was uploaded on 02/23/2012 for the course CS 348 taught by Professor Staff during the Fall '08 term at Purdue University-West Lafayette.

Page1 / 43

Ch12-Practical Database Design Methodology and Use of UML Diagrams

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

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