AFM241 Study Guide - Midterm Guide: Cheque Fraud, Financial Statement, Internal Control
30 May 2018
School
Department
Course
Professor
Can remove partial dependency from a table by ensuring that “non-key” fields (fields
without candidate keys) are fully dependent on the value of a primary key
Problem exist in tables that have a composite primary key
Third normal form (3NF)
Requires a table that already meets 1NF doesn’t have any transitive dependencies
Requires that data in all “non-key” fields are fully dependent on the value of the primary key
In table 5.4, one can specify the school as well as course prerequisites and anti-requisites
based on course number. Course ID is neither a primary key nor a candidate key
5.5 Business Value: Accounting/Finance Angle
Following case shows how databases and databases analysis tools can be used to support auditing
within a firm
find more resources at oneclass.com
find more resources at oneclass.com
