Upgrade to remove ads
Only $2.99/month

DBI DDS15 Using Applications & Relational Database Technology

Terms in this set (12)

Application software
Program that gives a computer instructions that provide the user with tools to accomplish a task
System software
Program that interacts with the hardware in the computer
Row
An entry in a table, consisting of values for each appropriate column.
Primary key
The set of mandatory columns within a table that is used to enforce uniqueness of rows and that is normally the most frequent means by which rows are accessed.
Table
An arrangement of data in rows and columns.
Foreign key
A column or set of columns that refers to a primary key in the same table or another table.
Relational database
Collections of objects or relations, set of operators to act on those relations, and data integrity for accuracy and consistency.
Field
Intersection of a row and column
Data manipulation language (DML)
Used to modify the table data by entering, changing, or removing rows
Data definition language (DDL)
Creates, changes, and removes data structures from the database
Transaction control (TCL)
Used to manage the changes made by DML statements
Data control language (DCL)
Used to give or remove access rights to the database and the structures within it
THIS SET IS OFTEN IN FOLDERS WITH...