Database Concepts
Referential Integrity Constraints
Referential integrity is a database concept that ensures that relationships between tables remain consistent. When one table has a foreign key to another table, the concept of referential integrity states that you may not add a record to the table that contains the foreign key unless there is a corresponding record in the linked table. It also includes the techniques known as cascading update and cascading delete, which ensure that changes made to the linked table are reflected in the primary table. DBMS then enforces these rules.
Related Tables
Tables that are joined in a relationship using a common field
ID Column
The default field Access creates to serve as the primary key field for all new tables.
Database Users
The fourth component of a database system, employ a database application to keep track of things.
Database Table
a collection of related records that contain fields to organize data
Structured Query Language (SQL)
an international standard language for PROCESSING A DATABASE
Concurrency
condition of being in more than one state at a time
Null Values
incomplete values
Self-describing
means that a database contains, within itself, a description of its contents
Enterprise-class Database System
A DBMS product capable of supporting the operating requirement of large organizations.
Personal Database System
A DBMS product intended for use by an individual or small workgroup.
Database
A collection of related tables and other structures
Database Management System (DBMS)
A computer program used to create, process, and administer the database.
Relational Database
A database that represents data as a collection of tables in which all data relationships are represented by common values in related tables
Database Application
A set of one or more computer programs that serves as an intermediary between the user and the DBMS
Modification Problems
Caused by making changes to a list. (updating a value in a list/ deleting a row)
Metadata
Data about the structure of a database.
Modification Actions
Insert, update, delete
Relational Model
stores information in the form of logically related two-dimensional tables