Make the entity-relationship diagram by computer and create a database for a parts warehouse. a hardware store. Each piece has a type and model that are its unique code, in addition to an attribute that allows knowing the description of each piece and the price at which we sell each part. In addition, there are parts that are made up of other parts, for example, a door is made up of a sheet of wood, a hinge and a latch. Even one piece it can be composed of other pieces that in turn they can be composed of others and so on. We have a number of warehouses from which we keep its number, description, address and the name of each warehouse shelf. Each shelf is identified by three letters. We will need to know how many pieces we have in each warehouse and know which shelves the parts are on wanted.

Make the entity-relationship diagram by computer and create a database.