Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ProatSql1
Starting Member
1 Post |
 Posted - 2009-11-15 : 08:13:57
|
| Hi am new to this forum and also learning sql.I was doing a project that i have to normalize timetable so please i just need someone to check if am right or wrong for what have done so far.Thank youthis are the columns for the timetabledeptcodemodule1title1module2title2module3title3group1group2group3group4group5typedaynostartfinishweekslecturer1lecturer2lecturer3lecturer4lecturer5lecturer6lecturer7lecturer8room1room2room3This is my first normal formdeptIDdeptcodemoduletitle3grouptypedaynostartfinishweekslecturerroomThis is my second normal form and i created seperate tables for emFirst tabledeptIDdeptcodegroupdaynoweekssecond tablemoduleIDmoduletitlethird tableLecturerIDLecturer type start finishPlease tell me if am right or wrong and the type columns hold values for the type of lecture if it is a class,test or lecture |
|
|
|
|
|
Normalization