Chapter 10 - Discovering Computers 2010 Living in a Digital...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Discovering Computers 2010 Living in a Digital World Objectives Overview {F1AD29AF-4855-4632-A33A-7C6BD0B8EF4C} {00D51AE3-3972-4162-A48A-2AB5CF5C643B} {F9022B54-68C2-4973-9A00-460029290542} {B652055B-9DE1-4C42-AC96-5EDD65DE95B2} {5D36414B-1F5B-483D-B0D7-2562FA9BA2FE} rocessingdatabase, and explain howthedatabase interactsfield, describe thefi he term, approach and theDiscuss aapproach integrity,with record, and q file maintenance techniques and the term, data Define validation techniques and data and infor database terms character, • See Discovering Computers 2010: 22 Objectives Overview {D106D101-98E2-4ADD-B050-08FB6FD9C7E3} {E88FE9AA-4C3E-40FE-9938-E4D57BB1009F} {05557526-5BAD-42C3-B5E0-D9D41440BD4D} {E305D244-E4DA-4F72-BDF4-41C0BBE13480} cteristics most databaseobject-oriented, and access Web databases mon to of relational, management systems and discuss thedatabases Identify database design how to multidimensional responsibilit Explain guidelines • See Discovering Computers 2010: 33 Databases, Data, and Information ideo nprocessed items ages ext sdio ments bers Video {A341F818-CF12-404A-8DC2-904088044688} {FB9C2B27-E710-44EC-BC01-C702F88FBC08} Database {A574ECCB-F759-41AE-826B-9CA21860F015} {89BDF940-1E60-4BC0-ADD1-08B1DD27A0E0} Information Data {AF6F67BD-CBB3-4186-BAA1-EA4312FDBE34} a manner that allows access, retrieval, and use of that data Processed data {5211288F-3109-41B6-A1D6-0FABD44C7DB8} Audio • Page Discovering Computers 2010: 44 Databases, Data, and Information • Page Discovering Computers 2010: 55 Databases, Data, and Information {B6F2F5A7-BED6-48DE-BDED-00B22612B2FD} {8AAA8758-3C97-4925-B298-F159AD212B19} {DEEA4B1C-F503-4DF4-8562-EF8AB6F2C3D2} {208ED72B-AEAE-43DD-A956-316FC3A6298B} dd, modify, and forms and reports from the data Sort and retrieve data Create delete data Create a computerized database • • Page Discovering Computers 2010: 66 Databases, Data, and Information • Click to view Web Link, click Chapter 10, Click Web Link from left navigation, then click Data Integrity below Chapter 10 Page Data Discovering Computers 2010: 77 Databases, Data, and Information {DD79D247-41F8-4446-90B5-D081A1B1825E} {244AB3D5-CD15-4028-A959-C653CC0042D6} {F49B6862-B927-4B4D-B7EC-C96243A11BD8} {75CD7450-F6D8-453B-BD1A-CA1A0278BB22} {64516BC7-A9A6-47E1-8B6B-994901CCF96F} {7AC4EAC9-2D61-401F-B2C7-11BED3C94AAC} {41DBB944-46FC-4E22-8611-1AB7F2B6C6A5} Accessible Organized Useful Cost-effective Timely Verifiable Accurate • Page Valua Discovering Computers 2010: 88 The Hierarchy of Data • Page Data Discovering Computers 2010: 99 The Hierarchy of Data • Page A Discovering Computers 2010: 10 10 The Hierarchy of Data {3ADEFB70-4B77-456C-A7F2-ADB036757FF1} {57EF7F38-8121-4C23-801C-7A208D7732AE} {E6668FF6-8B29-47F6-91BD-78E25A8DAB79} {77C41238-8EB3-4B17-8F37-E146AEC82874} {31F45061-3A27-46AB-A124-2073E40F7E4B} {20806765-36AD-4827-8B14-B9ED1355C746} {B89D2363-4393-4349-9E6F-B9626E964A63} {D785950B-90C8-4525-A30E-03F25E4F08B1} {C4F3C754-C3E7-40F1-A1AD-FAE8DABA5BFD} {19EE5BBD-E31A-491C-80C9-AB2BB2960650} Text Currency Date Memo Hyperlink Numeric Yes/No AutoNumber Attachment Object • Page Com Discovering Computers 2010: 11 11 The Hierarchy of Data • A Page Discovering Computers 2010: 12 12 Maintaining Data {3FC8B13E-DBA4-4DA0-B951-669D1B905877} {277A3BD7-03D9-4C9B-B613-B7DCA0718AD3} Adding records • • Page {69AC429C-78BA-43D0-AB92-3E75791D3CC3} Modifying records Discovering Computers 2010: Deleting records 13 13 Maintaining Data • Page Users Discovering Computers 2010: 14 14 Maintaining Data • Page Users Discovering Computers 2010: 15 15 Maintaining Data • Page Whe Discovering Computers 2010: 16 16 Maintaining Data {1D6BB0ED-AE59-44A2-AF73-8042822206C7} {44C1B67D-1ABE-4F00-A324-1091A9A03ACA} {BAEAA931-3E51-4D4F-96C9-1164D5FBD2DC} {BC3FD48E-184C-4959-9F79-F03A80A64F53} {338D96A3-3D58-49A7-BAE7-E8E74E38C3B2} {50AAC77E-1A86-4A80-9096-C1D157506C2C} Range check Alphabetic/Numeric Check Consistency check Check digit CompletenessOther checks check • • Click to view Web Link, click Chapter 10, Click Web Link from left navigation, then click Data Validation below Chapter 10 Page Discovering Computers 2010: 17 17 File Processing Versus Databases a redundancy {FBBFFECC-FD49-4B4A-A23B-3F64A6491760} {E191597B-A605-4E4F-A9F4-EA15B8FBB727} tabase approach File processing system {6359B97C-75C1-40C8-8754-534299D611A4} {3B8C894F-7710-4059-8784-8FEC71B66E1E} {70DF95EC-D44F-4A55-8F01-D2E6747C77AD} {A08671B7-39B6-412D-85C9-9526D27090B5} {507EF085-7499-473E-824E-28BAA34D55E3} {9755B4D1-1248-4CDC-8422-B947A1D44C1B} {D455DDC9-F553-427E-94B0-58CB3FFD1294} {F519ECCB-CBA2-4500-8A5C-A290D731562C} {95786ABE-AA34-464F-9955-2FAC6C59EC3D} {50B22ADE-87F5-4C64-B61E-6C1D3FC5601A} ShareCan bedataReduces for manyEachtime data Programs and users sh Have more vulnerable Improve department easier access of files data redundancy Used development dataAllows has its own set years Isolate integrity • Page Discovering Computers 2010: 18 18 File Processing Versus Databases • Page Discovering Computers 2010: 19 19 Database Management Systems • Click to view Web Link, click Chapter 10, Click Web Link from left navigation, then click MySQL below Chapter 10 Page Discovering Computers 2010: 20 20 Database Management Systems • Page A Discovering Computers 2010: 21 21 Database Management Systems {312CBC67-0696-4FCD-BE3D-F126BC2EEEDA} {55FFD986-250D-485C-9017-52508BF5B976} {02399DFE-BBEA-4C8E-90C6-A645774DCFC2} {CCBAAE99-30FA-42B7-95D9-4A20AFB4FDB6} Query language generator example Report Query by Form • Page A Discovering Computers 2010: 22 22 Database Management Systems • Page A Discovering Computers 2010: 23 23 Database Management Systems • Page Discovering Computers 2010: 24 24 Database Management Systems • Click to view Web Link, click Chapter 10, Click Web Link from left navigation, then click E-Form below Chapter 10 Page A Discovering Computers 2010: 25 25 Database Management Systems • Page A Discovering Computers 2010: 26 26 Database Management Systems privileges least privilege {672C8356-8C52-4CA0-95FD-726EDC79AF32} provides means to ensure that only authorized users access data at permitt • Page Discovering Computers 2010: 27 27 Database Management Systems {B5AD591B-1D95-43AD-9C8C-A417D3D7610B} {81EF6860-D501-4B2C-9A5B-29424ABE5644} {58A13663-347A-4FAF-857F-B3B4F71DAB94} {B61B3869-8406-4C62-A440-64AF64D49DF3} Backup Continuous backup Recovery utility Log • Page A Discovering Computers 2010: 28 28 Database Management Systems • Page Discovering Computers 2010: 29 29 Relational, Object-Oriented, and Multidimensional Databases • A Page Discovering Computers 2010: 30 30 Relational, Object-Oriented, and Multidimensional Databases • Page A Discovering Computers 2010: 31 31 Relational, Object-Oriented, and Multidimensional Databases • • Click to view Web Link, click Chapter 10, Click Web Link from left navigation, then click SQL below Chapter 10 Page Discovering Computers 2010: 32 32 Relational, Object-Oriented, and Multidimensional Databases {570367A4-6A16-44E7-B330-7752A0B3043F} {5704FECC-5CB1-4AB4-AFE1-DC1A87B1FB29} {213C409A-0333-4EA3-8644-DFBDB7836DAC} {574402B0-906D-49D2-9874-88DBA356FFFE} Hypertext database Computer-aided design database Multimedia database Groupware database • Page An Discovering Computers 2010: 33 33 Relational, Object-Oriented, and Multidimensional Databases • Page Discovering Computers 2010: 34 34 Relational, Object-Oriented, and Multidimensional Databases • • Click to view Web Link, click Chapter 10, Click Web Link from left navigation, then click Data Warehouses below Chapter 10 A Page Discovering Computers 2010: 35 35 Web Databases {75391379-7205-4EBA-9723-D60832B8B209} {C7AD7FCE-AE13-40CF-B701-08C7B1BD3826} {9F6F4B63-2E37-4035-BAA8-0A0F3B5A377D} {F6E8387A-077E-4148-B5BE-14828A3B6153} {D5F330C7-7216-41C9-940E-C7CF32FD5CC1} {6137781D-A527-4F87-818B-26107641C17C} e airline reservations or services grades Buyclasses stocks for a job Shop for products semester for college or sell Search Check Register • Page Data Discovering Computers 2010: 36 36 Web Databases • Page Discovering Computers 2010: 37 37 Video: How a Photo Sharing Site Keeps Its Data CLICK TO START Discovering Computers 2010: 38 38 Database Administration • Click to view Web Link, click Chapter 10, Click Web Link from left navigation, then click Database Design Guidelines below Chapter 10 Page It is Discovering Computers 2010: 39 39 Database Administration relationship, and identifies users’ access privileges {AC0A5223-09DE-4A25-9583-848178E3F8FD} {4B63BE9F-BF51-450E-9098-A74063A00BBD} Database analysts and administrators are responsible for managing and c {547D3455-3F90-484C-86FE-69AB2477DF53} e Administrator (DBA) nd maintains the data dictionary, manages security, monitors performance, • Click to view Web Link, click Chapter 10, Click Web Link from left navigation, then click Database Administrators below Chapter 10 Page Discovering Computers 2010: 40 40 Database Administration • Page Empl Discovering Computers 2010: 41 41 Summary {AE30F8D6-EA39-4A2C-8436-2644F58BAFD5} {ECE388E6-695F-42E8-8089-C49D1521AD9F} {4F857BB6-EA70-4C86-BCAF-3D8C70C5715F} {8F3A89E4-7B23-4A04-812D-9B540C80ED47} {4BBE8786-495C-4339-8A11-193A48FA3812} {4BE61A80-F514-4E80-B78E-1A2FBAB1DD95} s f the database analysts and administrators valuable informationvaluable o types ofMethods for maintainingquality of and information are a databa databasesAssessing the How data of data Advantages organizing data in high-quality • Page Discovering Computers 2010: 42 42 Discovering Computers 2010 Living in a Digital World Chapter 10 Complete ...
View Full Document

Ask a homework question - tutors are online