1 / 24

Database Processing

Database Processing. Chapter 5 Database Processing Sections Q1 & Q2 Skip Sections Q3-Q5. Today’s Topic. Security. Hardware & Software. IS Basics. Information Quality. Types of IS. Telecommu-nications. Systems Development. PowerPoint.

nasnan
Download Presentation

Database Processing

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Processing Chapter 5Database Processing Sections Q1 & Q2 Skip Sections Q3-Q5

  2. Today’s Topic Security Hardware & Software IS Basics Information Quality Types of IS Telecommu-nications Systems Development PowerPoint Functional, Crossfunctional & Interorganizational Database Processing & Design Spreadsheet Design E-commerce Access Excel Business Intelligence

  3. Database Processing Database Processing Benefits What is a database Components

  4. Objectives • Define and recognize examples of database, table, entity, field, attribute, record, primary key, foreign key and anomaly. • Explain the benefits of using databases over spreadsheets or other file types. • Evaluate problems to determine when it is appropriate to implement a database solution.

  5. How Does Google Work? • Web Crawler • Indexer • Query Processor

  6. What Does Google’s Web Crawler Do? • Finds pages on the web and gives full text of pages to Indexer • Extracts links from new pages for subsequent crawling

  7. What Does Google’s Indexer Do? • Each significant word in page is extracted and indexed • Results stored in tables: • Search term • URL of page containing term • Location of term on page • Number of times term appears on page • Number of pages that link to this URL

  8. What Does Google’s Query Processor Do? • User Interface – allows you to identify search criteria • Engine – matches search criteria to index of terms previously stored • Results Formatter • displays URLs containing search terms • displayed in order by a ranking that is based on other data stored about the term’s appearance on the page

  9. What is the Google Process? From: googleguide.com/google_works.html

  10. Purpose of a Database Keep track of data with multiple themes.

  11. What is a Database? • Collections of records • Related tables • Metadata

  12. What is Metadata? Customer Table • Cust ID – 3 numeric digits, must be unique • First Name – up to 20 alphanumeric digits, required • Last Name – up to 25 alphanumeric digits, required • E-mail – up to 25 alphanumeric digits, optional

  13. What are the Benefits of Databases? • ad-hoc information retrieval • only relevant data is output • shared access • security • referential integrity can be enforced automatically • data independence • data integrity

  14. What is a Data Anomaly?

  15. Anomaly Example • What anomalies can you identify?

  16. Database or Spreadsheet • A small health food store has customers that pay a one-time membership fee. These members receive reduced prices on all merchandise. A list of all customers who have paid this one-time fee (showing their name and the date they paid) must be maintained. Which application will support this task best for the novice user? Why?

  17. Database or Spreadsheet • The membership fee is an annual fee. You want to list only those customers who paid this year. Why?

  18. Database or Spreadsheet • In addition to name and date paid, you want to keep track of e-mail addresses for sending monthly newsletters and special promotions to current customers who use e-mail, mailing addresses for current customers who don’t use e-mail, and phone numbers to contact old members about renewing. Why?

  19. Database or Spreadsheet • You are the instructor of a course. You need to store multiple choice exam questions and answers. You plan to produce two versions of the exam with scrambled questions and scrambled answers. You also need to produce an answer key for each version. Why?

  20. Database or Spreadsheet • You are the instructor of a course. You need to store individual assignment grades for reporting at the end of the semester. You report all final grades at the same time. Why?

  21. Database or Spreadsheet • You are the instructor of a course. You need to store individual assignment grades for reporting throughout the semester. You want each student to see only his/her grades. Why?

  22. What Database Vocabulary Should I Be Familiar With? • Database • Table or Entity • Record • Field or Attribute • Value

  23. What are Key Attributes? Foreign Key – connects a row in one table with one or more rows in another Primary Key – uniquely identifies each row/record in a table

  24. Database Vocabulary

More Related