1 / 17

Are you keeping records of any of your day to day activities?

Are you keeping records of any of your day to day activities?. What are these activities? Why? Do you keep track of these records?. Essential Understanding : Organized tasks promote efficiency. Essential Question: How is a computerized database more efficient than a filing system?.

iolana
Download Presentation

Are you keeping records of any of your day to day activities?

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. Are you keeping records of any ofyour day to day activities?

  2. What are these activities? Why? Do you keep track of these records?

  3. Essential Understanding:Organized tasks promote efficiency.

  4. Essential Question:How is a computerized database more efficient than a filing system?

  5. MS ACCESS: A Database

  6. Objectives: • Describedatabase and explainitshistory and uses. • Explain the purpose of a database, kinds and types • Explain the qualities of good database information and characteristics of a well-designeddatabase.

  7. Whatisdatabase? • Adatabaseis a collection of organized information fromwhichpieces of data canbeeasily and quicklyaccessed in a mannerunderstood by a computer program. • Examples: list of groceries to buy books to borrowfrom the librarylist of classmatestelephone directory

  8. Purpose of a database • A databaseis information that a personneeds in hispersonal, business, social and religious life and the power and purpose of information is not only in collecting and findingthem but more importantly in usingthem.

  9. Examples of Everyday life Databases • Entity – is the termgiven to the category of information in database. • Examples: car dealer – clients, cars and salesmen • Bookstore – books, authors and publishers • School – students, faculty and classes • Mall – customers, stores, branches and contractors

  10. Kinds of Databases • Structureddatabase – information isarranged in uniform format. • examples: list of personsborn in a countrymedicaldatabase of patient’s data • Free-formdatabase – It is a loose collection of information, such as thoseyouwillfind on the World Wide Web. • example: collection of documents in the computer made fromseveral programs.

  11. Types of databases • Operationaldatabase– is a dynamicdatabasethatisused by anyorganization in itsday to dayoperation. • example: inventorydatabase

  12. Types of databases • Analyticaldatabase– is a staticdatabasewherein data israrelymodified. • This databaseisoftenused to store and trackhistorical data to make long term projections and analysis. • example: global temperature to determine the effects of global warming in certain areas for a period of time.

  13. RelationalDatabase Management System (RDBMS) • RelationalDatabase Management System - isdesigned to create, maintain, manipulate, modify and delete information in a relationaldatabase.

  14. Qualities of Good Database Information • 1. Accurate information • 2. Organized information • 3. Timely information • 4. Verifiable information • 5. Accessible information • 6. Economical information • 7. Useful information

  15. Can youmake a distinction betweenmanualdatabase and an electronicdatabase? • How wouldyoucategorizedatabases?

  16. What are the qualities of a good database information?

  17. Thank You!

More Related