Exam 3 Study Guide

Exam 3 Study Guide - Study Guide for Final Exam ACIS 1504...

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

View Full Document Right Arrow Icon
Study Guide for Final Exam ACIS 1504 – Intro to BIS This study guide is not intended to replace lecture, readings or assignments. The real value of the study guide comes from the process of evaluating and completing it. You should understand the following topics: Purpose and definition of a database Purpose- keep track of data with multiple themes Definition- Collections of records, Related tables , Metadata Benefits and drawbacks of databases Benefits ad-hoc information retrieval: on demand only relevant data is output shared access security data integrity- good data- minimize redundancy referential integrity can be enforced automatically- keeping your tables synchronized(referential integrity) data independence – data is stored separately from the programs that process it Drawbacks Metadata- extra step to construct this Databases are slower when you work with all of it How databases differ from spreadsheets and when you would appropriately use each Spreadsheets do not relate tables, but databases do. You use spreadsheets when you only need to produce one report, but you use databases when you need to produce multiple reports. How to read an ERD Look at ppt slide Purpose of primary and foreign keys Primary Key- uniquely identifies each row/record in a table Foreign Key- connects a row in one table with one or more rows in another Terms: Metadata- data about data; Defining the structure of the data on access Anomaly- bad data Table/Entity-   set of related records; object to which you want to store data Record- set of related fields; row in a table; instance of the entity Field/Attribute- column in a table; characteristic of the object Value- text that is stored for one record in a specific field; contents of a cell Normalization- the process of converting a poorly structured table into two or more well- structured table
Background image of page 1

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

View Full DocumentRight Arrow Icon
Using MIS Chapter 7 (pages 248-277) – IS within Organizations You should understand the following topics: Basic functions of the five functional systems Human Resource- Recruiting, Training, Compensation, Evaluation, and Planning Manufacturing- Production Planning, Production Scheduling, Manufacturing Operations, and Raw Materials and Goods in Progress Inventory Management Sales & Marketing- Sales Forecasting, Lead Tracking, Product Management and Customer Management Operations- Order Entry, Order Management, Customer Service, and Finished Goods Inventory Management Accounting & Finance- General Ledger Maintenance, Financial Reporting, Accounts Receivable, Accounts Payable, Budgeting, Cash Management, Treasury Management, and Cost Accounting Problems with functional systems Data duplication, data inconsistency Disjointed applications Limited information and lack of integrated information Isolated decisions Increased expense
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.

Page1 / 7

Exam 3 Study Guide - Study Guide for Final Exam ACIS 1504...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online