COMP325 CH 08 - Data Design

COMP325 CH 08 - Data Design - Systems Analysis and Business...

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

View Full Document Right Arrow Icon
Systems Analysis and Business  Applications COMP325 Chapter 7 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
2 Introduction 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. Discuss data storage and access
Background image of page 2
3 Data Design Concepts Data Structures A file or table contains  data  about: People Places Things Events  …..  that interact with the system 2 major types File processing system Database system
Background image of page 3

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

View Full DocumentRight Arrow Icon
4 Data Design Concepts File Processing System
Background image of page 4
5 Data Design Concepts Overview of File Processing Potential problems  1. Data redundancy 1. Same data is stored in more than 1 file (application) 2. Data integrity (inconsistency) 1. Data duplication [from above] causes inconsistency from  one application to the next 2. “Downline” applications 3. Rigid data structure 1. Data must be retrieved from multiple sources 2. Slow and inefficient (files are not dynamic)
Background image of page 5

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

View Full DocumentRight Arrow Icon
6 Data Design Concepts File Processing Problem Summary  Statement Because of data redundancy  the  integrity  of multiple representations of a  data element is highly suspect and  therefore inconsistent
Background image of page 6
7 Data Design Concepts Overview of File Processing Potential problems  “Downline applications” - examples Financial system Sales (master) Accounting Accounts receivable Financial reporting Accounts payable Etc.
Background image of page 7

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

View Full DocumentRight Arrow Icon
8 Data Design Concepts Overview of File Processing Uses various types of files  –  refer to handout (COMP325 CH8 Files-DBMS-Design.doc) Master file Table file Transaction file Work file – scratch file Security file History file
Background image of page 8
9 Data Design Concepts Overview of Database Systems The “view” in the following slides are the  business and technology factors that an  analyst must know and consider Detailed technical aspects for a database  system are covered in the database  courses (COMP355 & COMP570)
Background image of page 9

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

View Full DocumentRight Arrow Icon
10 Data Design Concepts Overview of Database Systems A properly designed database system  offers a solution to the problems of file  processing Provides an overall framework that avoids   data redundancy  and supports a real-time,  dynamic environment The main advantage of a DBMS is that it  offers timely, interactive, and flexible data  access
Background image of page 10
11 Data Design Concepts Overview of Database Systems A DBMS can support several related  information systems that provide input to,  and require specific data from, the DBMS Enterprise financial system Accounts receivable Accounts payable Payroll Sales Marketing 
Background image of page 11

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

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

Page1 / 58

COMP325 CH 08 - Data Design - Systems Analysis and Business...

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

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