freein
commented
11 years ago You decompose to much. I took the database course last period. My database is already in BCNF. I can show you on friday if you want.
One rule you don't follow is that you don't have to create a separate tables for relations if it is a many to exacty one relation. The key in my Buildings-table determines all other atributes.
But your database is also in BCNF but it leads to more data and more joins. Den 24 apr 2013 19:12 skrev "Rene Ni" notifications@github.com:
Hej, just was thinking about the database u set up, shouldnt it look diffrent? When i stick to rules i learned in databses we should have:
entities:
Buildings (_name) Entries (_xCoord, _yCoord) (maybe address as well?) Rooms (_name, xCoord, yCoord) Types (_name)
and then there would be tables for the following relationships as well:
EntrIsInBuilding(_name, _xCoord, _yCoord) Building.name Entries.xCoord Entries.yCoord
RoomIsInBuilding(_name, _name) Rooms.name Buildings.name
hasType(_name, _name) Rooms.name Types.name
This are more tables but will end up in easier searchfunctions and a cleaner code, or am i thinking a wrong way?
— Reply to this email directly or view it on GitHubhttps://github.com/drderkummer/Software-Engineering-Project/issues/6 .
drderkummer
Hej, just was thinking about the database u set up, shouldnt it look diffrent? When i stick to rules i learned in databses we should have:
entities:
Buildings (_name) Entries (_xCoord, _yCoord) (maybe address as well?) Rooms (_name, xCoord, yCoord) Types (_name)
and then there would be tables for the following relationships as well:
EntrIsInBuilding(_name, _xCoord, _yCoord) Building.name Entries.xCoord Entries.yCoord
RoomIsInBuilding(_name, _name) Rooms.name Buildings.name
hasType(_name, _name) Rooms.name Types.name
This are more tables but will end up in easier searchfunctions and a cleaner code, or am i thinking a wrong way?