Use entity Relation diagram to illustrate a recursive relationship. Discuss the three quality of a Candidate...

Transcribed Image Text:

Use entity Relation diagram to illustrate a recursive relationship. Discuss the three quality of a Candidate Key to be selected as primary key. Read the following case and answer Question that follows. A Company is organized into departments: Each dept. has a unique number, unique Name and a particular employee that manages it. We keep track of the start date when an employee began managing the dept. A department may have several locations. A department control a number of projects, each of which has a unique number and a single location. We store each employees name, Social security Number address, gender and Date of Birth. An employee is assigned one dept., but may work on several projects which are not necessarily controlled under the same department. We keep truck of the current number of hours per week that an employee work on each project We want to keep track of the dependants of each employee for insurance purposes. We keep each dependants name, Gender, Data of Birth and relationship with the employee. Required i. Identity all dominant entities. ii. Design an ER diagram to represent the case. Use entity Relation diagram to illustrate a recursive relationship. Discuss the three quality of a Candidate Key to be selected as primary key. Read the following case and answer Question that follows. A Company is organized into departments: Each dept. has a unique number, unique Name and a particular employee that manages it. We keep track of the start date when an employee began managing the dept. A department may have several locations. A department control a number of projects, each of which has a unique number and a single location. We store each employees name, Social security Number address, gender and Date of Birth. An employee is assigned one dept., but may work on several projects which are not necessarily controlled under the same department. We keep truck of the current number of hours per week that an employee work on each project We want to keep track of the dependants of each employee for insurance purposes. We keep each dependants name, Gender, Data of Birth and relationship with the employee. Required i. Identity all dominant entities. ii. Design an ER diagram to represent the case.