I need to write the business rules for the diagram posted. Would the bottom post
ID: 3802154 • Letter: I
Question
I need to write the business rules for the diagram posted. Would the bottom post be what it is asking for?
Entities:
REGION
STORE
EMPLOYEE
JOB
Attributes:
REGION: REGION_CODE, REGION_DESCRIPTION
STORE: STORE_CODE, STORE_NAME, STORE_YTD_SALES, REGION_CODE
EMPLOYEE: EMP_CODE, EMP_TITLE, EMP_LNAME, EMP_INITIAL, EMP_DOB, JOB_CODE, STORE_CODE
JOB: JOB_CODE, JOB_DESCRIPTION, JOB_BASE_PAY
Primary Keys:
REGION_CODE is the primary key in the entity REGION
STORE_CODE is the primary key in the entity STORE
EMP_CODE is the primary key in the entity EMPLOYEE
JOB_CODE is the primary key in the entity JOB
Foreign Keys:
REGION_CODE is the foreign key in the entity STORE
STORE_CODE is the foreign key in the entity EMPLOYEE
JOB_CODE is the foreign key in the entity EMPLOYEE
Relationships:
There exists a 1:M relationship between REGION and STORE
There exists a 1:M relationship between STORE and EMPLOYEE
There exists a 1:M relationship between JOB and EMPLOYEE
FIGURE P2.4 THE DEALCO RELATIONAL DIAGRAM REGION STORE REGION CODE STORE CODE REGION DESCRIPT STORE NAME STORE YTD SALES REGION CODE EMPLOYEE EMP coDE EMP TITLE EMP LNAME EMP FNAME EMPLINITIAL EMP DOB OB CODE STORE CODE JOB JOB CODE JOB DESCRIPTION JOB BASE PAYExplanation / Answer
The above post is asking for Identifying each relationship type and write all of the business rules.
One region can be the location for many stores. Each store is located in only one region. Therefore, the relationship between REGION and STORE is 1:M.
Each store employs one or more employees. Each employee is employed by one store. (In this case, we are assuming that the business rule specifies that an employee cannot work in more than one store at a time.) Therefore, the relationship between STORE and EMPLOYEE is 1:M.
A job – such as accountant or sales representative -- can be assigned to many employees. (For example, one would reasonably assume that a store can have more than one sales representative. Therefore, the job title “Sales Representative” can be assigned to more than one employee at a time.) Each employee can have only one job assignment. (In this case, we are assuming that the business rule specifies that an employee cannot have more than one job assignment at a time.) Therefore, the relationship between JOB and EMPLOYEE is 1:M.