ch03 - Principles and Learning Objectives The database...

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

View Full Document Right Arrow Icon
Background image of page 1

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

View Full DocumentRight Arrow Icon
Fundamentals of Information Systems, Third Edition 2 Principles and Learning Objectives The database approach to data management provides significant advantages over the traditional file-based approach. Define general data management concepts and terms, highlighting the advantages of the database approach to data management. Describe the relational database model and outline its basic features.
Background image of page 2
Fundamentals of Information Systems, Third Edition 3 Principles and Learning Objectives (continued) A well-designed and well-managed database is an extremely valuable tool in supporting decision making. Identify the common functions performed by all database management systems and identify popular end-user database management systems.
Background image of page 3

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

View Full DocumentRight Arrow Icon
Fundamentals of Information Systems, Third Edition 4 Principles and Learning Objectives (continued) The number and types of database applications will continue to evolve and yield real business benefits. Identify and briefly discuss current database applications.
Background image of page 4
Fundamentals of Information Systems, Third Edition 5 Data Management: The Hierarchy of Data Bit (a binary digit): a circuit that is either on or off Byte: 8 bits Character: each byte represents a character; the basic building block of information Field: name, number, or characters that describe an aspect of a business object or activity
Background image of page 5

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

View Full DocumentRight Arrow Icon
Binary Number Story http://www.steveheller.com/cppad/Output/hardware5 Fundamentals of Information Systems, Third Edition 6
Background image of page 6
Fundamentals of Information Systems, Third Edition 7 The Hierarchy of Data (continued) Record: a collection of related data fields File: a collection of related records Database: a collection of integrated and related files Hierarchy of data Bits, characters, fields, records, files, and databases
Background image of page 7

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

View Full DocumentRight Arrow Icon
Fundamentals of Information Systems, Third Edition 8 The Hierarchy of Data (continued) Figure 3.1: The Hierarchy of Data
Background image of page 8
Fundamentals of Information Systems, Third Edition 9 Data Entities, Attributes, and Keys Entity: a generalized class of people, places, or things (objects) for which data is collected, stored, and maintained Attribute: a characteristic of an entity Data item: a value of an attribute Key: field(s) that identify a record Primary key: field(s) that uniquely identify a record
Background image of page 9

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

View Full DocumentRight Arrow Icon
Fundamentals of Information Systems, Third Edition 10 Data Entities, Attributes, and Keys (continued) Figure 3.2: Keys and Attributes
Background image of page 10
Fundamentals of Information Systems, Third Edition 11 The Traditional Approach Versus the Database Approach Traditional approach: separate data files are created for each application Results in data redundancy (duplication) Data redundancy conflicts with data integrity
Background image of page 11

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

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

This note was uploaded on 04/14/2008 for the course CIS 201 taught by Professor Mcmahon during the Spring '08 term at Bryant.

Page1 / 40

ch03 - Principles and Learning Objectives The database...

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

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