Answered step by step
Verified Expert Solution
Link Copied!

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).

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases And Python Programming MySQL MongoDB OOP And Tkinter

Authors: R. PANNEERSELVAM

1st Edition

9357011331, 978-9357011334

Students also viewed these Databases questions

Question

What are Measures in OLAP Cubes?

Answered: 1 week ago

Question

How do OLAP Databases provide for Drilling Down into data?

Answered: 1 week ago

Question

How are OLAP Cubes different from Production Relational Databases?

Answered: 1 week ago