Solid is your answer for the day
Answer:
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
Least privilege is the data access principle that ensures to unnecessary access to data exists by regulation members so that can perform only minimum data manipulation necessary. The principle of least privilege or as called as POLP is the run-through of controlling access to the minimal level that will permit normal functioning. The norm of least privilege interprets to giving people the lowermost level of user right that they can have and still do their jobs. The principle is also functional to things other than people as well as programs and processes. It is created in the US department of defense in the 1970’s and aimed to limit the potential damage of any security breach either accidental or malicious.