Query a database for empty tables
Assuming faculty_assets and faculty are joined by the fac_id field, you could use something like 

$sql="DELETE FROM faculty WHERE fac_id='" . (int)$fac_id . "' AND NOT EXISTS 
        (SELECT * FROM faculty_assets WHERE fac_id = '".(int)$fac_id . "')";