AIS Final Study Guide mid

AIS Final Study Guide mid - AIS Study Guide Class 14: Ch. 3...

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

View Full Document Right Arrow Icon
AIS Study Guide Class 14: Ch. 3 (Access) COBIT- Control Objectives for Information and related Technology IT processes in 4 domains: - Planning & organization - Acquisition & implementation - Delivery & support - Monitoring & evaluation Database Accounting Systems Advantages: Disadvantages: - Reduce data storage costs - Greater hardware requirements - Eliminate data redundancy - Database software itself - Eliminate data inconsistencies - Employing database administrator - Avoid duplicate processing - System operation critical - Make data independent of applications - Incorrect data entry corrupts work - Centralize data management - Territorial disputes over ownership - Centralize data security - Make report modification and updates easier - Provide ad hoc query capabilities - Facilitate cross-functional data analysis - Permit multiple users simultaneous data access - Facilitate add, delete, and update maintenance tasks Business Activity Classifications: Service Firms - Income and expenses Merchandising Firms -Income, cost of goods sold, and expenses Manufacturing Firms - Income, cost of goods sold, cost of goods manufactured (director materials, director labor, manufacturing overhead), and expenses Database Management System (DBMS) Def. a file management system that can store and manage different types of records within one integrated system Def . a Database is the physical implementation of particular set of records, and the DBMS controls access to those records Def . a relational DBMS consists of tables containing data whose contents are related to one another through the data content of the tables
Background image of page 1

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

View Full DocumentRight Arrow Icon
Functions of DBMS: - Efficient data maintenance: storage, update, and retrieval* - User-accessible catalog - Concurrency control - Transaction support - Recovery services - Security and authorization services - Integrity facilities A relational database is a collection of relations. - A table is an example of a relation. Terminology: Formal Term Common Term Alternative Relation table file Tuple row record Attribute column field Normalization: First Normal Form - No repeating groups Second Normal Form - must be in 1st normal form - each nonkey attribute depends on the ENTIRE primary key, not just part of it - this rule applies only to composite primary keys (more than one primary key) Third Normal Form - must be in 2 nd normal form - No transitive dependencies (ex. attribute B determines C and C determines D) Structured Query Language (SQL): Select - determines which rows included in dynaset - Rows selected by selection criteria Project - determines which columns included in dynaset Join - Combines data from different tables - Equijoin : rows from 2 tables are placed next to each other (concatenated) on matching join values and the join column appears only once in the result - joins two tables with a common column in which each is the primary key - Outer join: combines rows from two or more tables on the join column, but rows that do not match on the join column are included in the result Recursive relationships: when rows of a table are related to rows in the same table
Background image of page 2
Class 15: Ch. 4 (Access)
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 13

AIS Final Study Guide mid - AIS Study Guide Class 14: Ch. 3...

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

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