Question: Write SQL commands for the given ERD to create and implement the data structure and objects. Also include the use of triggers and stored procedures

Write SQL commands for the given ERD to create and implement the data structure and objects. Also include the use of triggers and stored procedures for data manipulations (if any).

Write SQL commands for the given ERD to create and implement the

EMERGENCY CONTACT EMPLOYEE EMERGENCY PK Relative ID PK EMPLOYEE EMERGENCY_id relative_phone number generated by FK Relative_ID Relative_Name FK Employee_ID Relationship with employee provide FK Branch Code Employee_EPF number Employee PK Employee_ID EMPLOYEE DEPARTMENT JOB Name assigned PK EMPLOYEE_DEPARTMENT_ID PK Employee EPF number DOB FK Employee_ID Employee_Hired date Employee_identity Card Number FK Dept_Code report to Employee_Position Employee_Nationality Employee_Bank account 0 FK Employee_EPF number assigned Employee_Type DEPARTMENT PK Dept_code FT PT Dept_Name Dept_Phone extension Dept_Manager FULL_Time PART_Time FK Branch_Code PK.FK2 Employee_ID PK.FK2 Employee ID FT_Overtime_Hours PT_Overtime_Hours Basic Salary BRANCH PK Branch_code Branch_Address Branch Office phone number

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!