A consulting firm maintains a database of its employees (a number of consultants) and a list of projects it has accomplished, has been developing, and is about to start. Details about the consultants and projects are given below:
o Each consultant has an employee ID, a name, address, gender, and is responsible for not more than five (5) projects.
o An address has a house number, street name, city and postcode.
o A consultant can be on a full-time or a part-time basis with the firm. A full-time consultant has an annual salary. A part-time consultant has an hourly rate and a maximum number of hours s/he can work.
o A project has a project ID, a client’s name and the cost charged by the firm to the client.
Dear customer, Unfortunately, your question requires a lot of work and cannot be done for free. Please submit it with all requirements as an assignment to our control panel and we'll assist you.