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 |
|
Anarking
Starting Member
13 Posts |
 Posted - 2007-05-03 : 08:40:54
|
| Hi there, How would I go about doing this question?Give functional dependencies for the table SE(SNo,ENo,EName,City,Country) with primary key (SNo,ENo) such that 1) SE is in 1NF and not in 2NF 2) SE is in 2NF and not in 3NF 3) SE is in 3NF and not in BCNF Explain your answers. You can use functional dependency diagrams for illustrationWould I say something like EName -> City, CountryEno -> ENameSNo -> ENo |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-03 : 08:56:52
|
| http://en.wikipedia.org/wiki/Database_normalizationor you want us to do your homework?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
Anarking
Starting Member
13 Posts |
Posted - 2007-05-03 : 09:17:44
|
| Im asking if im on the right track, not for someone to do it for me.So far I haveSE(Sno, ENo, EName, City, Country)1. Eno -> EName, City, Country SnE(SNo, ENo) Employee(ENo, EName, City, Country)2. EName -> City -> Country SnE(SNo, ENo) Employee(ENo, EName) EmpAddress(EName, City, Country)3. City -> Country Sne(SNo, ENo) Employee(ENo, EName) EmpAddress(EName, City) Location(City, Country) |
|
|
|
|
|
|
|
|
Functional Dependiencies