Database Processing Chapter 1 Introduction to Database Processing
Database 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 -5 a © 2000 Prentice Hall
Page 7 Rental Agreement Form, Figure 1 -5 b © 2000 Prentice Hall
Page 8 Instrument Form, Figure 1 -5 c © 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 File. Processing 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 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: d. Base 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
- Slides: 22