Shared Flashcard Set

Details

MIS 2000 Chapter 4 Vocab
Chapter 4 Vocab
47
Management
Undergraduate 4
10/14/2013

Additional Management Flashcards

 


 

Cards

Term
Access
Definition
A popular personal and small workgroup DBMS product from Microsoft
Term
Attributes
Definition
Describe characteristics of the entity
Term
Byte
Definition
Is a character of data
Term
Crow's foot
Definition
A line on an entity-relationship diagram that indicates a 1:N relationship between two entities
Term
Crow's-foot diagram
Definition
A type of entity-relationship diagram uses a crow's foot symbol to designate a 1:N relationship
Term
Data integrity problem
Definition
Is the situation that exists when the database contains inconsistent data
Term
Data model
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
Database
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
Database application
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
DB2
Definition
A popular, enterprise-class DBMS product from IBM
Term
Enterprise DBMS
Definition
Products process large organizational and workgroup databases
Term
Entity
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
Fields
Definition
Columns are also called
Term
File
Definition
A group of similar rows or records is called a table or a
Term
Foreign Key
Definition
A column or group of columns used to represent relationships
Term
Form
Definition
Are used to read, insert, modify, and delete data
Term
Identifier
Definition
Is an attribute (or group of attributes) whose value is associated with one and only one entity instance
Term
Key
Definition
Also called a primary key. Is a column or group of columns that identifies a unique row in a table.
Term
Lost update problem
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
Maximum cardinality
Definition
The maximum number of entities that can be involved in a relationship
Term
Metadata
Definition
Are data that describes data
Term
Minimum cardinality
Definition
Constraints on minimum requirements

The minimum number of entities that must be involved in a relationship
Term
MySQL
Definition
An open source DBMS product that is license-free for most applications
Term
Normal forms
Definition
Classifications of tables according to the kinds of problems they have
Term
Normalization
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
Oracle Database
Definition
A popular, enterprise-class DBMS product from Oracle Corporation
Term
Personal DBMS
Definition
Products are designed for smaller, simpler database applications
Term
Primary key
Definition
Is a column or group of columns that identifies a unique row in a table. Also called a key.
Term
Query
Definition
A request for data from a database
Term
Records
Definition
Rows are also called
Term
Relation
Definition
A more formal name for a database table
Term
Relational databases
Definition
Databases that carry their data in the form of tables and that represent relationships using foreign keys
Term
Relationships
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
Reports
Definition
Show data in a structured context
Term
Rows
Definition
Columns or fields, in turn are grouped into
Term
SQL Server
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
Surrogate key
Definition
Unique identifier in the DBMS
Term
Table
Definition
A group of similar rows or records
Supporting users have an ad free experience!