C3n - qCHAPTER q DATABASES AND DATA WAREHOUSES Click to...

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

View Full Document Right Arrow Icon
Click to edit Master subtitle style CHAPTER 3 DATABASES AND DATA WAREHOUSES MIS 140 DePaul University Randall Arakawa
Background image of page 1

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

View Full DocumentRight Arrow Icon
Physical Structure Logical Structure CHARACTER - smallest. FIELD - group of related characters. RECORD - group of related fields. FILE - group of related records. DATABASE - group of logically associated files. DATA WAREHOUSE - information from many databases. The Structure of Information
Background image of page 2
BUILDING DATABASES M o d el I m pl e m e nt U s e
Background image of page 3

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

View Full DocumentRight Arrow Icon
RECORD - group of related fields. Row Instance FILE - group of related records. Table Relation Entity Class DATABASE TERMINOLOGY
Background image of page 4
DATABASE Two parts: 1. the information 2. the logical structure of the information Information organized and accessed according to a logical structure.
Background image of page 5

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

View Full DocumentRight Arrow Icon
Logical Ties Among the Information PRIMARY KEY field in a database file that uniquely describes each record. FOREIGN KEY a primary key of one file that also appears in another file.
Background image of page 6
DBMS D B M S E n g I n e D a t a d e f i n it i o n D a t a m a n i p u l A p p li c a ti D a t a Database (Information & Data Dictionary) DBMS Subsystems
Background image of page 7

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

View Full DocumentRight Arrow Icon
DBMS Engine Accepts logical requests from the DBMS subsystems Converts them to their physical equivalent Accesses the database and data dictionary.
Background image of page 8
Data Definition Subsystem Defines the logical structure. Update new fields, delete fields, or change field properties. helps you create and maintain the Data Dictionary .
Background image of page 9

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

View Full DocumentRight Arrow Icon
Data Manipulation Subsystem The primary user interface. DBMSs Add, change, and delete information in a database and mine it. 4-17
Background image of page 10
Data Manipulation Tools VIEW - lets you to see the contents of a database file, make changes, perform simple sorting, and queries. REPORT GENERATOR - formats reports DBMSs 4-18
Background image of page 11

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

View Full DocumentRight Arrow Icon
Data Manipulation Tools QUERY-BY-EXAMPLE (QBE) TOOL - helps you graphically design the answer to a question.
Background image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/31/2011 for the course MIS 140 taught by Professor Henderson during the Spring '11 term at DePaul.

Page1 / 47

C3n - qCHAPTER q DATABASES AND DATA WAREHOUSES Click to...

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

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