Answered step by step
Verified Expert Solution
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
for this given ERD
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 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