Objectives Overview Objectives Overview Databases, Data, in addition to In as long as mation Databases, Data, in addition to In as long as mation Databases, Data, in addition to In as long as mation

Objectives Overview Objectives Overview Databases, Data, in addition to In as long as mation Databases, Data, in addition to In as long as mation Databases, Data, in addition to In as long as mation www.phwiki.com

Objectives Overview Objectives Overview Databases, Data, in addition to In as long as mation Databases, Data, in addition to In as long as mation Databases, Data, in addition to In as long as mation

Reynolds, Jay, Journalist has reference to this Academic Journal, PHwiki organized this Journal Objectives Overview Discovering Computers 2010: Living in a Digital World Chapter 10 See Page 513 as long as Detailed Objectives Objectives Overview Discovering Computers 2010: Living in a Digital World Chapter 10 See Page 513 as long as Detailed Objectives

City University of New York, John Jay College of Criminal Justice US www.phwiki.com

This Particular University is Related to this Particular Journal

Databases, Data, in addition to In as long as mation Discovering Computers 2010: Living in a Digital World Chapter 10 Page 514 Databases, Data, in addition to In as long as mation Discovering Computers 2010: Living in a Digital World Chapter 10 Pages 514 – 515 Figure 10-1 Databases, Data, in addition to In as long as mation Database software, often called a database management system (DBMS), allows users to: Discovering Computers 2010: Living in a Digital World Chapter 10 Page 515

Databases, Data, in addition to In as long as mation 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 Discovering Computers 2010: Living in a Digital World Chapter 10 Page 516 Databases, Data, in addition to In as long as mation Valuable in as long as mation should have the following characteristics: Discovering Computers 2010: Living in a Digital World Chapter 10 Pages 516 – 517 The Hierarchy of Data Data is organized in layers Files, records, fields, characters Discovering Computers 2010: Living in a Digital World Chapter 10 Page 517 Figure 10-2

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 Discovering Computers 2010: Living in a Digital World Chapter 10 Page 518 Figure 10-3 The Hierarchy of Data Common data types include: Discovering Computers 2010: Living in a Digital World Chapter 10 Page 518 The Hierarchy of Data Discovering Computers 2010: Living in a Digital World Chapter 10 Page 519 Figure 10-4 A record is a group of related fields A primary key uniquely identifies each record A data file is a collection of related records

Maintaining Data File maintenance refers to the procedures that keep data current Discovering Computers 2010: Living in a Digital World Chapter 10 Page 520 Maintaining Data Users add new records to a file when they obtain new data Discovering Computers 2010: Living in a Digital World Chapter 10 Page 520 Figure 10-5 Maintaining Data Users modify a record to correct inaccurate data or update old data Discovering Computers 2010: Living in a Digital World Chapter 10 Page 521 Figure 10-6

Maintaining Data When a record no longer is needed, a user deletes it from a file Discovering Computers 2010: Living in a Digital World Chapter 10 Page 522 Figure 10-7 Maintaining Data Validation compares data with a set of rules or values to find out if the data is correct Discovering Computers 2010: Living in a Digital World Chapter 10 Pages 522 – 524 File Processing Versus Databases Discovering Computers 2010: Living in a Digital World Chapter 10 Pages 524 – 526

File Processing Versus Databases Discovering Computers 2010: Living in a Digital World Chapter 10 Page 525 Figure 10-10 Database Management Systems Discovering Computers 2010: Living in a Digital World Chapter 10 Page 527 Figure 10-11 Database Management Systems A data dictionary contains data about each file in the database in addition to each field in those files Discovering Computers 2010: Living in a Digital World Chapter 10 Pages 527 – 528 Figure 10-12

Database Management Systems A DBMS provides several tools that allow users in addition to programs to retrieve in addition to maintain data in the database Discovering Computers 2010: Living in a Digital World Chapter 10 Page 528 Database Management Systems A query language consists 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 Discovering Computers 2010: Living in a Digital World Chapter 10 Page 528 Database Management Systems Discovering Computers 2010: Living in a Digital World Chapter 10 Page 529 Figure 10-13

Reynolds, Jay KNXV-TV - Online Journalist www.phwiki.com

Database Management Systems A as long as m is a window on the screen that provides areas as long as entering or modifying data in a database Discovering Computers 2010: Living in a Digital World Chapter 10 Page 530 Figure 10-15 Database Management Systems A report generator allows users to design a report on the screen, retrieve data into the report design, in addition to then display or print the report Discovering Computers 2010: Living in a Digital World Chapter 10 Page 531 Figure 10-16 Database Management Systems Discovering Computers 2010: Living in a Digital World Chapter 10 Page 531

Database Management Systems A DMBS provides a variety of techniques to restore the database to a usable as long as m in case it is damaged or destroyed Discovering Computers 2010: Living in a Digital World Chapter 10 Pages 531 – 532 Database Management Systems Discovering Computers 2010: Living in a Digital World Chapter 10 Page 532 Figure 10-17 Relational, Object-Oriented, in addition to Multidimensional Databases Discovering Computers 2010: Living in a Digital World Chapter 10 Page 533 Figure 10-18 A data model consists of rules in addition to st in addition to ards that define how the database organizes data

Chapter 10 Complete

Reynolds, Jay Journalist

Reynolds, Jay is from United States and they belong to KNXV-TV – Online and they are from  Phoenix, United States got related to this Particular Journal. and Reynolds, Jay deal with the subjects like Local News

Journal Ratings by City University of New York, John Jay College of Criminal Justice

This Particular Journal got reviewed and rated by City University of New York, John Jay College of Criminal Justice and short form of this particular Institution is US and gave this Journal an Excellent Rating.