1 - Database Intro

The course and instructor data are dependent only on

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: te key. PK BUSI 335 • The Grade is dependent on the entire key entire key. PK Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 97 PK Are there any nonkey attributes that are dependent of the other nonkey attributes? other nonkey attributes? BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo Step 3: Remove Transitive Dependencies (cont’d) Dependencies (cont 98 Normalized Tables for Student Enrollment Database Enrollment Database PK PK PK The instructor attributes (Off Hrs Loc Tel Hrs, Loc, Tel Num) are defined not by the course th th that the instructor teaches, but by the instructor. PK 1: N PK BUSI 335 PK Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 99 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 100 Summary For discussions For discussions … • Problems with the Traditional File-Based • What are the costs and risks of the are the costs and risks of the System System database approach? • Database Management Systems • What are the roles of accountants in information systems development? • Advantages of the Database Approach of the Database Approach • Entity Relationship Diagram • Data Normalization Process BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 101 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 102...
View Full Document

Ask a homework question - tutors are online