Last answered:

12 Jul 2020

Posted on:

28 Jun 2020

0

What does the Employees DB look like as a ER Diagram and Relational Schema?

Could someone please draw the ER Diagram and the Relational Schema of the employees.sql database?
1 answers ( 0 marked as helpful)
Instructor
Posted on:

12 Jul 2020

0

Hi Edwin!
Thanks for reaching out.
Please accept my apologies for the delayed response.
You can do that in several ways.
You can click on File/New Model and use the left pane to add tables of interest.
Alternatively, you can select Database/Reverse Engineer and follow the instructions to obtain an EER Diagram.
Finally, we have provided a *.pdf file containing the relational schema for the employees table. You can find it below the following video from the course. https://learn.365datascience.com/courses/sql/select-from Hope this helps.
Best,
Martin

Submit an answer