slide1
Download
Skip this Video
Download Presentation
Objectives Overview

Loading in 2 Seconds...

play fullscreen
1 / 32

Objectives Overview - PowerPoint PPT Presentation


  • 49 Views
  • Uploaded on

Objectives Overview. See Page 351 for Detailed Objectives. Objectives Overview. See Page 351 for Detailed Objectives. Databases, Data, and Information. Page 352. Databases, Data, and Information. Pages 352 – 353 Figure 9-1. Databases, Data, and Information.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Objectives Overview' - frayne


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
objectives overview
Objectives Overview

See Page 351

for Detailed Objectives

Discovering Computers Fundamentals, 2011 Edition Chapter 9

objectives overview1
Objectives Overview

See Page 351

for Detailed Objectives

Discovering Computers Fundamentals, 2011 Edition Chapter 9

databases data and information
Databases, Data, and Information

Page 352

Discovering Computers Fundamentals, 2011 Edition Chapter 9

databases data and information1
Databases, Data, and Information

Pages 352 – 353

Figure 9-1

Discovering Computers Fundamentals, 2011 Edition Chapter 9

databases data and information2
Databases, Data, and Information
  • Database software,often called a database management system(DBMS), allows users to:

Page 352

Discovering Computers Fundamentals, 2011 Edition Chapter 9

databases data and information3
Databases, Data, and Information
  • Data integrity identifies the quality of the data
  • Garbage in, garbage out (GIGO) points out the accuracy of a computer’s output depends on the accuracy of the input

Page 353

Discovering Computers Fundamentals, 2011 Edition Chapter 9

databases data and information4
Databases, Data, and Information
  • Valuable information should have the following characteristics:

Page 354

Discovering Computers Fundamentals, 2011 Edition Chapter 9

the hierarchy of data
The Hierarchy of Data
  • Data is organized in layers
    • Files, records, fields, characters

Page 355

Figure 9-2

Discovering Computers Fundamentals, 2011 Edition Chapter 9

the hierarchy of data1
The Hierarchy of Data
  • A character is one byte
    • Numbers, letters, space, punctuation marks, or other symbols
  • A field is a combination of one or more related characters
    • Field name
    • Field size
    • Data type

Pages 355 – 356

Figure 9-3

Discovering Computers Fundamentals, 2011 Edition Chapter 9

the hierarchy of data2
The Hierarchy of Data
  • Common data types include:

Page 356

Discovering Computers Fundamentals, 2011 Edition Chapter 9

the hierarchy of data3
The Hierarchy of Data
  • A record is a group of related fields
    • A primary keyuniquely identifies each record
  • A data fileis a collection of related records

Page 356

Figure 9-4

Discovering Computers Fundamentals, 2011 Edition Chapter 9

maintaining data
Maintaining Data
  • File maintenancerefers to the procedures that keep data current

Pages 357 - 358

Discovering Computers Fundamentals, 2011 Edition Chapter 9

maintaining data1
Maintaining Data
  • Users add new records to a file when they obtain new data

Page 357

Figure 9-5

Discovering Computers Fundamentals, 2011 Edition Chapter 9

maintaining data2
Maintaining Data
  • Users modify a record to correct inaccurate data or update old data

Pages 357 - 358

Figure 9-6

Discovering Computers Fundamentals, 2011 Edition Chapter 9

maintaining data3
Maintaining Data
  • When a record no longer is needed, a user deletes it from a file

Pages 358 - 359

Figure 9-7

Discovering Computers Fundamentals, 2011 Edition Chapter 9

maintaining data4
Maintaining Data
  • Validation compares data with a set of rules or values to find out if the data is correct

Click to view Web Link,click Chapter 9, Click Web Link from left navigation,

then click Data Validationbelow Chapter 9

Pages 359 - 360

Discovering Computers Fundamentals, 2011 Edition Chapter 9

file processing versus databases
File Processing Versus Databases

Pages 361 - 362

Discovering Computers Fundamentals, 2011 Edition Chapter 9

file processing versus databases1
File Processing Versus Databases

Page 362

Figure 9-10

Discovering Computers Fundamentals, 2011 Edition Chapter 9

database management systems
Database Management Systems

Click to view Web Link,click Chapter 9, Click Web Link from left navigation,

then click MySQLbelow Chapter 9

Page 363

Figure 9-11

Discovering Computers Fundamentals, 2011 Edition Chapter 9

database management systems1
Database Management Systems
  • A data dictionarycontains data about each file in the database and each field in those files

Page 364

Figure 9-12

Discovering Computers Fundamentals, 2011 Edition Chapter 9

database management systems2
Database Management Systems
  • A DBMS provides several tools that allow users and programs to retrieve and maintain data in the database

Pages 364 - 366

Discovering Computers Fundamentals, 2011 Edition Chapter 9

database management systems3
Database Management Systems
  • A query languageconsists of simple, English-like statements that allow users to specify the data to display, print, or store
  • Query by example(QBE) provides a GUI to assist users with retrieving data

Pages 364 - 366

Discovering Computers Fundamentals, 2011 Edition Chapter 9

database management systems4
Database Management Systems

Page 365

Figure 9-13

Discovering Computers Fundamentals, 2011 Edition Chapter 9

database management systems5
Database Management Systems

Click to view Web Link,click Chapter 9, Click Web Link from left navigation,

then click Data Securitybelow Chapter 9

Page 367

Discovering Computers Fundamentals, 2011 Edition Chapter 9

database management systems6
Database Management Systems
  • A DMBS provides a variety of techniques to restore the database to a usable form in case it is damaged or destroyed

Click to view Web Link,click Chapter 9, Click Web Link from left navigation,

then click Continuous Backup below Chapter 9

Page 367

Discovering Computers Fundamentals, 2011 Edition Chapter 9

relational object oriented and multidimensional databases
Relational, Object-Oriented, and Multidimensional Databases
  • Structured Query Language(SQL) is a query language that allows users to manage, update, and retrieve data

Page 369

Figure 9-18

Discovering Computers Fundamentals, 2011 Edition Chapter 9

relational object oriented and multidimensional databases1
Relational, Object-Oriented, and Multidimensional Databases
  • An object-oriented database (OODB) stores data in objects
  • Object-oriented databases often use Object Query Language (OQL) to manipulate and retrieve data

Click to view Web Link,click Chapter 9, Click Web Link from left navigation,

then click Object-Oriented Databases below Chapter 9

Page 369

Discovering Computers Fundamentals, 2011 Edition Chapter 9

relational object oriented and multidimensional databases2
Relational, Object-Oriented, and Multidimensional Databases
  • A multidimensional databasecan store data in more than two dimensions of data
    • Can consolidate data much faster than a relational database
  • A data warehouse is a huge database that stores and manages the data required to analyze historical and current transactions

Click to view Web Link,click Chapter 9, Click Web Link from left navigation,

then click Data Warehousesbelow Chapter 9

Page 370

Discovering Computers Fundamentals, 2011 Edition Chapter 9

web databases
Web Databases
  • Databases on the Web allow you to:

Page 370

Discovering Computers Fundamentals, 2011 Edition Chapter 9

web databases1
Web Databases

Page 371

Figure 9-19

Discovering Computers Fundamentals, 2011 Edition Chapter 9

database administration
Database Administration

Page 371

Discovering Computers Fundamentals, 2011 Edition Chapter 9