|
pkuchaliya
Starting Member
49 Posts |
 Posted - 2008-09-17 : 09:06:15
|
| Hi to all,Please help me,I have designed the university management system database. i have problem to design the table for lecture time table.i have two option one iscreate the table master and transaction tables to store the time table detail likemaster tables details areMaster_time_table: store the main time table with the detail like lecture number ,day name,room number,which faculty take the lecture and teach which subjects of particular course.master_lecture_table: store the total number of lecture taken in a day like 7 or 8 lecture.Master_day_table: store the days detail means store their name like sunday,monday etc.Master_room_table: store the total room number in the university where the lecturer can take the lecutreMaster_faculty_table: store the faculty id ,faculty name with their teaching subjectMaster_subject_table:store the subject and their idMaster_course_table:-store the master course details.like b.tech,mcastructure areMaster_course_table:-Master_time_table: time_table_id,course_id,lecture_id(foreign key master_lecture_table),day_id(foreign key Master_day_table),room_id(foreign key Master_room_table), faculty_id(foreign key master_faculty_table),subject_id(master_subject_table)master_lecture_table: lecture_id,lecture_nameMaster_day_table: day_id,day_nameMaster_room_table: room_id,room_nameMaster_faculty_table: faculty_id,faculty_name,subject_idMaster_subject_table: subject_id,subject_nameMaster_course_table:-course_id,course nameand the other option is to make the table of each day which store the room number ,faculty id, subject id,lecture number,and course id,likeMonday:- course_id,room_no,faculty_id,subject_id,lecture_numbertuesday:- course_id,room_no,faculty_id,subject_id,lecture_numberwednesday:- course_id,room_no,faculty_id,subject_id,lecture_numberthrusday:- course_id,room_no,faculty_id,subject_id,lecture_numberfriday:- course_id,room_no,faculty_id,subject_id,lecture_numbersatday:- course_id,room_no,faculty_id,subject_id,lecture_numbersunday:- course_id,room_no,faculty_id,subject_id,lecture_numbernow please tell me what method is best , i m using sql server 2005Please help mepankaj |
|
Database table creation problem, help