Shared Flashcard Set

Details

MIS
Management Information Systems
16
Management
Undergraduate 2
12/07/2007

Additional Management Flashcards

 


 

Cards

Term
Database
Definition
a self describing collection of integrated records
Term
Record
Definition
also called rows…groups of columns in a database table
Term
Attributes
Definition
characteristics of an entity…for example: attributes of an order would be order number, order date, sub total, taxes, total, etc.
Term
Relation
Definition
the more formal name for a database table
Term
Entity-relationship Diagram
Definition
a type of diagram used by database designers to document entities and their relationships to each other.
Term
Entity-relationship Data model
Definition
the most popular technique for creating a data model. Developers describe the content of a database by defining the entities that will be stored and the relationships among those entities
Term
Database Management System (DBMS)
Definition
a program used to create, process, and administer a database
Term
Knowledge Management System (KMS)
Definition
an information system for storing and retrieving informational knowledge, whether that knowledge is in the form of data, documents, or employee know-how.
Term
MySQL
Definition
a popular open-source DBMS product that is license free for most applications
Term
SQL Server
Definition
a popular enterprise-class DBMS product from microsoft
Term
Oracle
Definition
a popular enterprise-class  DBMS product form Oracle Corp.
Term
Metadata
Definition
data that describes data
Term
1:N 1:1 N:M
Definition
Maximum cardinalities. 1:N- one to many. 1:1- one to one. N:M- many to many.
Term
Primary Key
Definition
Key- a column or group of columns that identifies a unique row in a table.
Term

Normalization

Definition
the process of converting poorly structured tables into two or more well-structured tables
Supporting users have an ad free experience!