...The Characteristics of Databases • The purpose of a database is to help people track things of interest to them. • Data is stored in tables, which have rows and columns like a spreadsheet. A database may have multiple tables, where each table stores data about a different thing. • Each row in a table stores data about an occurrence or instance of the thing of interest. • A database stores data and relationships. KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall 1-1 Data in Tables KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall 1-2 The Key Characteristic of Databases: Related Tables KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall 1-3 Database Applications KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall 1-4 Database Applications—Forms KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall 1-5 Database Applications—Queries SELECT FROM WHERE LastName, FirstName, EmailAddress STUDENT StudentNumber > 2; KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall 1-6 Database—Reports KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall 1-7 The DBMS KROENKE AND AUER - DATABASE PROCESSING, 12th Edition © 2012 Pearson Prentice Hall 1-8 The Database • A database is a self-describing collection of integrated...
Words: 570 - Pages: 3