Chapter 1: Introduction to Database Processing

January 5, 2018 | Author: Anonymous | Category: Engineering & Technology, Computer Science, Databases
Share Embed Donate


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

Copyright � 2017 NANOPDF Inc.
SUPPORT NANOPDF