Chapter 1: Introduction to Database Processing
Short Description
Download Chapter 1: Introduction to Database Processing...
Description
Database Database Processing Processing
Chapter 1 Introduction to Database Processing
David M. Kroenke © 2000 Prentice Hall
Chapter 1
Database Example 1 Mary Richards Housepainting – – – –
Self Employed Entrepreneur Single User Database 3 Tables (Customers, Jobs, Source) Data Needs: • • • •
Page 4
Track how customers, jobs, and referrals relate Record bid estimates Track referral sources Produce mailing labels © 2000 Prentice Hall
SOURCE
CUSTOMER
JOB
Page 4 Tables of Data for Mary Richards Housepainting, Figure 1-1 © 2000 Prentice Hall
Chapter 1
Database Example 2 Treble Clef Music – Multi-User database on LAN – 3 Tables (Customers, Instruments, Rentals) – Data Needs: • Track instrument rentals • Handle multi-user issues
Page 6
© 2000 Prentice Hall
Page 7
Customer Form, Figure 1-5a © 2000 Prentice Hall
Page 7
Rental Agreement Form, Figure 1-5b © 2000 Prentice Hall
Page 8
Instrument Form, Figure 1-5c © 2000 Prentice Hall
Chapter 1
Database Example 3 State Licensing & Vehicle Registration – 52 Centers, 37 Offices, Hundreds of Users – 40 Tables – Data Needs: • Track drivers licensing issues – traffic violations, accidents, arrests, limitations
• Track auto registration issues – revenue, law enforcement
• Integrate the needs of many departments
Page 6
© 2000 Prentice Hall
Chapter 1
Database Example 4 Calvert Island Reservations Centre – – – –
Chamber of Commerce Promotional database provides access to data Customer and reservation database processes Data Needs: • Store multimedia data (photos, video clips, sound clips) • Must be Web / browser accessible • Uses Web technologies including HTTP, DHTML, and XML
Page 8
© 2000 Prentice Hall
Chapter 1
Comparison of Database Examples
Page 10
Figure 1-8
© 2000 Prentice Hall
DBMS Relationships
Chapter 1
Page 11
Figure 1-9
© 2000 Prentice Hall
Chapter 1
File-Processing Systems
Page 12
Figure 1-10
© 2000 Prentice Hall
Chapter 1
Problems with FileProcessing Systems • • • • •
Data are separated and isolated Data are often duplicated Application program dependent Incompatible data files Difficult to understand
Page 12
© 2000 Prentice Hall
Chapter 1
File-Processing Systems Create problems with data integrity because data is:
duplicated duplicated duplicated duplicated Page 12
© 2000 Prentice Hall
Chapter 1
Benefits of DBMS • • • •
Data is integrated Data duplication is reduced Data is program independent Data is easy to understand
Page 13
© 2000 Prentice Hall
Chapter 1
Database “a self-describing collection of
integrated records”
Page 14
© 2000 Prentice Hall
Chapter 1
Data Dictionary “a description of the structure of the database; data directory; metadata”
Page 15
© 2000 Prentice Hall
Chapter 1
Hierarchy of Data Elements
Figure Page 161-11 (a) File Processing (b) Database Systems © 2000 Prentice Hall
Chapter 1
Transactions “representations of events” – – – – Page 16
making a sale receiving a payment authorizing a new hire accepting a shipment
© 2000 Prentice Hall
Chapter 1
Early Relational Model • 1970, E.F. Codd • Normalization Process • Compute Intensive
Page 17
© 2000 Prentice Hall
Chapter 1
Microcomputer DBMS • Ashton - Tate: dBase II, now Borland • Oracle, Focus, Ingress ported down • Paradox, Revelation, MDBS, Helix, Foxpro, Access built specifically for microcomputers Page 19
© 2000 Prentice Hall
Chapter 1
Current Database Trends • • • •
Client-Server Applications Integration of Internet Technology Distributed Processing Object-Oriented DBMS
Page 19
© 2000 Prentice Hall
View more...
Comments