Term
|
Definition
| the organization-wide view of the entire database. It lists all data elements in the database and the relationship between them. |
|
|
Term
| data definition language (DDL) |
|
Definition
| a database management system language that ties the logical and physical views of the data together. It is used to build the data dictionary, initialize or create the database, describe the logical views for each individual user or programmer, and specify any limitations or constraints on security imposed on database records or fields. |
|
|
Term
|
Definition
| Contains information about the structure of the database. For each data element, there is a corresponding record in it describing that element. |
|
|
Term
| data manipulation language (DML) |
|
Definition
| a database management system language used for data maintenance, which includes such operations as updating, inserting, and deleting portions of the database. |
|
|
Term
|
Definition
| accessing information stored in a data warehouse through statistical analysis or artificial intelligence techniques to “discover” unhypothesized relationships in the data. |
|
|
Term
|
Definition
| an abstract representation of the contents of a database. |
|
|
Term
| data query language (DQL) |
|
Definition
| a high-level English-like command language that is used to interrogate a database. |
|
|
Term
|
Definition
| very large databases that contain both detailed and summarized data for a number of years and that are used for analysis rather than transaction processing. |
|
|
Term
|
Definition
| the person responsible for coordinating, controlling, managing the data in the database. |
|
|
Term
| database management system (DBMS) |
|
Definition
| a specialized computer program that manages and controls the data and interfaces between the data and the application programs |
|
|
Term
|
Definition
| the combination of the database, the database management system, and the application programs that access the database through the database management system. |
|
|
Term
|
Definition
| If Ned withdraws from all his classes and you eliminate all three of his rows from the table, then you will no longer have a record of Ned. If Ned is planning to take classes next semester, then you probably didn’t really want to delete all records of him. |
|
|
Term
|
Definition
| The primary key uniquely identifies a specific row in the table, so it cannot be null, and it must be unique for every record. |
|
|
Term
|
Definition
| an individual user’s or application program’s view of a subset of an organization’s database. |
|
|
Term
|
Definition
| an attribute appearing in one table that is itself a primary key of another table. Used to link table. |
|
|
Term
|
Definition
| What happens if you have a new student to add, but he hasn’t signed up for any courses yet? Or what if there is a new class to add, but there are no students enrolled in it yet? In either case, the record will be partially blank. |
|
|
Term
|
Definition
| A low-level view of the entire database describing how the data are actually stored and accessed. It includes information about record layouts, definition, addresses, indexes, and so forth. |
|
|
Term
|
Definition
| the manner in which the programmer or user conceptually organizes ,views, and understands the relationship among data items. |
|
|
Term
|
Definition
| the process of following the guidelines for properly designing a relational database that is free from all anomalies. |
|
|
Term
|
Definition
| the way data are physically arranged and stored in the computer system. |
|
|
Term
|
Definition
| the attribute or combination of attributes, that uniquely identifies a specific row in a database table. |
|
|
Term
|
Definition
| a document that illustrates the arrangement of items of data and input, output, and file records |
|
|
Term
| referential integrity rule |
|
Definition
| A foreign key must either be null or correspond to the value of a primary key in another table |
|
|
Term
|
Definition
| the tables used to store data in a relational database |
|
|
Term
|
Definition
| a database model in which all data elements are logically viewed as being stored in the form of two-dimensional tables called relations. In these tables, each row represents a unique entity or record. Each column represents a field where the records attributes are stored. The tables serve as the building blocks from which the data relationship can be created. |
|
|
Term
|
Definition
| a database management system that uses the relational data model developed by Dr. E.F. Codd in 1970. |
|
|
Term
|
Definition
| a language that simplifies report creation. Typically, users need only specify which data elements they want printed and how the report should be formatted. |
|
|
Term
|
Definition
| a description of the type of data element that are in the database, the relationship among data elements, and the structure or overall logical model used to organize and describe the data. |
|
|
Term
|
Definition
| a set of individual user views of portions of the database. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Suppose Alice Simpson changes her phone number. You need to make the change in three places. If you fail to change it in all three places or change it incorrectly in one place, then the records for Alice will be inconsistent. |
|
|
