Note: If the yellow Message Bar appears when you open a file, you must click on "Enable Content" button.
The task for the "Construction firm" database. Develop an information system. Construction firm. A construction company builds various buildings. For all types of buildings, a variety of materials are required in various quantities in accordance with their design and estimate. At different stages of the construction of the building there are different teams (for example, brigades of fitters, masons, plasterers, etc.). By making a schedule of work, the firm varies the composition of the brigades. Workers can be assigned to different teams. One and the same worker can have several specialties, so he can include in turn in different teams. The size of the brigade depends on the size of the building and the requirements imposed on it. That is, brigades are made, based on the requirements of a particular building. In addition, for each team working on the construction of a particular building, a team leader is appointed.
A worker can be a foreman in one brigade and then work in other teams as a simple worker. The database should contain a schedule of work for each building, information about which of the workers in which team is assigned to different buildings and what materials and in what quantities are used in the construction of different buildings.
In order to counter copyright infringement and property rights, we ask you to immediately inform us at firstname.lastname@example.org the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)