IST210 LAB1

IST210 LAB1 - 1 Data Dictionary Table Name dbo.uc_course...

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

View Full Document Right Arrow Icon
1. Data Dictionary Table Name Attribute Name Contents Type Format Range Req. PK or FK FK Ref. Table dbo.uc_course course_id Course ID code Numeric (6,0) 9 0-9 Y PK call_id Course call ID code VARCHAR (10) XXX 999 A-Z 0-9 course_name Course name VARCHAR (25) Xxxxxxxx A-Z a-z credits Course number of credits Numeric (2,0) 9 0-9 dbo.uc_course_section c_sec_id Course section ID code Numeric (6,0) 999 0-9 Y PK course_id Course ID code Numeric (6,0) 999999 0-9 Y FK dbo.uc_course_section term_id Term ID code Numeric (6,0) 999999 0-9 Y FK dbo.uc_term sec_num Section number Numeric (2,0) 99 0-9 Y f_id Faculty ID code Numeric (6,0) 999-9999 0-9 FK dbo.uc_faculty c_sec_day Course section meeting day VARCHAR (10) XXXXXX A-Z c_sec_time_start Course start time DATE AND TIME yyyy-mm-dd h:m:s 0-9 c_sec_time_end Course end time DATE AND TIME yyyy-mm-dd h:m:s 0-9 loc_id Location ID code Numeric (6,0) 999999 0-9 FK dbo.uc_location max_enrl Maximum number of student enrollment Numeric (4,0) 9999 0-9 Y dbo.uc_enrollment
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 Penn State.

Page1 / 4

IST210 LAB1 - 1 Data Dictionary Table Name dbo.uc_course...

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