Oracle Academy Database Design PDF

Database Design 1-2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. Objectives This lesson covers the following objectives: −Distinguish between data and information, and provide examples of each −Describe and give an examp...

Database Design 1-2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. Objectives This lesson covers the following objectives: −Distinguish between data and information, and provide examples of each −Describe and give an example of how data becomes information DDS1L2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. 3 Purpose All kinds of information (school records, mobile telephone records, ring tone downloads, grocery purchases) are stored in databases We interact with databases every day, consciously or unconsciously It is important to understand what is stored in a database and what can be retrieved from it DDS1L2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. 4 Data Compared to Information If you work in the information-technology industry, it is essential to understand how data is modeled and stored in a database If you work in any other industry, you will most likely have to work with data stored somewhere on a computer and probably be required to use data in your job to create reports and/or make decisions DDS1L2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. 5 Data vs. Information The words "data" and "information" are often used as if they are synonyms −Nevertheless, they have different meanings Data: −Raw or unprocessed material Information: −knowledge, intelligence, a particular piece of data with a special meaning or function −Information is often the result of combining, comparing, analyzing or performing calculations on data DDS1L2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. 6 Data vs. Information Whenever a student, teacher, administrator (or any person using a computer) interacts with a website, pieces of data are collected The website application may be unique to that school or company, but what happens in the background? DDS1L2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. 7 Data vs. Information Think about test scores, for example In one class, if every Data in… Information out… student receives a 1997 $1,000,000 …Next year’s budget numbered score, the 1998 $2,000,000 Regulatory scores can be calculated “Article VI prohibits use of School Implementation to determine a class property for…” …Where are they average going? 312 graduates By how much? The class averages can 98% of students …Class average be calculated to pass the or school average determine the school Math exam… average Student test scores were… DDS1L2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. 8 Data vs. Information The Oracle database software will transform recorded/stored data Information out… Data in… and statistics into useful 1997 $1,000,000 …Next year’s budget pieces of information 1998 $2,000,000 Regulatory Data: Each student’s “Article VI prohibits use of School Implementation test score is one piece property for…” …Where are they of data going? 312 graduates By how much? Information: The class’s 98% of students …Class average average score or the pass the or school average school’s average score Math exam… Student test scores were… DDS1L2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. 9 What is a Database? A database is a centralized and structured set of data stored on a computer system It provides facilities for retrieving, adding, modifying, and deleting the data when required It also provides facilities for transforming retrieved data into useful information A database is usually managed by a Database Administrator (DBA) DDS1L2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. 10 Documents, Pictures, Video, and Sound Within most modern databases, you can store and retrieve a Different Data/Sources wide variety of data and Operational Media-rich documents Inside the database, data is stored in its “raw” form External When this raw data is queried or retrieved, it is transformed into more useful information Decision support Documents DDS1L2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. 11 Question: What Does a Database Have to do with My Everyday Life? −Answer: More than you may realize... −A lot of websites that you visit are driven by a database DDS1L2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. 12 Question: If You Had One of the Jobs Listed Below, How Might You Use a Database? −Mechanic in a repair shop −Taxi driver −Landscaper DDS1L2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. 13 Question: Have You Ever Returned an Item to a Store Without a Receipt? −What information did you have to provide? −Were you able to return the item? DDS1L2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. 14 Terminology Key terms used in this lesson included: −Data −Database −Information DDS1L2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. 15 Summary In this lesson, you should have learned how to: −Distinguish between data and information, and provide examples of each −Describe and give an example of how data becomes information DDS1L2 Data vs. Information Copyright © 2020, Oracle and/or its affiliates. All rights reserved. 16