1a.txt

a large structured set of persistent data

four components of any database system

a collection of meaningful information related to the database

uniquely identify each record in the table

combo of attributes that can be uniquely used to identify a database record

fields in a relational table that match the primary key from one column to the primary key of another table

data remains in the database unchanged and does not change until acted upon

data in the database interacts and cooresponds with other data

data in the database has the ability to be accessed and/or manipulated by multiple users

data in the database has the following characteristics

database software is usually referred to as what?

individual that writes programs that use or allow access to the database with a specific intended purpose

the primary individuals responsible for the technical implementation and maintenance of the database on a design and physical level

most valuable asset of a database system

the immunity of applications to change in storage structure and access technique

raw data in rows and columns

databases which use relationships between independent entities (data

person responsible for deciding which data is stored in the database and the manner in which it is stored there

commands a dbms can do

commands used to manipulate and interact with the data in a database

mechanism for recovery and ensures 2 people are not trying to update a piece of the database at the same time

ongoing record of all data reflecting the information defining the database

ensures all functions are done efficiently

collection of databases that can be operated and managed separately

basic component of a SQL database

persistent objects that store the information contained within a database

the displays that are returned from a query

these can be powerful tools in the hands of a skilled dba

4 levels DAd operates at