Data Dictionary for lab 2 - Data Dictionary Table Name...

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

View Full Document Right Arrow Icon
Table Name Attribute Name Contents dbo.uc_course course_id Course ID code call_id Course call ID code course_name Course name credits Course number of credits dbo.uc_course_section c_sec_id Course section ID code course_id Course ID code term_id Term ID code sec_num Section number f_id Faculty ID code c_sec_day Course section meeting day c_sec_time_start Course start time c_sec_time_end Course end time loc_id Location ID code max_enrl Maximum number of student enrollment dbo.uc_enrollment s_id Student ID code c_sec_id Course section ID code grade Student grade dbo.uc_faculty f_id Faculty ID code f_last Faculty last name f_first Faculty first name f_mi Faculty middle initial loc_id Location ID code f_phone Faculty phone number f_rank Faculty rank f_pin Faculty personal ID number dbo.uc_location loc_id Location ID code bldg_code Building code room Room number capacity Room capacity dbo.uc_student s_id Student ID code s_last Student last name s_first Student first name s_mi Student middle initial s_address Student address s_city Student city s_state Student state s_zip Student zip code s_phone Student phone number s_class Student class rank s_dob Student date of birth s_pin Student perdonal ID Number f_id Faculty ID code
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/02/2009 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Pennsylvania State University, University Park.

Page1 / 11

Data Dictionary for lab 2 - Data Dictionary Table Name...

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

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