Databases, Data, and Information PDF

Database Data Information " Collection of " Processed "Collection of data unprocessed data organized in items...

Database Data Information " Collection of " Processed "Collection of data unprocessed data organized in items " Organized a manner "Text " Meaningful that allows " Numbers "Useful access, " Images retrieval, and use of that "Audio data " Video Page 352 Discovering Computers Fundamentals, Chapter 9 Databases, Data, and Infornmation  Databases,Data, and Information " Database software, often called a database management system (DBMS), allows users to: Greate e Add, modifty, and Computerized delete data database Sort and retrieve Create ferme-ed data reports from the data Page 352 Discovering Computers Fundamentals, Chapter 9 6 Databases,Data, and Information " Data integrity identifies the quality of the data Garbage in, garbage out (GIG0) points out the accuracy of acomputer's output depends on the accuracy of the input Page 353 Discovering Computers Fundamentals, Chapter 9 Databases, Data, and Information " Valuable information should have the following characteristics: Accurate Verifiable Timely Organized Accessible Useful Cost effective  Instructor file Instructor ID Text A character is one byte First Name |Last Name Text Text Number - Numbers, letters, space, Extension |office Text punctuation marks, or Web Address Hyperlink other symbols data types Student file " field is a A Student ID First Name AutoNumber Text combination of one or Last Name Text Text Address more related |City State Text Text Postal Code Number characters E-mail Address Hyperlink Date Admitted Date/Time - Field name Major Photo Text Attachment - Field size Data type Pages 355 -356 Discovering Computers Fundamentals, Chapter 9 Figure 93 The Hierarchy of Data " Arecord is a group of related fields -A primary key uniquely identifies each record A data file is a collection of related records Sample Student File Student First Postal E-mail Date Last Admitted Major Photo ID Name Name Address City State Code Address Charlestown IN 46176 6/10/2010 EE mbrewer.jpg 2295 Milton Brewer 54 Lucy Court Louella Drake 33 Timmons Place Bonner IN 45208 louworld.com 8/9/2010 BIO ldrake.jpg 3876 3928 Adelbert Ruiz 99 Tenth Street Sheldon IN 46033 10/8/2010 CT aruiz.jpg 2872 Benjamin Tu 2204 Elm Court Rowley IN 46167 [email protected] 11/6/2010 GEN btujpg field records key field fields 12 Page 356 Discovering Computers Fun damentals, Chapter 9 Fiqure 94 Maintaining Data " File maintenance refers to the procedures that keep data current Adding Modifying records records Deleting records Pages 357 -358 Discovering Computers Fundamentals, Chapter 9 Maintaining Data