2-Data+Management

2-Data+Management - Datavs.Information

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

View Full Document Right Arrow Icon
5-1 Data vs. Information  Data  – raw facts or observations typically about physical  phenomena or business transactions Information  – data that have been converted into a  meaningful and useful context for specific end users
Background image of page 1

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

View Full DocumentRight Arrow Icon
Data and Information Data Facts Information Knowledge Wisdom -- Symbolic representation of facts -- Derived from Data (Understanding & relevance) -- The ability to use information -- The judgement call
Background image of page 2
5-3 Electric Utility Database Source: Adapted from Michael V. Mannino, Database Application Development and Design (Burr Ridge, IL: McGraw-Hill/Irwin, 2001), p. 6.
Background image of page 3

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

View Full DocumentRight Arrow Icon
5-4 Outline Data Modeling Database Data Warehouse Data Mining
Background image of page 4
5-5 Data Modeling Definition: Process where the relationships between data elements are  identified In English, what data do we need to keep track of, and how  do they relate to each other?
Background image of page 5

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

View Full DocumentRight Arrow Icon
5-6 Entity Relationship Diagram
Background image of page 6
5-7 Database How do we store data? How do we enter data? How do we retrieve data? How do we manage data? Hands-on lab session
Background image of page 7

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

View Full DocumentRight Arrow Icon
5-8 Store Data in Relational Database Definition: All data elements within the database are viewed as being  stored in the form of simple tables
Background image of page 8
Multiple Tables CID Name Phone City AccountBalance 12345 Jones 312-555-1234 Chicago $197.54 28764 Adams 602-999-2539 Phoenix $526.76 29587 Smitz 206-656-7763 Seattle $353.76 44453 Kolke
Background image of page 9

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

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

Page1 / 27

2-Data+Management - Datavs.Information

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

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