Reference no: EM13861018

Problem 1: Create a Crow's Foot ERD to include the following business rules for the ProdCocompany:

a. Each sales representative writes many invoices.

b. Each invoice is written by one sales representative.

c. Each sales representative is assigned to one department.

d. Each department has many sales representatives.

e. Each customer can generate many invoices.

f. Each invoice is generated by one customer

Problem 2: Write the business rules that are reflected in the ERD shown in Figure. (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always read from the "1" to the "M" side, regardless of the orientation of the ERD components.)

Problem 3:

The database tables

Table name: TRUCK

Primary Key:TRUCK_NUM

Foreign Key:BASE_CODE, TYPE_CODE

Table name: BASE

Primary Key:BASE_CODE

Foreign Key:none

Table name: TYPE

Primary Key:TYPE_CODE

Foreign Key:none

Use the clatabase shown in above to answer given problems

1: For each table, indentify the primary key and the foreign key(s). If a table does not have a foreign key. write None

2: Do the tables exhibit entity Integrity? Answer yes or no. and then explain your answer.

3: Do the table exhibit referential Integrity? Answer yes a no. and then explain your answer, Write NA (Not Applicable) if the table does not have a foreign key.

4: Identify the TRUCK table's candidate key(s).

5: Foe each table identify a superkey and a secondary key.

6: Create the ERD for this database.