410 likes | 1.23k Views
Revision Database Management System (DBMS). Database. DBMS. Database Management Systems. DBMS is a collection of programs that enables you to store, modify, and extract information from a database. Reports and ad hoc queries. Programs. Sales and transaction data. Programmer. Analyst.
E N D
Database DBMS Database Management Systems DBMS is a collection of programs that enables you to store, modify, and extract information from a database Reports and ad hoc queries Programs Sales and transaction data Prepared by:Natalie Rose
Programmer Analyst Programs & Revisions Ad Hoc Queries and Reports Data Collection and Transaction Processing DBMS & People Database Administrator (Standards, Design, and Control) Data Database Management System Managers Program Program Business Needs Business Operations Prepared by:Natalie Rose
Relational Databases • Tables • Rows • Columns • Primary keys • Data types • Text • Dates & times • Numbers • Objects Customer Table CustomerID Name Address City 12345 Jones 123 Elm Chicago 28764 Adamz 938 Main Phoenix 29587 Smitz 523 Oak Seattle 33352 Sanchez 999 Pine Denver 44453 Kolke 909 West Denver 87535 James 374 Main Miami Orders Table OrderID CustomerID Date Salesperson Total_sale 117 12345 3/3/06 887 57.92 125 87535 4/4/06 663 123.54 157 12345 4/9/06 554 297.89 169 29587 5/6/6 255 89.93 Prepared by:Natalie Rose
Focus on data Stable data Programs change. Data independence Change programs without altering data. Data integrity Accuracy. Time. Concurrency. Security. Ad hoc queries Speed of development Report writers. Input forms. Data manipulation. Flexibility & Queries Database Advantages All Data Files Database Management System Invoice Program Billing Program Prepared by:Natalie Rose
Linking Tables The Orders to ItemsSold relationship enforces referential integrity. One Order can list many ItemsSold. Prepared by:Natalie Rose
Database Administration • Database Administrator • Testing • Backup • Recovery • Standards • Access Controls Prepared by:Natalie Rose
E-Business Databases • E-business is transaction-based • Databases support multiple users and protect transactions • Modern websites are driven by databases Prepared by:Natalie Rose
E-Business Databases Order Form Descriptions Prices Web page Internet Customer Page request Web Server Web program script <HTML> Text <% Database connection %> Queries and data Prepared by:Natalie Rose
Cases: Pharmaceuticals How do you store and retrieve huge amounts of data? Prepared by:Natalie Rose