Answered step by step
Verified Expert Solution
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
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 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started