Hi All,(adsbygoogle = window.adsbygoogle || []).push({});

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?

**Physics Forums | Science Articles, Homework Help, Discussion**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Redundancy and Inconsistence in Relational DB

**Physics Forums | Science Articles, Homework Help, Discussion**