Draw an ERD for the following situation (Batra et al., 1988).Also, develop the list of words for qualifiers and classes that you use to form attribute names. Explain why youchose the words on your list. Also, draw a data model forthis situation using the tool you have been told to use inyour course. Projects, Inc., is an engineering firm with approximately 500 employees. A database is required to keep track ofall employees, their skills, projects assigned, and depart-ments worked in. Every employee has a unique numberassigned by the firm and is required to store his or hername and date of birth. If an employee is currently mar-ried to another employee of Projects, Inc., the date ofmarriage and who is married to whom must be stored;however, no record of marriage is required if anemployee's spouse is not also an employee. Eachemployee is given a job title (e.g., engineer, secretary,and so on). An employee does only one type of job atany given time, and we only need to retain informationfor an employee's current job
There are 11 different departments, each with aunique name. An employee can report to only 1 department. Each department has a phone number. To procure various kinds of equipment, each department deals with many vendors. A vendor typically sup-plies equipment to many departments. We are required to store the name and address of each vendor and the date of the last meeting between a department and avendor.