Computer Confluence 6/eSlide 2Computer Confluence 6/e Chapter 7 ObjectivesComputer Confluence 6/e Chapter 7 Objectives (continued)Computer Confluence 6/e Chapter 7 Bill Gates Rides the Digital WaveSlide 6Computer Confluence 6/e Chapter 7 The Electronic File Cabinet: Database BasicsSlide 8Slide 9Slide 10Slide 11Slide 12Slide 13Slide 14Slide 15Slide 16Slide 17Slide 18Slide 19Slide 20Computer Confluence 6/e Chapter 7 Beyond the Basics: Database Management SystemsSlide 23Slide 24Slide 25Slide 26Slide 27Slide 28Slide 29Slide 30Slide 31Slide 32Slide 33Slide 34Slide 35Slide 36Computer Confluence 6/e Chapter 7 No Secrets: Computers and PrivacySlide 38Slide 39Slide 40Slide 41Computer Confluence 6/e Chapter 7 Lesson SummaryComputer Confluence 6/e Chapter 7 Lesson Summary (continued)Slide 1Computer Confluence 6/e© 2005 Prentice-Hall, Inc.Slide 2Computer Confluence 6/eChapter 7Database Applications and Implications © 2005 Prentice-Hall, Inc.Slide 3Computer Confluence 6/e Chapter 7ObjectivesWhat a computer is and what it doesThe ways computers play a critical role in modern lifeThe history and development of the modern computerTrends in the evolution of modern computersThe fundamental differences between computers and other machines The relationship between hardware and software© 2005 Prentice-Hall, Inc.Slide 4Computer Confluence 6/e Chapter 7Objectives (continued)Explain what a database is and describe its basic structureIdentify the kinds of problems that can be best solved with database softwareDescribe different kinds of database software, from simple file managers to complex relational databasesDescribe database operations for storing, sorting, updating, querying, and summarizing informationExplain the ways databases threaten our privacy© 2005 Prentice-Hall, Inc.Slide 5Computer Confluence 6/e Chapter 7 Bill Gates Rides the Digital Wave Bill Gates and Paul Allen formed a company called Microsoft to produce and market Microsoft Basic, a version of the Basic programming language for microcomputers that quickly became the standard language installed in virtually every computerMicrosoft’s biggest break came when IBM went shopping for an operating system for its PC © 2005 Prentice-Hall, Inc.Slide 6Computer Confluence 6/e Chapter 7 Bill Gates Rides the Digital Wave Today Bill Gates and Microsoft dominate the PC software industry, selling operating systems, applications programs, server software, and software development tools: Internet Explorer Web browser is a central component of the Windows OS Microsoft desktop applications have links to the InternetMicrosoft has partnerships with dozens of Web-related businesses worldwide© 2005 Prentice-Hall, Inc.Slide 7Computer Confluence 6/e Chapter 7 The Electronic File Cabinet: Database BasicsWhat Good Is a Database?A database: A collection of informationstored on computer disksDatabase software: Application software(like word processing andspreadsheet software)Designed to maintain databases(collections of information)© 2005 Prentice-Hall, Inc.Slide 8Computer Confluence 6/e Chapter 7 The Electronic File Cabinet: Database BasicsAdvantages offered by computerized databases: Make it easier to store large quantities of information Make it easier to retrieve information quickly and flexibly Make it easy to organize and reorganize information Make it easy to print and distribute information in a variety of ways © 2005 Prentice-Hall, Inc.Slide 9Computer Confluence 6/e Chapter 7 The Electronic File Cabinet: Database BasicsDatabase AnatomyDatabase program: a software tool for organizing the storage and retrieval of information Database: a collection of information stored in an organized form in a computerTypically composed of one or more tables A collection of related informationA collection of records© 2005 Prentice-Hall, Inc.Slide 10Computer Confluence 6/e Chapter 7 The Electronic File Cabinet: Database BasicsA record is the information relating to one person, product, or eventEach discrete piece of information in a record is a field© 2005 Prentice-Hall, Inc.FieldRecordTableSlide 11Computer Confluence 6/e Chapter 7 The Electronic File Cabinet: Database BasicsThe type of information a field can hold is determined by its: Field type orData type Database programs provide you with more than one way to view data:Form viewsShow one record at a timeList viewsDisplay several records in lists similar to the way a spreadsheet displays data© 2005 Prentice-Hall, Inc.Slide 12Computer Confluence 6/e Chapter 7 The Electronic File Cabinet: Database BasicsIn any view, fields can be rearranged without changing the underlying data© 2005 Prentice-Hall, Inc.List ViewForm ViewSlide 13Computer Confluence 6/e Chapter 7 The Electronic File Cabinet: Database BasicsDatabase OperationsImport: receives data in the form of text filesBrowse: navigates through informationQuery: finds records that match specific criteria© 2005 Prentice-Hall, Inc.Slide 14Computer Confluence 6/e Chapter 7 The Electronic File Cabinet: Database BasicsSort: rearranges records (alphabetically or numerically)Printing reports, labels, and form letters: a report is an ordered list of selected records and fields in an easy-to-read format © 2005 Prentice-Hall, Inc.Slide 15Computer Confluence 6/e Chapter 7 The Electronic File Cabinet: Database Basics© 2005 Prentice-Hall, Inc.Most modern database management programs support a standard language for programming complex queries called SQL (Structured Query Language)Available for many database management systemsProgrammers and sophisticated users don’t need to learn new languages when they work with new systemsGraphical user interfaces allow point-and-click queriesInsulates users from the complexities of the query languageSlide 16Computer Confluence 6/e Chapter 7 The Electronic File Cabinet: Database Basics© 2005 Prentice-Hall, Inc.Screen Test: Querying a Web Search DatabaseTo search for articles online about a new method for recycling laser printer toner cartridges, you can visit a search engine such as GoogleSlide 17Computer Confluence 6/e Chapter 7 The Electronic File Cabinet: Database Basics© 2005 Prentice-Hall, Inc.When you hit the “Search” button, the search engine will return a list of links, sorted by relevancySlide 18Computer Confluence 6/e Chapter 7