Term
|
Definition
| A popular personal and small workgroup DBMS product from Microsoft |
|
|
Term
|
Definition
| Describe characteristics of the entity |
|
|
Term
|
Definition
|
|
Term
|
Definition
| A line on an entity-relationship diagram that indicates a 1:N relationship between two entities |
|
|
Term
|
Definition
| A type of entity-relationship diagram uses a crow's foot symbol to designate a 1:N relationship |
|
|
Term
|
Definition
| Is the situation that exists when the database contains inconsistent data |
|
|
Term
|
Definition
| A logical representation of the data in a database that describes the data and the relationships that will be stored in the database |
|
|
Term
|
Definition
| Is a self-describing collection of integrated records |
|
|
Term
| Database administration (DBA) |
|
Definition
| The management, development, operation, and maintenance of the database so as to achieve the organization's objectives |
|
|
Term
|
Definition
| Is a collection of forms, reports, queries, and application programs that each use DBMS to process a database |
|
|
Term
| Database application system |
|
Definition
| Applications, having the standard five components, that make database data more accessible and useful. |
|
|
Term
| Database management system (DBMS) |
|
Definition
| Is a program used to create, process, and administer a database |
|
|
Term
|
Definition
| A popular, enterprise-class DBMS product from IBM |
|
|
Term
|
Definition
| Products process large organizational and workgroup databases |
|
|
Term
|
Definition
| Is something that the users want to track |
|
|
Term
| Entity-relationship (E-R) data model |
|
Definition
| Is a tool for constructing data models |
|
|
Term
| Entity-relationship (E-R) diagrams |
|
Definition
| A type of diagram used by database designers to document entities and their relationships to each other |
|
|
Term
|
Definition
|
|
Term
|
Definition
| A group of similar rows or records is called a table or a |
|
|
Term
|
Definition
| A column or group of columns used to represent relationships |
|
|
Term
|
Definition
| Are used to read, insert, modify, and delete data |
|
|
Term
|
Definition
| Is an attribute (or group of attributes) whose value is associated with one and only one entity instance |
|
|
Term
|
Definition
| Also called a primary key. Is a column or group of columns that identifies a unique row in a table. |
|
|
Term
|
Definition
| An issue in multi-user database processing in which two or more users try to make changes to the data but the database cannot make all those changes because it was not designed to process changes from multiple users |
|
|
Term
| Many-to-many (N:M) relationships |
|
Definition
| Relationships involving two entity types in which an instance of one type can relate to many instances of the first |
|
|
Term
|
Definition
| The maximum number of entities that can be involved in a relationship |
|
|
Term
|
Definition
| Are data that describes data |
|
|
Term
|
Definition
Constraints on minimum requirements
The minimum number of entities that must be involved in a relationship |
|
|
Term
|
Definition
| An open source DBMS product that is license-free for most applications |
|
|
Term
|
Definition
| Classifications of tables according to the kinds of problems they have |
|
|
Term
|
Definition
| Is a process of converting a poorly structured table into two or more well-structured table |
|
|
Term
| Object-relational database |
|
Definition
| A type of database that stores both object-oriented programming objects and relational data |
|
|
Term
| One-to-many (1:N) relationships |
|
Definition
| Relationships involving two entity types in which an instance of one type can relate to many instances of the second type |
|
|
Term
|
Definition
| A popular, enterprise-class DBMS product from Oracle Corporation |
|
|
Term
|
Definition
| Products are designed for smaller, simpler database applications |
|
|
Term
|
Definition
| Is a column or group of columns that identifies a unique row in a table. Also called a key. |
|
|
Term
|
Definition
| A request for data from a database |
|
|
Term
|
Definition
|
|
Term
|
Definition
| A more formal name for a database table |
|
|
Term
|
Definition
| Databases that carry their data in the form of tables and that represent relationships using foreign keys |
|
|
Term
|
Definition
| An association among entities or entity instances in an E-R model or an association among rows of a table in a relational database |
|
|
Term
|
Definition
| Show data in a structured context |
|
|
Term
|
Definition
| Columns or fields, in turn are grouped into |
|
|
Term
|
Definition
| A popular, enterprise-class DBMS product from Microsoft |
|
|
Term
| Structured Query Language (SQL) |
|
Definition
| Is an international standard language for processing a database |
|
|
Term
|
Definition
| Unique identifier in the DBMS |
|
|
Term
|
Definition
| A group of similar rows or records |
|
|
