MGST 217 Study Guide - Final Guide: Audit Risk, Dependent And Independent Variables

• School: University of Calgary
• Department: Management Studies
• Course: MGST 217
• Professor: Cameron Welsh

Document Summary

Allows each record in a table to be unique from all the other records in the table: compound key. A primary key that uses more than one field to be unique: foreign key. Allows tables to be linked to each other in relationships: table. A single row or item in a collection of data: field/attribute. A characteristic about a single item: database. Self-describing collection of integrated records/ collection of related tables: erd. Asking a question and having the database return relevant information: qbe. When the database program displays a blank record with a space for each field. You can then enter conditions for each field that you want to be included in the query. A data summary tool commonly used in spreadsheets to visualize and sort data. Statistical process for estimating the relationships among variables. The focus is on the relationship between a dependent variable and one or more independent variables (or "predictors": y=mx+b.