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 |
|
|