Convert textual description to entity-relationship diagram


Problem

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 may be 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, the height, the width and the depth. For a chair you track if it is a rolling chair. For a sofa you track its height and its width and depth.

Convert the above textual description to an entity-relationship diagram in UML notation. And make sure you have a primary key for the strong entity.

Request for Solution File

Ask an Expert for Answer!!
Software Engineering: Convert textual description to entity-relationship diagram
Reference No:- TGS03225426

Expected delivery within 24 Hours