Finishing Database App

[Rajarshi_Basu]

I have a building having 2 floors. Where there are 10 rooms. I want to build a database where I have

1. List of Items Category: Flooring,Wall & Column,Ceiling,Glazing,Door and Window
2. List of Rooms: R1 to R10
3. List of Items: 20 Items (say) where Items are not unique to each room. Each item has their item description and picture.

I want to search room by floor, and it should get me all the relevant details for each room by item categoy.