{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

mgt 318 - test 3 study guide

mgt 318 - test 3 study guide - Mgt 318 Exam#3 Study Guide...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Mgt 318 Exam #3 Study Guide Chapter 7 – Databases and Data Warehouse: Traditional file approach - filing with no mechanism for tagging, retrieving, and manipulating data Database approach - filing that does have a mechanism for tagging, retrieving, and manipulating data Data redundancy - duplication of data, which wastes storage space and is inefficient Data integrity - accuracy, timeliness, and relevance of data in a context Entity - any object about which an organization chooses to collect data Character - the smallest piece of data (ex. first letter of first or last name) Field - one piece of information about an entity, such as the last name or fist name of a student, or the student’s street address File - a collection of related records, such as all the records of a college’s students Database Management System (DBMS) - program used to build databases, populate them with data, and manipulate the data Database Administrator - person that is responsible for the aspects of a database Relational Model - consists of tables and data that is represented mathematically Tables - a set of data elements (values) that is organized using a model of horizontal rows and vertical columns Primary key - is the field by which records in a table are uniquely identified Composite key - a combination of two or more fields that together serve as a primary key, because it is impractical to use a single field as a primary key Foreign key - identifies a column or a set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. Join table - table with more then one thing One-to-many relationship - when a group of employees belong to only one department
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Many-to-many relationship - one department linked to many employees Object-oriented database model - uses the object-oriented approach; an object consists of both data and the procedures that manipulate the data Encapsulation - the combined storage of both data and the procedures that manipulate them Inheritance - replicating all or some of the characteristics of a previously developed object Relational operation - creates a temporary table that is a subset of the original table or tables Structured Query Language (SQL) - an international standard and is provided with most relational database management programs…easy to remember commands Schema - a plan that describes the structure of the database being designed Data Dictionary
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '08
  • Klien
  • Relational model, World Wide Web, Database management system, data Database administrator, data Data redundancy

{[ snackBarMessage ]}