in this project, you will use the following information to develop a database system. there is an abc company, which purchases parts from vendors to produce some products. the company has several departments, marketing sites, and parts supply vendors. 1. for each department, department id and department name will be recorded. 2. people in the company can be divided into three types -- employees, customers, and potential employees. each person can belong to more than one type. each person in the company has the following attributes: personal id, name (last name, first name), age (below 65), gender, address (address line 1, address line 2, city, state, zip code), and phone number (one individual may have more than one phone number). for customers, their preferred salespeople were recorded in the system. rank and title (e.g., ceo, principle, partner, etc.) will be recorded for employees. 3. each company employee must have only one direct supervisor, while each supervisor can have several supervisees. one employee can work for one or more departments at different times. but at one time, one employee can only work for one department. the system needs to record each shift's start and end times among different departments for one employee.