Chap 9 - Systems Analysis and Design 8th Edition Chapter 9...

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

View Full Document Right Arrow Icon
Systems Analysis and Design 8th Edition Chapter 9 Data 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
Chapter Objectives Explain data design concepts and structures Describe file processing systems Explain database systems and define the components of a database management system (DBMS) Describe Web-based data design 2
Background image of page 2
Chapter Objectives Explain data design terminology, including entities, fields, common fields, records, files, tables, and key fields Describe data relationships, draw an entity relationship diagram, define cardinality, and use cardinality notation Explain the concept of normalization Explain the importance of codes and describe various coding schemes 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
Chapter Objectives Describe relational and object-oriented database models Explain data warehousing and data mining Differentiate between logical and physical storage and records Explain data control measures 4
Background image of page 4
Introduction You will develop a physical plan for data organization, storage, and retrieval Begins with a review of data design concepts and terminology, then discusses file-based systems and database systems, including Web-based databases Concludes with a discussion of data storage and access, including strategic tools such as data warehousing and data mining, physical design issues, logical and 5
Background image of page 5

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

View Full DocumentRight Arrow Icon
Data Design Concepts Data Structures Each file or table contains data about people, places, things or events that interact with the information system File-oriented system File processing 6
Background image of page 6
Data Design Concepts Overview of File Processing File processing can be efficient and cost-effective in certain situations Potential problems Data redundancy Data integrity Rigid data structure 7
Background image of page 7

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

View Full DocumentRight Arrow Icon
Data Design Concepts Overview of File Processing Various types of files Master file Table file Transaction file Work file Security file History file 8
Background image of page 8
Data Design Concepts The Evolution from File Systems to Database Systems A database management system (DBMS) is a collection of tools, features, and interfaces that enables users to add, update, 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
Data Design Concepts The Evolution from File Systems to Database Systems Some Advantages Scalability Economy of scale Enterprise-wide application – database administrator (DBA) Controlled redundancy Data independence 10
Background image of page 10
DBMS Components Interfaces for Users, Database Administrators, and Related Systems Users Query language Query by example (QBE) SQL (structured query language) Database 11
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.

This note was uploaded on 01/30/2012 for the course CNIT 180 taught by Professor Victorbarlow during the Spring '12 term at Purdue University-West Lafayette.

Page1 / 45

Chap 9 - Systems Analysis and Design 8th Edition Chapter 9...

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