DATABASE

STAFF Table

AID table

POSITION Table

PLAN Table

1. Identify primary key and foreign keys for each table and write none if dont have foreign key.

2. Illustrate Crow's Foot ERD to show relationships among STAFF,AID,POSITION and PLAN

3. Did the tables exhibit referential integrity? Explain answer. Write none if table dont have foreign key

STAFF_NO 14 STAFF_NAME POSITION_CODE Zawawi 2 15 1 Maximus Amirul 16 1 17 Harris 3 20 Dexter 2 STAFF_NO PLAN_CODE 2 15 15 16 3 1 17 1 17 17 4 20 3 POSITION_CODE 1 POSITION_DESCRIPTION REGISTRAR SYSTEM ANALYST 2 3 CLERK PLAN_CODE 1 2 PLAN_DESCRIPTION MEDICAL STOCK PURCHASE UNIT TRUST DENTAL 4