1. Refer to Problem Figure P3.10 for the following questions. (Note the database is made of 4 tables)

Business Rules

- An EMPLOYEE has only one JOB_CODE but a JOB_CODE can be held by many EMPLOYEES

- An EMPLOYEE can patriciapte in many PLANS and any PLAN can be assigned to many EMPLOYEEs

Note the M:N Relationship has been broken down into two 1:M relationshiops for which the BENEFIT Table serves as the bridging table

1a. identify the primary and foreigh keys, if there is not any, indicate None

1b. Create the ERD to show the relationship between EMPLOYEE, BENEFIT, JOB and PLAN

2. Create an ERD using Crows's Foot notation using the following requirements:

An INVOICE is witten by a SALESREP. Each sales rep can write many invoices, but each invoice is written by a single sales rep

the INVOICE is writen for a single CUSTOMER. However, each customer can have many invoices.

An INVOICE can include many detail lines (LINE), each of which describes one product bought by a customer.

The product information is stroed in a PRODCUT entitiy

The product's vendor information is found in a VENDOR entity.

3.

Suppose you are working within the framework of the conceptual model in F4.5.

Write the business rules that are reflected in it.

Identify all the cardinalites of this diagram

FIGURE P3.10 THE CH03_BENECO DATABASE TABLES Database name: Ch03_BeneCo Table name: EMPLOYEE Table name: BENEFIT Table name: JOB Table name: PLAN