1 - Database Intro

Id busi 335 copyright 2009 10 ym cheung william tan

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: 2009-10 Y.M. Cheung, William Tan and Carson Woo 68 Sample Sample Data Model: Highline University University The College Report College Report • The Highline University [HU] database will Highline University [HU] database will track such entities as: – Colleges – Departments – Faculty – Students • We have gathered a set of HU reports that will be the source documents for a data model BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 69 BUSI 335 Data Model from the College Report Model from the College Report Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 70 The Department Report Department Report This is a 1:N is 1:N relationship BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 71 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 72 The The DEPARTMENT / PROFESSOR Relationship: The DEPARTMENT / PROFESSOR Relationship: Alternate Model 1: Using an N:M Relationship Alternate Model 2: Using a 1:N Relationship This is an N:M is an N:M relationship BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo This is a 1:N is 1:N relationship 73 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 74 The DEPARTMENT / PROFESSOR Relationship: The DEPARTMENT / PROFESSOR Relationship: Alternate Model 4: Using a Association Pattern and a 1:N Relationship Alternate Model 3: Using an Association Pattern This is a 1:1 relationship This is an association is an association pattern BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo This is an association is an association pattern 75 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 76 The Department Major Report The Department Major Report BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo Data Model with STUDENT Entity Model with STUDENT Entity 77 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 78 Data Model with Advises Relationship Relationship The Student Accep...
View Full Document

Ask a homework question - tutors are online