Schema $2$ Building Schema $(25$ Points$)$

You work for BUILD IT NOW contracting company and your bid was just accepted by Smalltown to

build a housing development. The housing development consists of $4$ streets. There are $0$ to many houses

on each street. The floor plan layout of the houses to be built are all exactly the same. There is no

variation in the number of rooms, no variation in the floor plan. A street has a street name which is unique

within Smalltown. Each house on a street has a unique street number corresponding to the street name.

Each house in a development contains exactly $8$ rooms. Each room contains a location $($within the house$)$

and a name. The location of the room uniquely identifies the room within the house and can have the

value from $1$ to $8.$ However, the location is only unique when considering the house that the room is part

of$.$ A room is classified as a bedroom, a bathroom or a common room. A room can be classified as only $1$

type of room. A specific room type can be associated with many different rooms in the house. Each room

has a collection of furniture. Each furniture has a furniture type, a color and a location $($in the room$).$ A

furniture location is represented as freeform text. Furniture pieces can be moved from one room to

another, this means the location will change when the furniture piece is moved. The furniture types are:

sofa, chair, bookcase. A furniture can have only $1$ furniture type but there may be many instances of a

furniture type in a room. For each bookcase you track the number of shelves it has, its height, its width

and its depth. For a chair you track if it is a rolling chair. For a sofa you track its height, its width and its

depth.