gp 03 sn 08 to do - 3nf

gp 03 sn 08 to do - 3nf - STUDENT Student ID First Name...

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

View Full Document Right Arrow Icon
Gp 03 Sn 08  To Do – 3NF STUDENT (STUDENT ID , FIRST NAME, LAST NAME) COURSE (COURSE ID , COURSE NAME, INSTRUCTOR ID) INSTRUCTOR (INSTRUCTOR ID , INSTRUCTOR NAME) GRADE (STUDENT ID , COURSE ID , INSTRUCTOR ID, GRADE) STUDENT Student ID First Name Last Name 456836741 Elissa  Johannson 398759837 Sean  O'Reilly COURSE Course ID Course Name Instructor ID GWU101 Group Wise  User RTS IHAS303 In-house  accounting  system MCH IHIS202 In-house  inventory  system RTS OFF505 Office 2003 MCH WIN404 Windows  XP RTS INSTRUCTO R Instructor ID Instructor Name RTS Roy Brown MCH Meg C.  Harris GRADE Student ID Course ID Grade 456836741 GWU101 78 456836741 IHAS303 82 398759837 IHIS202 73 398759837 OFF505 76 398759837 WIN404 85
Background image of page 1

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

View Full DocumentRight Arrow Icon
STUDENT (STUDENT ID , FIRST NAME, LAST NAME) COURSE (COURSE ID , COURSE NAME, INSTRUCTOR ID) INSTRUCTOR (INSTRUCTOR ID , INSTRUCTOR NAME) SCR ACCOUNTING SYSTEM (PAYMENT RECEIPT ID , COURSE PRICE, STUDENT  PAYMENTS, STUDENT ACCOUNT BALANCE, COURSE ENROLLED)
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: STUDENT Student ID First Name Last Name 170827324 David Renalds 484317812 Robert Ford 783269841 Josephine Cheung COURSE Course ID Course Name Instructor ID OFF505 Office 2003 MCH WIN404 Windows XP RTS IHAS303 In-house accounting system MCH INSTRUCTOR Instructor ID Instructor Name RTS Roy Brown MCH Meg C. Harris SCR ACCOUNTING SYSTEM Payment Receipt ID Course Price Student Payments Student Account Balance Course Enrolled 1065 $ 500.00 $ 500.00 $ - Yes 1067 $ 500.00 $ 250.00 $ 250.00 No 1069 $ 500.00 $ 500.00 $ - Yes COURSES ENROLLED Student ID Course ID Instructor ID Payment Receipt ID Course Enrolled 170827324 OFF505 MCH 1065 Yes 484317812 WIN404 RTS 1067 No 783269841 IHAS303 MCH 1069 Yes...
View Full Document

This note was uploaded on 08/02/2011 for the course IT 5460 taught by Professor Prof during the Spring '11 term at Kaplan University.

Page1 / 3

gp 03 sn 08 to do - 3nf - STUDENT Student ID First Name...

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

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