w6_1_Data%20Management_chp6

w6_1_Data%20Management_chp6 - Click to edit Master subtitle...

Info iconThis preview shows pages 1–9. 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: Click to edit Master subtitle style I E 332: Computing in I E 2/15/2010 Ji Soo Yi [email protected] Data Management Announcements Manage your absences. Today is for students who haven’t have chances t o par ticipat e so far. Problems with the Data redundancy and inconsistency ◦ Data redundancy: Presence of duplicate data in multiple files ◦ Data inconsist ency: Same attr ibut e has different values Program-data dependence: ◦ When changes in program requires changes to data accessed by program Traditional File Processing Database vs. DBMS Database ◦ Collection of data organized t o ser ve many applications by centralizing data and controlling redundant data Database management syst em ◦ I nt er faces between application programs and physical data files ◦ Separates logical and physical views of e.g., HR Database Relational DBMS Relational DBMS ◦ Represent data as two-dimensional tables called relations or files ◦ Each table contains data on entity and attr ibutes Table: gr id of columns and rows ◦ Rows (tuples, records): Records for different entities Relational Database Table Relational Database Table...
View Full Document

This document was uploaded on 09/19/2010.

Page1 / 35

w6_1_Data%20Management_chp6 - Click to edit Master subtitle...

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

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