Study Guides - Study Guide for Final Exam ACIS 1504 Intro to BIS This study guide is not intended to replace lecture readings or assignments The

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 w/ multiple themes Database: a set of related tables Benefits and drawbacks of databases Benefits: ad-hoc (on demand) info retrieval, relevant data is output, shared access, security, data integrity (good data/ reduces redundancy), referential integrity auto enforced- keeping tables synchronized, stored separately from the program that processes it Drawbacks: metadata (extra step), slower when dealing w/ all the data How databases differ from spreadsheets and when you would appropriately use each Spreadsheets use one theme, databases use multiple interrelated themes. Spreadsheet- grade book, list of names Database- customers and their orders How to read an ERD Cardinality marks- how many records can participate in the relationship (min located to the inside, max located to the outside) Purpose of primary and foreign keys Primary-column used to uniquely identify each row, cannot be null or blank Foreign- used to connect a record in one table with one or more records in another Terms: Metadata: data that describe data Anomaly: redundant data Table/Entity: a collection of records for a single subject Record: rows in a table Field/Attribute: columns in a table Value: text stored for one record in a specific field Normalization: transforming a table into a normal form to remove duplicated data and other problems 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, planning Sales and Marketing- sales forecasting, lead tracking, product management, customer management
Background image of page 1

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

View Full DocumentRight Arrow Icon
Accounting/Finance- general ledger maintenance, financial reporting, accounts receivable, accounts payable, budgeting, cash management, treasury management, cost accounting Manufacturing- production planning, production scheduling, manufacturing operations, raw materials and goals in progress inventory management Operations- order entry, order management, customer service, finished goods inventory
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.

This note was uploaded on 10/04/2011 for the course ECON 2006 at Virginia Tech.

Page1 / 5

Study Guides - Study Guide for Final Exam ACIS 1504 Intro to BIS This study guide is not intended to replace lecture readings or assignments The

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