Discovering ComputersChapter 10 Database ManagementData and InformationData and InformationDatabase SchemaDatabase TerminologyData and InformationData and InformationThe Hierarchy of DataThe Hierarchy of DataThe Hierarchy of Data: FieldsCommon Data TypesDatabase Record & Primary KeysThe Hierarchy of DataThe Hierarchy of Data: Data FileThe Hierarchy of Data: Data File or TableMaintaining Data: File MaintenanceMaintaining Data: Adding RecordsMaintaining Data: Changing RecordsMaintaining Data: Deleting RecordsMaintaining DataMaintaining Data: ValidationMaintaining Data: Validity ChecksMaintaining Data: Completeness CheckMaintaining Data: Check DigitsSumming Digits in a NumberFile Processing .vs. DatabasesFile Processing .vs. DatabasesFile Processing versus DatabasesFile Processing versus DatabasesFile Processing versus DatabasesFile Processing versus DatabasesBlockbuster Video: BankruptcyFile Processing versus DatabasesDatabase Relationships in MS-AccessDatabase Relationships in MS-AccessVarious Database Management SystemsDBMS: Data DictionaryDBMS: Default Values FieldsDBMS QueriesMS-Access Database QueriesCross Table (CrossTab) QueryAccess Database Split FormAccess Filter Query (MS-Access 2007)Database Report (MS-Access 2007)Database Management Systems: QBEDatabase Management Systems: FormsDatabase Management Systems: ReportsDatabase Management Systems: SecurityDatabase Management Systems: BackupsDatabase Management Systems:RecoveriesRelational, Object-Oriented, and Multidimensional DatabasesDatabase Management SystemsMySQL ( “My Sequel” )Relational, Object-Oriented, and Multidimensional DatabasesRelational, Object-Oriented, and Multidimensional DatabasesRelational, Object-Oriented, and Multidimensional DatabasesStructured Query Language (SQL)Relational, Object-Oriented, & Multidimensional DatabasesRelational, Object-Oriented, and Multidimensional DatabasesRelational, Object-Oriented, and Multidimensional DatabasesRelational, Object-Oriented, and Multidimensional DatabasesRelational, Object-Oriented, and Multidimensional DatabasesRelational, Object-Oriented, and Multidimensional DatabasesRelational, Object-Oriented, and Multidimensional DatabasesDatabase Indexes & Index LevelsUsing Indexed FilesSlide 68Using Indexed Files (continued)Relational, Object-Oriented, and Multidimensional DatabasesObject Oriented DatabasesDatabase for Objects (db4o)Relational, Object-Oriented, and Multidimensional DatabasesRelational, Object-Oriented, and Multidimensional DatabasesRelational, Object-Oriented, and Multidimensional DatabasesMOLAP : Multidimensional Online Analytical ProcessingDisadvantages of MOLAP:Relational, Object-Oriented, & Multidimensional DatabasesDatabases: Data Warehouse & TermsMore on Data Mining …Cancer & Cigarette SmokingCancer & Cigarette SmokingData Mining: Medical ExampleData Mining: Diet SodaSlide 85Common Gateway Interface: CGIDatabase AdministrationDatabase AdministrationWeb DatabasesWeb Databases: YouTube VideosHulu.com Movie DatabaseWeb DatabasesOther Databases on the WebOther Web DatabasesOther Web DatabasesEnd: Chapter 10 PresentationDiscovering Computers CHAPTER 10DATABASE MANAGEMENTChapter 10 Database Management Discuss the functions common to most DBMSsDiscuss the functions common to most DBMSsIdentify the qualities of valuable informationIdentify the qualities of valuable informationExplain why data is important to an organizationExplain why data is important to an organizationDiscuss the terms bit, byte, character, field, record, file, databaseDiscuss the terms bit, byte, character, field, record, file, databaseIdentify file maintenance techniquesIdentify file maintenance techniquesDifferentiate between a file processing system approach and the database approachDifferentiate between a file processing system approach and the database approachDescribe characteristics of relational, object-oriented, and multidimensional databasesDescribe characteristics of relational, object-oriented, and multidimensional databasesExplain how Web databases workExplain how Web databases workDiscuss the responsibilities of database analysts and administratorsDiscuss the responsibilities of database analysts and administratorsNextData and InformationHow are data and information related?p. 10.02 Fig. 10-1Nextprocessingdata stored on diskStep 1. The member data, including a photograph, is entered and stored on the hard disk.Step 2. The computer extracts the member data from disk.Step 3. The receipt is created and printed.Data is raw factsInformation is data that is organizedand meaningfulreceiptComputers process data into informationAdd, change, and delete dataAdd, change, and delete dataCreatedatabaseCreatedatabaseSort and retrieve dataSort and retrieve dataCreateforms, reports, queriesCreateforms, reports, queriesData and InformationWhat is a database?p. 10.03Database software allows you toDatabase software allows you toCollection of data organized so you can access, retrieve, and use itCollection of data organized so you can access, retrieve, and use itDatabase software also called database management system (DBMS)Database software also called database management system (DBMS)Database SchemaDatabase Terminologyhttp://www.geekgirls.com/database_dictionary.htmData Dictionary Examplehttp://2007.ispace.ci.fsu.edu/~bce05c/ir/images/datadictionary.jpgData and InformationWhat is data integrity?p. 10.03NextDegree to which data is correctGarbage in, garbage out (GIGO)—computer phrase that means you cannot create correct information from incorrect dataGarbage outGarbage inData integrity is lostUsefulUsefulAccessibleAccessibleOrganizedOrganizedData and InformationWhat are the qualities of valuable information?p. 10.04NextTimelyTimelyVerifiableVerifiableAccurateAccurateCost-effectiveCost-effectiveThe Hierarchy of DataWhat is the hierarchy of data ? Bit - Most elemental unit of data ( 0 or 1)Byte – 8 bits make up a byte e.g. 11001001Character – Another name for a byteNote: A Unicode character is 2 bytes (16 bits)Example: The letter ‘A’ is \u0041 in UnicodeField – a group of related charactersRecord – a group of related fieldsFile – a group of related recordsDatabase – One or more filesp. 10.05 Fig. 10-2The Hierarchy of DataWhat is a data hierarchy?p. 10.05 Fig. 10-2NextDatabase contains files, file contains records, record contains fields, field contains charactersThe Hierarchy of Data: FieldsWhat is a