Transcript Databases

Databases
MGMT 661 - Summer 2012
Night #4, Lecture Part 1
Based on textbook Chapter 6
Why study databases?

databases are the central
component of TPS, CRM, etc.

Data organization impacts
information quality.
Old Style Data Management
Application
Software
Application
Software
Data
File
Data
File
Many "legacy systems"
still work this way.
Data
File
Data
File
Data
File
Terms to Know:
• Field / Attribute
• Record
• Field Type
textbook Figure 6-1
Problems with File-based Systems
Data Redundancy
 Data Inconsistency

◦ different values in different files
◦ different names for attributes
◦ different attributes types for the same attribute

Program-data Dependence

Lack of Data Sharing
◦ zip codes
◦ Y2K
textbook p 211-212
Database Management System
Application
Application
Application
Application
Database

The DBMS uncouples programs and data

Relational Database
◦ data organized as 2D "Tables", not text Files

Example DBMS
◦ Big Systems
 Oracle Database
 Microsoft SQL Server
◦ Small Systems
 MySQL
◦ Single Computer
 Microsoft Access
Database Design
Terms to Know
 Table
 Record
◦ info about an entity
(eg a supplier)
textbook Figure 6-4

Primary Key

Foreign Key

Data Dictionary
◦ must be unique
◦ used to link to
another table
◦ what is this field
◦ read/write permissions
Database Design
Database Design
monitors
security
system
enables/disables
tests
sensor
programs
is programmed by
monitors
security
system
enables/disables
tests
programs
is programmed by
sensor
SQL - Structured Query Language

Which suppliers are in Ohio?
SELECT Supplier_Name from Supplier
WHERE Supplier_State = "OH";
Web-Based Databases
textbook Figure 6-16
Misc Database Terms

Distributed Databases

Data Warehouse

Online Analytical Processing (OLAP)

Data Mining
◦ web mining
◦ text mining

Data Scrubbing
Homework

Design the tables for a small pizza
delivery shop.
 Design?



number of tables?
fields in each table?
primary keys?
 Uses for this information?