02010_ch09

02010_ch09 - Database Systems: Design, Implementation, and...

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

View Full Document Right Arrow Icon
Database Systems: Design, Implementation, and Management Eighth Edition Chapter 9 Database Design
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 Systems, 8 th Edition 2 Objectives In this chapter, you will learn: That successful database design must reflect the information system of which the database is a part That successful information systems are developed within a framework known as the Systems Development Life Cycle (SDLC)
Background image of page 2
Database Systems, 8 th Edition 3 Objectives (continued) In this chapter, you will learn: (continued) That within the information system, the most successful databases are subject to frequent evaluation and revision within a framework known as the Database Life Cycle (DBLC) How to conduct evaluation and revision within the SDLC and DBLC frameworks About database design strategies: top-down vs. bottom-up design and centralized vs. decentralized design
Background image of page 3

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

View Full DocumentRight Arrow Icon
Database Systems, 8 th Edition 4 The Information System Provides for data collection, storage, and retrieval Composed of: People, hardware, software Database(s), application programs, procedures Systems analysis Process that establishes need for and extent of information system Systems development Process of creating information system
Background image of page 4
Database Systems, 8 th Edition 5 The Information System (continued) Applications Transform data into information that forms basis for decision making Usually produce the following: Formal report Tabulations Graphic displays Composed of following two parts: Data Code by which data are transformed into information
Background image of page 5

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

View Full DocumentRight Arrow Icon
Database Systems, 8 th Edition 6
Background image of page 6
Database Systems, 8 th Edition 7 The Information System (continued) Performance depends on three factors: Database design and implementation Application design and implementation Administrative procedures Database development Process of database design and implementation Implementation phase includes: Creating database storage structure Loading data into the database Providing for data management
Background image of page 7

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

View Full DocumentRight Arrow Icon
Database Systems, 8 th Edition 8 The Systems Development Life Cycle (SDLC) Traces history (life cycle) of information system Database design and application development mapped out and evaluated Divided into following five phases: Planning Analysis Detailed systems design Implementation Maintenance Iterative rather than sequential process
Background image of page 8
Database Systems, 8 th Edition 9
Background image of page 9

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

View Full DocumentRight Arrow Icon
Database Systems, 8 th Edition 10 Planning General overview of company and objectives Assessment of flow-and-extent requirements Should the existing system be continued? Should the existing system be modified? Should the existing system be replaced? Study and evaluate alternate solutions Technical aspects of hardware and software requirements System cost Operational cost
Background image of page 10
Database Systems, 8 th Edition 11 Analysis Problems defined during planning phase examined in greater detail during analysis
Background image of page 11

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

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

Page1 / 50

02010_ch09 - Database Systems: Design, Implementation, and...

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

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