9117 SubCon database.zipHi,
I am an engineering manager working in a construction of highrise building. I want to make a database for the agencies that are working on the project as "Subcontractor". I have tried to build the database which is attached but I am unable to get satisfactory answer from the query I build.
Just an overview to what I want from this database and the complexity of the structure.
- There are multiple subcontractors working on the project.
- There are multiple type of work that a subcontractor can do.
- Each work done by a subcontractor can either be new work or repair work.
- As the project is construction of high rise building, a subcontractor is working on multiple floor
- Each floor is further divided in to two wings, namely A-wing and B-wing. Each wing of the building has number of apartments (Flat No)
- On a floor multiple subcontractors are working for either same type of work or different type of work.
- A subcontractor is given a work order to do a specific work. Example: Work Order No. 123 is given to a subcontractor "X" to do gypsum plaster. Work Order No. 456 is given to a subcontractor "Y" for the same work i.e. gypsum plaster.
- Subcontractor "X" can do multiple type of work like gypsum plaster, brick masonry, block masonry, etc. same way subcontractor "Y" can do multiple work.
The objective of this database is;
- To track on which location which subcontractor has worked.
- To know the quantity of work done by all the subcontractor.
- Most importantly to keep track that no two subcontractor claims to have worked on the same location for the same type of work.
In fact the need arise to make this database is because many subcontractors has submitted the bill claiming payment for the same type of work and at the same location. This can happen if one contractor has done new work like doing gypsum plaster on block masonry but after electrical installation work which caused some damage to the plaster than some other contractor has done the repairing work. However in such case the repair quantity should be definitely less than new work but it is seen that repair quantity is more than new work claimed by few subcontractor.
Till now all the measurement are recorded by the site engineer in measurement book (M.B) filled manually. Subcontractors has taken the advantage of this manual record as no data can be compared at the same time. As a result the project has run in to loss and is under financial instability.
I request forum members to guide me to prepare this database with their experience and expertise.Attachment 30147
I have attached two trial files in this thread for reference.