Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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).
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 numberStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started