General
Organized collection of information
Database
Each Row in a Database represents
Record
DBAs often use this method to access a Database
Direct Access or Manual Access
This language allow unstructured data to be searched
Markup Language (XML)
a RDMS consists of (blank) organized into (blank) and (blank)
Tables, Rows & Columns
Each column represents a separate
Field
This GUI allows users to run queries and reports without knowing SQL
Query & Report Builder
These SQL commands affect entire Database, including permissions
Data Definition Language (DDL)
This data has no rigid format & typically easier to create and store
Unstructured data
This Field must be unique in a row
Primary Key
Many software programs contain libraries of stored commands to allow Database Access
Programmatic Access
These SQL commands allow insert/update/extract of data records in a Table
Data Manipulation Language (DML)
Some benefits of RDBMS over Flat File System
Access Control, Enforce Data Types, Scalability
When a Record is linked to another Table, the Primary Key becomes a
Foreign Key
A critical function that should be performed on a regular basis
Backups
This language allows manipulation of unstructured data
NO SQL
Some common RDBMS vendors/systems are
MS SQL, Oracle, MySQL & MS Access
When 2 or more Tables are linked in a Database, this produces a
Schema
This access often happens in the background without user knowledge
Utility Access
This is the language used by a RDBMS
Structured Query Language (SQL)