Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedPass Screenshot the diagram here:

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions