Data Management

Data Management - Prof. Mike Zack MIS301 Data Management...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: Prof. Mike Zack MIS301 Data Management Prof. Mike Zack MIS301 Traditional File Processing Example Customer transactions Checking account application Savings account application Installment loan application Customers Customers Customers Checking trx Savings trx Loan trx Statements & reports Statements & reports Statements & reports Prof. Mike Zack MIS301 Each file owned by one or a few application programs No other program can use these files Problems: Data redundancy Data inconsistency No standard data coding schemes Data format and use depends on the application Cant integrate data to use for analysis File Processing: Problems? Data Management Vocabulary Database Data element (a.k.a. data field) Record Field Data table Data types and data attributes Primary key Foreign key (a.k.a. secondary key) Database Components Field Record Primary key Prof. Mike Zack MIS301 Data Organization Structure Database File/Table or Entity Record or Instance Field or Attribute Character Prof. Mike ZackProf....
View Full Document

This note was uploaded on 02/25/2012 for the course MISM 1201 taught by Professor M during the Spring '12 term at Northeastern.

Page1 / 16

Data Management - Prof. Mike Zack MIS301 Data Management...

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

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