Draw ER diagram using Chen's notation for this scenario. Digital Transformation Consultants (DTC) delivers a range of

Draw ER diagram using Chen's notation for this scenario.

  

Transcribed Image Text:

Digital Transformation Consultants (DTC) delivers a range of consultancy services to its customers in Australia. DTC headquarter is in Sydney and has branches in all Australian states. The company employs various experts in a range of fields. Each employee has a unique Employee ID. Other attributes associated with the employee include first name, last name, gender, address, telephone (landline and/or mobile), personal address, date of birth, and the person an employee reports to. Employees could be employed on a long-term basis (full-time or part-time) or on a contract basis. Each employee works in one department only and it can possess a number of skills. Each employee is assigned to a job class (e.g., Manager, Administrative, Information Technology, etc.). Each of the job classes has a different salary. The Information Technology (IT) employees have an additional attribute called University Degree, and the year when it is obtained. Some employees in the IT Department have an additional attribute called TAFE Certification, and the date the certificate is issued. You can assume that DTC has to record this extra information only if the employee is in that job class. For administrative purposes, DTC is divided into departments (IT, Human Resources, Marketing, Finance, etc.) headed by department managers. Each department has a Department ID and other attributes, such as Department Name, Department Description, and Manager ID. Each of the projects is carried-out in an inter-disciplinary way; i.e. for each project a project team is selected, grouping employees from different departments, and a Project Manager (also an employee of the company) is appointed who is entirely and exclusively responsible for the control of the project, quite independently of the company's hierarchy. The following is a brief statement of some facts and policies adopted by the company: A department may participate in none/one/many projects. At least one department participates in a project. Project teams consist of at least one member. An employee may be engaged in none/one/many projects. DTC has a number of branches in Australia. Each office can employ people in different departments. Each branch would hold at least one receptionist and another employee who belongs to a department. All receptionists belong to the Administration Departments. Some offices hold employees in all departments, while others do not hold employees in all the departments (e.g., Perth's office might not have employees - Digital Transformation Consultants (DTC) delivers a range of consultancy services to its customers in Australia. DTC headquarter is in Sydney and has branches in all Australian states. The company employs various experts in a range of fields. Each employee has a unique Employee ID. Other attributes associated with the employee include first name, last name, gender, address, telephone (landline and/or mobile), personal address, date of birth, and the person an employee reports to. Employees could be employed on a long-term basis (full-time or part-time) or on a contract basis. Each employee works in one department only and it can possess a number of skills. Each employee is assigned to a job class (e.g., Manager, Administrative, Information Technology, etc.). Each of the job classes has a different salary. The Information Technology (IT) employees have an additional attribute called University Degree, and the year when it is obtained. Some employees in the IT Department have an additional attribute called TAFE Certification, and the date the certificate is issued. You can assume that DTC has to record this extra information only if the employee is in that job class. For administrative purposes, DTC is divided into departments (IT, Human Resources, Marketing, Finance, etc.) headed by department managers. Each department has a Department ID and other attributes, such as Department Name, Department Description, and Manager ID. Each of the projects is carried-out in an inter-disciplinary way; i.e. for each project a project team is selected, grouping employees from different departments, and a Project Manager (also an employee of the company) is appointed who is entirely and exclusively responsible for the control of the project, quite independently of the company's hierarchy. The following is a brief statement of some facts and policies adopted by the company: A department may participate in none/one/many projects. At least one department participates in a project. Project teams consist of at least one member. An employee may be engaged in none/one/many projects. DTC has a number of branches in Australia. Each office can employ people in different departments. Each branch would hold at least one receptionist and another employee who belongs to a department. All receptionists belong to the Administration Departments. Some offices hold employees in all departments, while others do not hold employees in all the departments (e.g., Perth's office might not have employees -

Answer rating: 100% (QA)

ER diagram using ... View the full answer