Question: Pass Screenshot the diagram here: For this assignment, you will need to create the ERD for the company database, and then complete the following worksheet

Pass Screenshot the diagram here: For this assignment, you will need toPass Screenshot the diagram here:

create the ERD for the company database, and then complete the following

worksheet based on that ERD. - Create the ERD using MySQL Workbench.

- Ensure all entities and attributes have the same names as on

the Company DB Handout - Each table should have the appropriate PK

For this assignment, you will need to create the ERD for the company database, and then complete the following worksheet based on that ERD. - Create the ERD using MySQL Workbench. - Ensure all entities and attributes have the same names as on the Company DB Handout - Each table should have the appropriate PK - Each table should have the appropriate FK(s) creating the relationships shown on the Company DB Handout. - Use the NOT NULL constraint for attributes that should have data - No lines on the ERD should cross or go under an entity - Once you have the ERD completed, insert a screenshot of the ERD below. NB you will need to submit the mub file too. - For each entity on the ERD, fill out the appropriate fields in the worksheet. - Indicate if the entity is strong or weak. If weak, indicate if ID-dependent or not. - For each relationship on the ERD, fill out the appropriate fields in the worksheet. - List each entity in the relationship - The entity whose PK is used in the relationship should be Entity 1 - For Entity 1, list the PK that is used in the relationship - The entity whose FK is used in the relationship should be Entity 2 - For Entity 2, list the FK that is used in the relationship - List the cardinality and participation of each entity in the relationship - List the business rules for each relationship - Indicate if the relationship is identifying or not Entities Relationships 2 \begin{tabular}{|l|l|ll|l|} \hline Entity 1: & PK: & Optional & Mandatory & One Many \\ \hline Entity 2: & FK: & Optional Mandatory & One Many \\ \hline Business Rule 1 & & & \\ \hline Business Rule 2 & & \\ \hline Identifying Non-identifying \end{tabular} 3 \begin{tabular}{|l|l|ll|l|} \hline Entity 1: & PK: & Optional & Mandatory & One Many \\ \hline Entity 2: & FK: & Optional & Mandatory & One Many \\ \hline Business Rule 1 & & & \\ \hline Business Rule 2 & & & \\ \hline Identifying Non-identifying \end{tabular} 4 \begin{tabular}{|l|l|ll|l|} \hline Entity 1: & PK: & Optional & Mandatory & One Many \\ \hline Entity 2: & FK: & Optional Mandatory & One Many \\ \hline Business Rule 1 & & & \\ \hline Business Rule 2 & & \\ \hline Identifying Non-identifying \end{tabular} 5 \begin{tabular}{|l|l|ll|l|} \hline Entity 1: & PK: & Optional & Mandatory & One Many \\ \hline Entity 2: & FK: & Optional Mandatory & One Many \\ \hline Business Rule 1 & & & \\ \hline Business Rule 2 & & \\ \hline Identifying Non-identifying \end{tabular} 6 \begin{tabular}{|l|l|ll|l|} \hline Entity 1: & PK: & Optional Mandatory & One Many \\ \hline Entity 2: & FK: & Optional Mandatory & One Many \\ \hline Business Rule 1 & & \\ \hline Business Rule 2 & & \\ \hline Identifying Non-identifying \\ \hline \end{tabular} \begin{tabular}{|l|l|ll|l|} \hline Entity 1: & PK: & Optional & Mandatory & One Many \\ \hline Entity 2: & FK: & Optional & Mandatory & One Many \\ \hline Business Rule 1 & & \\ \hline Business Rule 2 & \\ \hline Identifying Non-identifying \\ \hline \end{tabular} 8 \begin{tabular}{|l|l|ll|l|} \hline Entity 1: & PK: & Optional & Mandatory & One Many \\ \hline Entity 2: & FK: & Optional & Mandatory & One Many \\ \hline Business Rule 1 & & \\ \hline Business Rule 2 & & \\ \hline Identifying Non-identifying \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!