Translate the following E$-$R schema into an appropriate given set of SQL tables outlined below. Make sure to includes any$/$all appropriate $($i$)$ primary keys, $($ii$)$ unique keys, $($iii$)$ NOT NULL constraints, $($iv$)$ FOREIGN KEY constraints, and $($v$)$ ON DELETE$/$UPDATE options.