63 you should include all columns and should include

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: ll columns and specify the primary and foreign keys. BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 64 Designing a Record Structure (cont (cont’d) Designing Record Structure Designing a Record Structure Student Info. Student Record Header and Trailers Method STDNUM Name Course1 Course2 57151511 It is a method to represent a repeating group of ti attributes as a number of columns. The Student The Student Record table uses the method to store the courses being the courses being taken by a student. S. Johnston Comm437 Comm439 56162910 P. Warran Comm437 Comm439 45515116 L. Jeff Jeff STDNUM Name Comm497 Eng400 STDNUM Student Info. Course 57151511 Comm437 57151511 S. Johnston 57151511 Comm439 56162910 P. Warran 57151511 Comm497 45515116 L. Jeff 56162910 Comm437 Enrollment • What are the problems with the Student Record table? BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo Enrollment STDNUM Course Credit Grade The process of 57151511 57151511 Comm437 3.0 80 S. Johnston refining a 56162910 57151511 Comm439 3.0 81 P. Warran record 45515116 57151511 Comm497 3.0 78 L. Jeff structure in structure in 56162910 Comm437 3.0 81 order to 3.0 Student Info. 56162910 Comm439 81 reduce data STDNUM Name redundancies redundancies Course Credit 57151511 S. Johnston STDNUM Course Grade is Comm437 3.0 56162910 P. Warran 57151511 Comm437 80 Normalization Comm439 3.0 45515116 45515116 L. Jeff Jeff 57151511 Comm439 81 (S Slid (See Slides Comm497 3.0 78 Enrollment 57151511 Comm497 #81-99) Course • What are the problems with the first Enrollment table? STDNUM Course3 Name What happens if the credits of Comm 437 changes to 1.5? 65 BUSI 335 Association Pattern: The Line-Item Pattern Line Pattern Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 66 Association Pattern: The Line-Item Pattern (cont’d) Line Pattern (cont How many entities can you identify? id BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 67 BUSI 335 Copyright...
View Full Document

This document was uploaded on 03/04/2014 for the course COMM 335 at The University of British Columbia.

Ask a homework question - tutors are online