DBA Ch 1: Introduction to Database Management

atrribute
A characteristic or property of an entity; also
called a field or column.
column
A characteristic or property of an entity; also
called an attribute or a field.
data file
A file used to store data about a single entity.
It’s the computer counterpart to an ordinary paper file
you might keep in a file cabinet, an accounting ledger,
and so on. Such a file can be thought of as a table.
data independence
The property that lets you change
the structure of a database without requiring you to
change the programs that access the database; examples
of these programs are the forms you use to interact with
the database and the reports that provide information
from the database.
database
A structure that can store information about
multiple types of entities, the attributes of these entities,
and the relationships among the entities.
database administrator
A structure that can store information about
multiple types of entities, the attributes of these entities,
and the relationships among the entities.
database administration (DBA)
The individual or group that is responsible for a database.
database design
The process of determining the content
and structure of data in a database in order to support
some activity on behalf of a user or group of users.
database management systems (DBMS)
The process of determining the content
and structure of data in a database in order to support
some activity on behalf of a user or group of users.
entity
A person, place, object, event, or idea for which
you want to store and process data.
entity-relationship (E-R) diagram
A graphic model for database design in which entities are represented as rectangles and relationships are represented as either arrows or diamonds connected to the entities they relate.
field
A characteristic or property of an entity; also called an attribute or a column
form
A screen object you use to maintain, view, and print data from a database
integrity
A database has integrity if the data in it satisfies all established integrity constraints.
integrity constraint
A rule that must be followed by data in a database
one-to-many relationship
A relationship between two entities in which each occurrence of the first entity is related to many occurrences of the second entity, and each occurrence of the second entity is related to at most one occurrence of the first entity
redundancy
Duplication of data, or the storing of the same data in more than one place
relationship
An association between entities
security
The prevention of unauthorized access to a database