Question

Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and the renewal date for that certification should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. 0 Some employees will not have dependents, while others will have many dependents.

Answer 1

Crows Foot ERD of TWo-Bit Drilling Company

• The circumstance is that organization holds the data of representative and protection wards in which a worker can have more than one ward or no ward however all the wards ought to be snared with just a single worker.
• The representative table contains all data of worker and the protection subordinate table contain data of worker's needy.
• A few representatives are examiners which contains the extra information of date of accreditation and confirmation recharging date.
• The EMPLOYEE table contains EMP_NO, EMP_NAME, EMP_DATEHIRED, EMP_TITLE, EMP TYPE and EMP SSN as traits.
• The INSURANCE_ DEPENDENT table contains subordinate EMP_NO, DEPENDENT_NAME, DEPENDENT_DOB and DEPENDENT_RELATIONSHIP (relationship of ward and worker).
• One Employee can be identified with at least 0 Dependents however any Dependent is identified with just a single Employee.
• EMP_TYPE is the subtype discriminator which tells the event of INSPECTOR.

The Attached file Show the Crow Foot ERD