Ch. 5

*database- A self describing collection of integrated records.

*columns- Bytes are grouped (student name and student and student name)

*byte- A character of data.

*Rows- Columns or fields are grouped into this.

*Table or file- A group of similar groups or records.

*key or primary key- Column or group of columns that identifies a unique row in a table.

*Foreign keys- Keys of a different foreign table than the one in which they reside.

*relational databases- Data bases that carry their data in the form of tables that represent relationships using foreign keys.

*Metadata- Data that describes date.

*Database management system (DBMS)- A program used to create, process, and administer a database. (SQL Server Microsoft)  -license free

*Database administration- can be used to set up a security system involving use accounts, passwords, permissions, and limits for processing the database.

*Database application- A collection of forms, reports, queries, and application programs that serves as an intermediary between users and database data.

*Queries- Search based on values provided by the user.

*Reports- Structured representation of data using sorting, grouping, filtering, and other operations.

*Forums- View data; insert new, update existing, and delete existing data.

*Applications Programs- Provide security, data consistency, and special purpose processing. (Handle out of stock situations)

*graphical queries- Created when the user clicks on a graphic.

Multi-user processing- (Buying concert tix at the same time as multiples)

*Lost update problem- (someone buys your concert tix at the same time and gets them)

*Entity-relationship (E-R data model)- Atool for constructing data models.

*MongoDB- Open source docu. to store video footage.

*ACID- (atomic, consistent, isolated, durable) transactions.

*Normal forms- to remove duplicative data.

*data integrity problem- “accounting and finance” - “Accounting” 

1:N one-to-many

N:M Many-to-many

*Crows feet- angled lines.