Chapter 09 - Discovering Computers Fundamentals, 2011...

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 Fundamentals, 2011 Edition Living in a Digital World Objectives Overview {501A839A-B226-4AF7-B2CB-CE11EE7AA54B} {F9022B54-68C2-4973-9A00-460029290542} {D2F0F61A-8412-467C-87B9-8474CB50B8C1} {43E08AF3-8A52-4128-BBE0-73DF6CAF2529} {FEFAAB38-5DAB-4FFD-A1AC-FF4E605E8E0F} rocessingexplain how a database interacts Discuss the termsrecords, deleting ase, and approach techniques (adding records,data and information field, e file maintenance and the qualities of valuablemodifying character, Describe database approach information with • See Discovering Computers 22 Objectives Overview {915A8A58-9FA7-4B6D-A159-0425D847423E} {D9BAD5AE-E8EF-48CC-BC35-21581307C02A} {D106D101-98E2-4ADD-B050-08FB6FD9C7E3} {A24A8794-781D-44C3-92B1-073197A59EBC} ties of database analysts and administrators most databaseobject-oriented, Explain how to access Web databases relational, management sy Discuss the functions common to of Describe characteristics • See Discovering Computers 33 Databases, Data, and Information ideo nprocessed items ages ext eful nized dio bers {A341F818-CF12-404A-8DC2-904088044688} {89BDF940-1E60-4BC0-ADD1-08B1DD27A0E0} Database {FB9C2B27-E710-44EC-BC01-C702F88FBC08} Data {A574ECCB-F759-41AE-826B-9CA21860F015} Information {AF6F67BD-CBB3-4186-BAA1-EA4312FDBE34} a manner that allows access, retrieval, and use of that data Processed data {561F6D2F-2185-4876-B011-289A3C704116} Meaningful • Page Discovering Computers 44 Databases, Data, and Information • Page Discovering Computers 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 66 Databases, Data, and Information • Page Data Discovering Computers 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 88 The Hierarchy of Data • Page Data Discovering Computers 99 The Hierarchy of Data • Page A Discovering Computers 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 11 11 The Hierarchy of Data • A Page Discovering Computers 12 12 Maintaining Data {3FC8B13E-DBA4-4DA0-B951-669D1B905877} {277A3BD7-03D9-4C9B-B613-B7DCA0718AD3} Adding records • • Page Modifying records Discovering Computers {69AC429C-78BA-43D0-AB92-3E75791D3CC3} Deleting records 13 13 Maintaining Data • Page Users Discovering Computers 14 14 Maintaining Data • Page Users Discovering Computers 15 15 Maintaining Data • Page Whe Discovering Computers 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 9, Click Web Link from left navigation, then click Data Validation below Chapter 9 Page Discovering Computers 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 18 18 File Processing Versus Databases • Page Discovering Computers 19 19 Database Management Systems • Click to view Web Link, click Chapter 9, Click Web Link from left navigation, then click MySQL below Chapter 9 Page Discovering Computers 20 20 Database Management Systems • Page A Discovering Computers 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 22 22 Database Management Systems • Page A Discovering Computers 23 23 Database Management Systems • Page Discovering Computers 24 24 Database Management Systems • Page A Discovering Computers 25 25 Database Management Systems • Page A Discovering Computers 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 • Click to view Web Link, click Chapter 9, Click Web Link from left navigation, then click Data Security below Chapter 9 Page Discovering Computers 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 • Click to view Web Link, click Chapter 9, Click Web Link from left navigation, then click Continuous Backup below Chapter 9 Page A Discovering Computers 28 28 Relational, Object-Oriented, and Multidimensional Databases • Click to view Web Link, click Chapter 9, Click Web Link from left navigation, then click Relational Databases below Chapter 9 A Page Discovering Computers 29 29 Relational, Object-Oriented, and Multidimensional Databases • • Page Discovering Computers 30 30 Relational, Object-Oriented, and Multidimensional Databases • Click to view Web Link, click Chapter 9, Click Web Link from left navigation, then click ObjectOriented Databases below Chapter 9 Page An Discovering Computers 31 31 Relational, Object-Oriented, and Multidimensional Databases • • Click to view Web Link, click Chapter 9, Click Web Link from left navigation, then click Data Warehouses below Chapter 9 A Page Discovering Computers 32 32 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 33 33 Web Databases • Page Discovering Computers 34 34 Video: How a Photo Sharing Site Keeps Its Data CLICK TO START Discovering Computers 35 35 Database Administration • Click to view Web Link, click Chapter 9, Click Web Link from left navigation, then click Database Design Guidelines below Chapter 9 Page It is Discovering Computers 36 36 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, • Page Discovering Computers 37 37 Database Administration • • Employees should learn how to use the data in the database effectively Page Discovering Computers 38 38 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 39 39 Discovering Computers Fundamentals, 2011 Edition Living in a Digital World Chapter 9 Complete ...
View Full Document

This note was uploaded on 06/08/2011 for the course COMPUTER CGS2100 taught by Professor Sanders during the Spring '09 term at Florida State College.

Ask a homework question - tutors are online