Author |
Topic |
Mohamed Faisal
Yak Posting Veteran
51 Posts |
Posted - 2013-08-18 : 09:15:58
|
I am given the CounsellingCase table:CounsellingCase(CaseNum, StartDate, EndDate, CaseDetail, StudentNumber, StudentName, StudentContact, CounsellorName, CounsellorContact, sessionDate, sessionStartTime, sessionDuration, sessionOutcome)My functional and multi-valued dependencies are:CaseNum-->StartDate,EndDate,CaseDetail,StudentNumber StudentNumber-->StudentName,StudentContact CounsellorName-->CounsellorContact CaseNumr-->-->CounsellorNameMy propose candidate key(s) for the table:sessionDate,sessionStartTime and CounsellorNamehow do I normalise the table to BCNF and 4NF by applying the BCNF approach?Thanks |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-08-18 : 09:24:37
|
Something like thisTable dbo.CasesCaseNum, StartDate, EndDate, CaseDetail, StudentNumberTable dbo.StudentsStudentNumber, StudentName, StudentContactTable dbo.CounsellorsCounsellorName, CounsellorContactTable dbo.SessionsSessionStartTime,SessionEndTime,SessionDuration,SessionOutcome,CounsellorName,CaseNum Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
Mohamed Faisal
Yak Posting Veteran
51 Posts |
Posted - 2013-08-18 : 09:37:29
|
Hi SwePeso,Do i have to indicate the PK and FK. cause there is two tale depend on caseNum.Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2013-08-18 : 13:48:15
|
Table dbo.CasesCaseNum (pk), StartDate, EndDate, CaseDetail, StudentNumber (fk)Table dbo.StudentsStudentNumber (pk), StudentName, StudentContactTable dbo.CounsellorsCounsellorName (pk), CounsellorContactTable dbo.SessionsSessionStartTime,SessionEndTime,SessionDuration,SessionOutcome,CounsellorName (fk),CaseNum (fk) Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
|
|