Learning Goal: I’m working on a computer science question and need an explanation and answer to help me learn.
Consider the scenario from In-class 2 where you designed an ER diagram for a company, convert the design (ER diagram) into relational schemas, and capture as many of the constraints as possible.
=======================================================Note: Please use the sample solution for this assignment.=======================================================Grading rubric=============The solution includes schemas from both entity sets and relationship sets.Each schema has correct attributes.Each schema has its primary key correctly specified.The solution uses appropriate relation schema notation.