week 10

docx

School

Holmes Colleges Melbourne *

*We aren’t endorsed by this school

Course

HS2021

Subject

Information Systems

Date

Jan 9, 2024

Type

docx

Pages

Uploaded by trushen14patel

Tutorial Week 10 Question A: Create the ERD to show the relationship between EMPLOYEE and JOB. Answer: ERD – Relationship Question B: Create the ERD using Crow’s Foot notation to show the relationships among EMPLOYEE, BENEFIT, JOB, and PLAN. Answer : Crow’s foot notation

Tutorial Week 10 Question C: For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the assigned space provided. For table 1: EMPLOYEE EMPLOYEE ( EMP_CODE , EMP_LNAME, JOB_CODE) Primary Key: EMP_CODE Foreign Key: JOB_CODE For table 2: BENEFIT – this table is week entity BENEFIT (EMP_CODE, PLAN_CODE) Primary Key: None Foreign Key: EMP_CODE Foreign Key: JOB_CODE For table 3: JOB JOB ( JOB_CODE , JOB_DESCRIPTION) Primary Key: JOB_CODE Foreign Key: NONE For table 4: PLANE PLANE ( PLANE_CODE , PLAN_DESCRIPTION) Primary Key: PLAN_CODE Foreign Key: NONE

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

week 10

Related Documents