Anyone will help me to solve this? this is about ER diagram and some other stuff about database.
This is the exercise:
"Project a DataBase to support a architectural studio which offers its customers proposals refurbishment.
Each component of furniture ( table , chairs , ... ) is characterized by a code identification , by a name ,a brief description , the date of commencement of production and dimensions . For each component we want to retain color information on which is available and materials . Each component may be Available in many many colors and materials. For each component we want to know with the firm that has produced . In particular, for each firm we want to know the name, address, telephone, fax , name and surname of the person of reference. Each component can be produced by many firms and each firm can produce more component used by architectural studio.
Database we also want to retain information that studio furniture projects carries. For each project , we want to memorize data for client which the project is implemented ( name , surname ,tax code , address ) , the date on which the project is implemented and the architect that realized the project ( name, surname and contact) . Each customer can have many projects ordered by him , and each project performed by an architect.
Each project consists of a set of projects environment . For each environment , we want to know the name ( kitchen ,Salon , ... ) , dimensions (length , width , height ) , the color of the floor and the walls . Finally we want to know the components of furniture that provides project to put in any environment with the appropriate color and materilain and that the firm has produced."
To define a scheme E / R that describes the whole information content of the system, illustrated with clarity all data solutions . The scheme shall be completed with the relevant attribute for each entity and relation . It should be explained clearly Cardinality constraints and participation in every relation .
After it is built schemes E / R be given answers to these questions through relational algebra and language
1- Find the address of the clients who have commissioned the project with code "ASR42"
2- Find the name and surname of the architects who have designed "Kitchen facilities"
3- Find all projects that have used only components "Desks"