Transcript Database
Databases Basic Data Management Concepts 2 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 When do I interact with databases Register for classes 3 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 Data Organization 4 Records Garner Julia Garrett Allen Gieger Carl Geiser Gary Goucher Gerard 30 Simpson Ave 1222 Elm Street 25 West Ave 712 Chestnut 17 Asbury Ave 555-3432 555-9876 555-2702 555-1112 555-2956 Fields A collection of one or more related tables Database File or Table The Organization/Hierarchy of Data 5 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 7 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 The Database Approach to Data Management 8 Database approach Multiple application programs share a pool of related data Increased flexibility in the use of data Requires a database management system (DBMS) Queries 9 Built thru SQL (Structured Query Language) First Name, Last Name and Annual Fee Milton Louella Elena Adelbert Benjamin Brewer Drake Gupta Ruiz Tu $90.00 $40.00 $55.00 $80.00 $37.0 SQL: SELECT FIRSTNAME, LASTNAME, ANNUAL FEE FROM: MEMBER, MEMBERSHIP PLANS WHERE MEMBER.MEMBERSHIP CODE = MEMBERSHIP PLANS.MEMBERSHIP CODE ORDER BY LAST NAME Relational Database 10 Sales No Territory Sales No LName FName 112 1 112 Belle Jamie 113 2 115 Morris Dave 114 3 114 Allan Wil 115 4 113 Shaw Danny 116 5 116 Michaels Wilson 117 6 117 Crozier Judy Sales No LName FName Territory 112 Belle Jamie 1 113 Shaw Danny 2 114 Allen Will 3 Database Structures 11 Types of Databases Relational Object-Oriented Hierarchical, Network, Multi-Dimension