Term
|
Definition
| A rectangular array of data. |
|
|
Term
|
Definition
| Each column of the table contains the same type of information. |
|
|
Term
|
Definition
| Each row containing all the information about one entry in the database. |
|
|
Term
| Database Management Software (DBMS) |
|
Definition
| Used to create databases, examples of DBMS include Access and Oracle. |
|
|
Term
|
Definition
| Holds the contents of a table as a rectangular array and is similar to a two-dimensional array; it has rows and columns. |
|
|
Term
|
Definition
| A data table that is bound to a list box can transfer information automatically into the list box. |
|
|
Term
|
Definition
| Used to uniquely identify each record. |
|
|
Term
|
Definition
| Every record must have an entry in the primary-key field and two records cannot have the same entry in the primary-key field. |
|
|
Term
| Rule of Referential Integrity |
|
Definition
| Each value in the foreign key must also appear in the primary key of the other table. |
|
|
Term
| Structured Query Language (SQL) |
|
Definition
| A very powerful language developed for use with relational databases that allows for the request of specified information from a database and allows displaying of information from the database in a specific format. |
|
|
Term
|
Definition
| Displays the values for an entire view in a table format similar to the table displayed by Database Explorer, can also be used to add, modify, and delete records from a database. |
|
|
