FIGURE P$2\mathrm{.}4$ THE DEALCO RELATIONAL DIAGRAM

REGION

& REGION CODE

REGION$\_$DESCRIPT

STORE

$8$ STORE CODE

STORE NAME

STORE$\_$YTD$\_$SALES

REGION CODE

EMPLOYEE

$8$ EMP $\_$CODE EMP$\_$TITLE EMP$\_$LNAME EMP$\_$FNAME

EMP$\_$INITIAL EMP$\_$DOB JOB CODE

STORE CODE

JOB

Y JOB CODE

JOB DESCRIPTION

JOB$\_$BASE$\_$PAY

$1.$ Identify each relationship type and write all of the business rules.

$5.$ Create the basic Crow's Foot$$ERD$$for$$DealCo$.$