Term
|
Definition
unprocessed items, raw facts |
|
|
Term
|
Definition
collection of data organized in a manner that allows access, retrieval, and use of data |
|
|
Term
|
Definition
|
|
Term
|
Definition
allows users to pick and choose to obtain information |
|
|
Term
|
Definition
stores information about both the data and how it is related |
|
|
Term
|
Definition
data - tables (data files) - records (rows) - fields (columns) - byte - Bit |
|
|
Term
|
Definition
|
|
Term
|
Definition
specifies the kind of data a field can contain and how the field is used. Ex: datatype is text, so it can only contain text/numeric characters |
|
|
Term
|
Definition
uniquely identifies each record in the table |
|
|
Term
|
Definition
a column/group of columns in a relational database table that provides a link between data in two tables |
|
|
Term
|
Definition
between two database tables when one table has a foreign key that references the primary key of another table |
|
|
Term
|
Definition
requires every value of on attribute (Column) of a relation (table) to exist as a value of another attribute (column) in a different or the same relation (Table) |
|
|
Term
entity relationship diagram (ERD) data model |
|
Definition
shows what will be in the database, relationships between entites |
|
|
Term
|
Definition
something we want to track. EX: peoples names, task name |
|
|
Term
|
Definition
describes something in ways of elements, fields, files |
|
|
Term
|
Definition
a collection of computers and devices connected together via communications devices and transmission media.
| |