- #1
- 6,910
- 10,286
Hi All,
I am given this relational table
ROOM (RoomID, BuildingName, FloorNumber, NumberOfFloors).
The underline and bold mean that RoomID is the primary key.
And I am asked to show an example of how redundancies may result in inconsistencies.
This is a questions someone asked, hoping for my help, but I am stuck.
So I am not even sure of what to do. I am looking for an example, a "model" where one or more
entries are repeated which leads to inconsistencies. I am assuming for now that just one repetition
will do, so I set up a table with a repeated entry (please see attached file). I chose rooms in buildings
with the same number of rooms and same floor number.
Any ideas?
I am given this relational table
ROOM (RoomID, BuildingName, FloorNumber, NumberOfFloors).
The underline and bold mean that RoomID is the primary key.
And I am asked to show an example of how redundancies may result in inconsistencies.
This is a questions someone asked, hoping for my help, but I am stuck.
So I am not even sure of what to do. I am looking for an example, a "model" where one or more
entries are repeated which leads to inconsistencies. I am assuming for now that just one repetition
will do, so I set up a table with a repeated entry (please see attached file). I chose rooms in buildings
with the same number of rooms and same floor number.
Any ideas?