FIT9132 PASS Week5

what kind of anomalies does this table have?

• Insert Anomaly

• Update Anomaly

• Delete Anomaly

Given a relation:

DRONE_SERVICE (drone_id, ds_date_serviced, emp_no)

drone_id, ds_date_serviced -> emp_no

What is this dependency?

• Full Dependency

• Partial Dependency

• Transitive Dependency

Given a relation:

AC_REC (stu_no, unit_no, ar_year, ar_semester, unit_name, ar_grade)

unit_no -> unit_name

What is this dependency?

• Full Dependency

• Partial Dependency

• Transitive Dependency

Given a relation:

PART (part_no, part_name, cat_code, cat_name, part_stock, part_sell)

cat_code -> cat_name

What is this dependency?

• Full Dependency

• Partial Dependency

• Transitive Dependency

HOSPITAL (hosp_id, hosp_name, hosp_phone)
DOCTOR (hosp_id, dr_id, dr_name, dr_mobile)
PATIENT (pat_id, hosp_id, dr_id, pat_name, pat_dob)

How many PKs and FKs do the relations have?

• 6PKs and 3FKs

• 3PKs and 1FK

• 6PKs and 1FKs

• 3PKs and 3FKs