Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please complete this data dictionary in the given format for this given ERD 4.0 Data Dictionary Contents Data Type Format Range Table Name Attribute Name

Please complete this data dictionary in the given format

image text in transcribed

for this given ERD

image text in transcribed

4.0 Data Dictionary Contents Data Type Format Range Table Name Attribute Name Required PK or FK FK Referenced Table 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

Data Analysis Using SQL And Excel

Authors: Gordon S Linoff

2nd Edition

111902143X, 9781119021438

More Books

Students also viewed these Databases questions

Question

What is operatiing system?

Answered: 1 week ago