8. Chapter. Personal Technology. 8.1 Managing Files: Basic Concepts 8.2 Database Management Systems 8.3 Database Models 8.4 Data Mining 8.5 Databases & The Digital Economy 8.6 Using Databases to Help Make Decisions 8.7 Artificial Intelligence 8.8 The Ethics of Using Databases.
8.1 Managing Files: Basic Concepts
8.2 Database Management Systems
8.3 Database Models
8.4 Data Mining
8.5 Databases & The Digital Economy
8.6 Using Databases to Help Make Decisions
8.7 Artificial Intelligence
8.8 The Ethics of Using Databases
© 2007 The McGraw-Hill Companies, Inc. All rights reserved.
character made of bits
This example shows a sample database in Microsoft Access. Products is a table. ProductID is the primary key of the Product table. ProductID is also a foreign key in the Orders table
Discussion Question: Did you know that 93% of companies that lost their data center for 10 days or more due to a disaster filed for bankruptcy within a year?
Fields or records are arranged in a family tree, with child records subordinate to parent or higher-level records
Like a hierarchical database, but each child record can have more than one parent record
Relates, or connects, data in different files through the use of a key, or common data element
Uses objects (software written in small, reusable chunks) as elements within database files
Models data as facts, dimensions, or numerical measures for use in the interactive analysis of large amounts of dataDatabase Models
Has anyone seen the movie “Office Space”? In that movie, the hero’s boss is nagging him about formatting the TPS report correctly. Now you know what TPS means!
Discussion Question: Has any one had their identity stolen? How long did it take you to get it straightened out?