Title: Discussion DataBase, ITSE 2402--Intermediate Web Programming
Course: Intermediate Web Programming (25436)

ITSE 2402 Intermediate Web
DataBase Chapter 7 Discussion Chapter

Discussion

- Introduction to Databases (background)
  - The information stored in computer databases is actually sorted in tables similar to spreadsheets.
  - Think of databases as consisting of tables, which consist of records, which consist of fields.
  - A flat-file database stores information in a single table.
  - The file processing that we completed earlier in our ATM programs stored data in records (each line was considered a record.
- Refer to Figure 7-1 for database query examples:
  - Figure 7-1 shows a table that contains an employee directory database
  - The table columns are the database fields
  - The rows are the records for each employee
- Working with Database Management Systems (background)
  - An application(s) used to access and manipulate a database is called a database management system (DBMS).
  - A query is a set of instructions and criteria for retrieving, adding, modifying, and deleting database information.
- Querying Databases with Structured Query Language
  - PHP includes functionality that allows you to work directly with different types of databases. The SQL presented in this assignment may not directly correspond to other SQL instructions, but the concepts are the same.
  - Common SQL keywords

Keyword | Description
DELETE | Deletes a row from a table
FROM | Specifies the tables from which to retrieve or delete records
INSERT | Inserts a new row into a table
INTO | Determines the table into which records should be inserted
ORDER BY | Sorts the records returned from a table
SELECT | Returns information from a table
UPDATE | Saves changes to fields in a record
WHERE | Specifies the conditions that must be met for records to be returned from a query