1 / 49

Database

Database. Definition Structure Parts Types. Database. database - organized collection of data that may reside in multiple files database software - stores, organizes and retrieves the data. The Electronic File Cabinet: Database Basics.

kscholl
Download Presentation

Database

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 • Definition • Structure • Parts • Types Chapter 4c,

  2. Database • database - organized collection of data that may reside in multiple files • database software - stores, organizes and retrieves the data Chapter 4c,

  3. The Electronic File Cabinet: Database Basics Like word processors, spreadsheets, and graphics programs, database programs are applications. Database programs are designed to maintain collections of information stored on computer disks. Chapter 4c, 8.04

  4. The Electronic File Cabinet: Database Basics • What Good Is a Database? • What’s a Good Database System? • Database Anatomy • Database Operations Chapter 4c, 8.04

  5. What Good Is a Database? Databases make it easier to: • store large quantities of information. • retrieve information quickly and flexibly. • organize and reorganize information. • print and distribute information in a variety of ways. Chapter 4c, 8.05

  6. What’s a Good Database System?(Properties) • data integrity- the validity of the data • data independence - the way an application program displays the data does not have to be the same way the data is physically stored Chapter 4c,

  7. What’s a Good Database System?(Properties) • data redundancy - repetition of data • data security - access to data (sensitive) or protection against loss • data maintenance - ease of adding, deleting and updating records Chapter 4c,

  8. Bell, Pat 123 Eagle Cr. Anytown, OR 123 Eagle Cr. Database Anatomy: An Electronic File Cabinet made up of files, which are… Databases are … made up of records, which are… made up of fields. Chapter 4c, 8.06

  9. Database Terms Field Record File Key Field Objects Relationship Chapter 4c,

  10. Database Terms Examples: First name middle initial phone no. catalog no. One unit or piece of data; the more precise each field is, the more efficient the database management is when you start searching and manipulating data Field Chapter 4c,

  11. Database Terms Examples: a driver’s license, all the info about each catalog item A collection of all related fields about one person, place or thing Record Chapter 4c,

  12. Database Terms Examples: All drivers licenses for a state, all items in a catalog A collection of records related to the same topic File Chapter 4c,

  13. Database Terms Examples: SS number catalog item # filename customer # numeric count A field containing different (unique) information for each record in a database; if you don’t identify a key field, Access can assign one. Key Field Chapter 4c,

  14. Database Terms Examples: Tables forms reports queries macros modules Items attached to a database to hold data stored in the database Objects Chapter 4c,

  15. Database Terms Examples: Using Social Security #, item number, or Vendor no. to tie data from one table to data from another table An association established between tables using fields that the tables have in common Relationship Chapter 4c,

  16. View View: a display of the information in fields based on a particular arrangement of field data. Two views: list (in Access this is called Datasheet view) and browse (form view) list - a table, see records line by line browse - see one record at a time in the guise of an onscreen form Chapter 4c, 8.07

  17. Database Operations Database commands are used to retrieve, organize, print and distribute database information. • Import: • Browse: • Sort: • Report: • Query(Filter): Chapter 4c,

  18. Import:receive data in the form of text files Chapter 4c,

  19. Browsenavigate through information by just looking at it. Chapter 4c,

  20. Sort: rearrange records (alphabetically or numerically). Chapter 4c,

  21. Report: printout of an ordered list of records. Chapter 4c,

  22. Queries/Filters:search or select one or more specific records A set of criteria applied to records in order to show a subset of the records or sort the records Chapter 4c,

  23. The User’s View Database programs can produce a variety of reports (or printouts). Customized reports display an ordered list of selected records and fields Chapter 4c, 8.09

  24. Database Objects Table Query Form Report Macros Module Chapter 4c,

  25. Database Objects The primary unit of a database that stores field names, field descriptions, field controls, and field data. Tables display multiple records in column/row format similar to a spreadsheet layout. Table Chapter 4c,

  26. Database Objects A structured guideline used to search database tables and retrieve records that meet specific conditions. Query Chapter 4c,

  27. Database Objects An aesthetically pleasing layout of table data designed to display one record on-screen at a time. Form Chapter 4c,

  28. Database Objects An organized format of database data design to generate printouts that provide meaningful information Report Chapter 4c,

  29. Database Objects A mini program that stores a set of instructions designed to perform a particular task. Macros Chapter 4c,

  30. Database Objects A collection of Visual Basic programming procedures stored together to customize the Access environment. Module Chapter 4c,

  31. Database Objects • When you create a new database, you have to name the database and identify the folder to store. • Eventually you will create objects within the database, and Access will store the objects together in the same database file. Chapter 4c,

  32. Special-Purpose Database Programs databases: electronic phone directories Ready-to-use, encyclopedias, atlases, and similar reference materials. Geographical information systems (GISs): include geographic and demographic data in map form, Chapter 4c, 8.10

  33. 1997 Special-Purpose Database Programs Personal information managers (PIMs): an electronic organizer that is customized to fit individual needs. Chapter 4c, 8.10

  34. Rules of Thumb: Dealing with Databases • Choose the right tool for the job. • Plan ahead. • Start small and test your database design. • Make data consistent. • Make use of automatic data checking. • Query with care. • Develop smart search methods. Chapter 4c, 8.12

  35. Structure of the data • lowest level - characters • characters are combined to form a field (single item of information) • collection of fields is a record • records are stored in file(s) • it is up to the database designer how the data is to be organized, it is up to the database software to retrieve, and store the information Chapter 4c,

  36. Types of Database Software • file management programs • database management systems Chapter 4c,

  37. File Management Programs • a computer program that allows the user to store and manage information on a single file • used by individuals and small businesses • easy to learn, low price, less complex • example - Works database Chapter 4c,

  38. Database Management Systems • A program that stores data in files structured into fields and records. Can use data stored in one file to match with several other files • more expensive, more complex • four different structures Chapter 4c,

  39. Database Structures to Link Files • Hierarchical • Network • Relational • Object-Oriented Chapter 4c,

  40. Hierarchical Databases • links data with a hierarchical relationship • group fields together to form a special relationship- looks like a pyramid • limits the way you can search for information based on the relationships Chapter 4c,

  41. Hierarchical Design Chapter 4c,

  42. Network Databases • also based on relationships , but a child can have more that one parent or none Chapter 4c,

  43. Network Design Chapter 4c,

  44. Relational Databases • Most popular - Access • Information related through a common field called a key • key field - is a field that occurs in two or more files and serves as a bridge between them Chapter 4c,

  45. Relational Database Chapter 4c,

  46. Object-Oriented Databases • based on the relationships of the objects within the database • newest type - heavily used in multimedia objects Chapter 4c,

  47. Parts of the DBMS Software • Data Definition Language- used to describe the structure (schema) • Schema outlines the data - each field must be identified with a name, length and type • Data Manipulation Language - use to view, add, delete, sort and modify records Chapter 4c,

  48. Parts Continued • Query Language-asks questions of the dB • Report Generator - design and generate reports based on the information within the dB Chapter 4c,

  49. Questions

More Related