Chapter 1 Key Terms – Database Concepts – Seventh Edition – Kroenke & Auer

Concurrency
Page 16 – Ensures that one user’s work does not inappropriately interfere with another user’s work.

Glossary: A condition in which two or more transactions are processed against a database at the same time. In a single CPU system, the changes are interleaved; in a multi CPU system, the transactions can be processed simultaneously, and the changes on the database server are interleaved.

Database
Page 14 – A collection of related tables and other structures.

Glossary: A self describing collection of related records or, for relational databases, of related tables.

Database Application
Page 14 – A set of one or more computer programs that serves as an intermediary between the user and the DBMS. Application programs can be acquired from software vendors, and they are also frequently written in-house.

Functions – Page 16
Create and process forms
Process user queries
Create and process reports
Execute application logic
Control application

Database Management System (DBMS)
Page 14 – A computer program used to create, process, and administer the database.

Functions of a DBMS – Page – 16
Create Database
Create tables
Create supporting structures (indexes)
Read database data
Modify (insert, update, or delete) database data
Maintain database structures
Enforce rules
Control concurrency
Provide security
Perform backup and recovery

Delete
Page 7 – Remove data
Enterprise-class Database System
Page 19 – Enormous databases that support international organizations. They have hundreds of tables with millions of rows of data and support thousands of concurrent users. They’re in user 24/7

See Figure 1-26 for structure.

ID Column
Page 9 – A column that gives a unique number to the record to avoid different records with the same names. They’re also used as linking columns to other tables.
Insert
Page 7 – add new data
List
Page 4 – used to help people keep track of things.
Metadata
Page 14 – Data about the structure of a database. Examples are the names of tables, the names of columns and the tables to which they belong. properties of tables and columns, and so forth.
Microsoft SQL Server 2014
Page 21 – a DBMS. An example of enterprise-class DBMS
Microsoft SQL Server 2014 Express Edition
Page 21 – It’s a great learning tool that can be used for smaller databases.
Microsoft SQL Server 2014 Management Studio
Page 21 – User client interface to Microsoft SQL Server 2014
Modification Action
Page 7 – Insert, update and delete.
Modification Problem
Page 4 – When making a change to a list and it has unintended consequences.
MySQL Workbench
Page 22 – User client interface
Nonrelational Database
Page 24 – Created to have the ability to quickly create and store massive amounts of data. Used with Web 2.0
NoSQL
Page 24 – A database that doesn’t use SQL. It’s a nonrelational database regardless of what query language is used.
Null Value
Page 5 – Missing value. They are always problematic and we want to avoid them whenever possible.
Oracle Database Express
Edition 11g Release 2 Express Edition
Page 21 – 22 – DBMS
Oracle MySQL 5.6 Community Server
Page 22 – SQL is executed in this.
Oracle SQL Developer
Page 22 – User client interface to Oracle Database 11g Release 2.
Personal Database System
Page 19 – A few tables and each table would have at most several hundred rows. Typically one user.

Structure:

User
Database
Microsoft Access or other personal DBMS – Contains the database application and DBMS.

Glossary: A DBMS product intended for use by an individual or small workgroup. Such products typically include application development tools such as form and report generators in addition to the DBMS. For example, Microsoft Access 2013

Referential Integrity Constraint
Page 16 – Rules about data values and have a DBMS enforce them.

Glossary: A relationship constraint on foreign key values. A referential integrity constraint specifies that the values of a foreign key must be a proper subset of the values of the primary key to which it refers.

Related Tables
Page 14 – Tables that are related by a common column
Relational Database
Page 6 – Contains a collection of separate tables.

Glossary: A database that consists of relations. In practice, relational databases contain relations with duplicate rows. Most DBMS products include a feature that removes duplicate rows when necessary and appropriate. Such removal is not done as a matter of course beause it can be time-consuming and expensive.

Relational Model
Page 6 – A methodology that was developed to solve the modification problems of lists. Today almost every commercial database is based on the relational model.
Self-Describing
Page 14 – A description of the structure of the database is contained within the database itself. The contents of a database can always be determined just by looking inside the database itself.
Structured Query Language (SQL)
Page 12 – A leading technique for data definition and manipulation. You can reconstruct lists from their underlying tables, you can query for specific data conditions; you can perform computations on data in tables; and you can insert, update and delete data.
Table
Page 6 – Holds data about one and only one theme in most circumstances. If a table has two or more themes, we break it up into two or more tables.
Update
Page 7 – Change existing data
User
Page 14 – They use forms to read, enter, and query data, and they produce reports.

Glossary: A person using an application.

Web 2.0
Page 24 – Applications that allow the user to create and store data that would be subsequently displayed on a web page. Ex: Facebook, Pinterest
Table Names
Page 7 – BTW – The names appear in all capital or uppercase letters
Column Names
Page 7 – Use camel case