1 / 7

Chapter 17 Highlights DATABASES

Chapter 17 Highlights DATABASES. Database Terminology. A database is a collection of related data created for information retrieval. A database management system (DBMS) is a computer software used to create, maintain, and access databases.

breck
Download Presentation

Chapter 17 Highlights 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. 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. Chapter 17 HighlightsDATABASES

  2. Database Terminology A database is a collection of related data created for information retrieval. A database management system (DBMS) is a computer software used to create, maintain, and access databases. Examples: Access, IBM DB2, Oracle, SQL Server, MySQL Example databases you use: student records, bank, POS, eBay, phone call logs Below are examples of some large databases.

  3. Best Buy Database: Products Table (below) Employees Table Transactions Table Customers Table A database will have a collection of related tables. Example products table from a store database (below) fields records key field:a field that uniquely identifies each record

  4. Best Buy Database

  5. Client-Server Database Application PC’s run the client program – e.g. a medical information system. When the user opens a patient record, the program sends an SQL request to the database for the patient information. Database searches for patient and sends record to client Client sendsSQL request to search for a patient record The database server runs a DBMS such as Oracle or SQL Server. It stores the medical records.

  6. Web Database Application Internet Client Software = Web Browser Web Server stores web pages and sends them to Internet users Web Server sends SQL request to database for web page content – e.g. “Antique World Map” Database Server stores dynamic content of web pages – e.g. the auction listings

  7. Data Integrity – The accuracy of the data inside a database. Data integrity can be compromised from: human data entry errors, software bugs, security (e.g. hacking), and hardware failures (e.g. hard disk crash). Data Locking – Prevents two people from updating a record at the same time. SQL – Structured Query Language – a standard language used to query and update databases. It is used by most database systems. Example SQL statement: select Product Name, Product #, Stock from Products Table where Stock <= 5 Product NameProduct #StockiPod Touch 16GB A221 5 iPad 16GB A240 0

More Related