Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Each house in a development contains 8 rooms. Each room contains a location (within the house) and a name. The location of the room uniquely

image text in transcribed

Each house in a development contains 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. 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 type, a color and a location (in the room). 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. Each bookcase you track the number of shelves it has, the height, its width and its depth. For a chair you track if it is a rolling chair. For a sofa you track its height and its width and depth

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions