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

Info icon This 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
Image of page 1

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

View Full Document Right 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
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
Image of page 3

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

View Full Document Right Arrow Icon
4 Data Design Concepts File Processing System
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)
Image of page 5

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

View Full Document Right 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
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.
Image of page 7

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

View Full Document Right 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
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)
Image of page 9

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

View Full Document Right 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
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 
Image of page 11

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

View Full Document Right Arrow Icon
12 Data Design Concepts
Image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern