databases n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Databases PowerPoint Presentation
Download Presentation
Databases

Loading in 2 Seconds...

play fullscreen
1 / 11
desiderio

Databases - PowerPoint PPT Presentation

77 Views
Download Presentation
Databases
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. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Databases

  2. Basic Data Management Concepts • Database • Collection of all the data related to a particular topic or purpose -- for example, student data, customer data or product data • Database management system (DBMS) • Software used to access database

  3. When do I interact with databases • Register for classes • Shopping • Finding midi files on the CIS 1055 website • Flight registration systems • Cherry & White Pages • Purchasing a book from Amazon.com • Paying your phone bill on line

  4. Data Organization Records Garner Julia 30 Simpson Ave 555-3432 Garrett Allen 1222 Elm Street 555-9876 Gieger Carl 25 West Ave 555-2702 Geiser Gary 712 Chestnut 555-1112 Goucher Gerard 17 Asbury Ave 555-2956 File or Table Fields A collection of one or more related tables Database

  5. The Organization/Hierarchy of Data • Field • Name, number, or combination of characters that describes some aspect of an object • Record • Collection of related fields • File • Collection of related records • Database • Collection of integrated and related files

  6. What can I do with a DBMS • Enter data quickly and easily • Organize records in different ways • Locate specific records quickly • Eliminate data • Connect files with related information • Create Reports • Create Queries

  7. The Database Approach to Data Management • Database approach • Multiple application programs share a pool of related data • Increased flexibility in the use of data • Requires a database management system (DBMS)

  8. Queries • Built thru SQL (Structured Query Language) • First Name, Last Name and Annual Fee Milton Brewer $90.00 Louella Drake $40.00 Elena Gupta $55.00 Adelbert Ruiz $80.00 Benjamin Tu $37.0 • SQL: SELECT FIRSTNAME, LASTNAME, ANNUAL FEE FROM: MEMBER, MEMBERSHIP PLANS WHERE MEMBER.MEMBERSHIP CODE = MEMBERSHIP PLANS.MEMBERSHIP CODE ORDER BY LAST NAME

  9. Relational Database

  10. Database Structures • Types of Databases • Relational • Object-Oriented • Hierarchical, Network, Multi-Dimension