Question

Projects inc. is an engineering firm with approximately 50 employees A database is required to keep track of all employees, their skills, projects assigned and departments worked in. Every employee has a unique number assigned by the firm, required to store her or his name and data of birth. If an employee is currentty married to another employee of Projects tnc. the data of the marriage and who the employee is married to must be stored. Howeer no record of marmiage is required if the spouse is not also an employee Each employee is given a job tite. An employee does only one type or job at any gven time, and we only need to store information for the emplaxces current job. There are 11 different departments each with a unique name. An employee can report to only one department. Each department has a phone number, To purchase various types of equipment each department deals with different vendors. A vendor usually supplies equipment to many departments. We must store the name and address of each vendor and the date of the last meeting between a department and a vendor. Many employees can work on a project. An employee can work on many projects but can be assigned to at most one project in a given city For each city, we are interested in the state and population An employee can have many skills. Each skill is assigned a number, and we must also description of each skt Projects are identified by project numbers and we must store the estimated cost of each project

Answer 1