•You work in a consulting company and are asked to design a database to keep track of employee and their skill areas relating to the services that the company offers.
•Information stored about each employeeincludes employee ID (a seven letter id), employee name, education (High School, BS, MS, and Doctorate), and their multiple skill areas(the skill area, e.g. project manager, and the level (junior, practitioner, senior, or expert).
•An employee many have many skill areas. A separate table keeps track of the skills areas and the projects that they have been used on, Project information includes client name, start date, end date, and a list of the employees who worked on the project.
Make sure include all the necessary attributes for each entity. Mark the unique identifier and cardinality (using ER-Assistant).
0 comments