🛠️ Scheduled Maintenance | We’ll be undergoing scheduled maintenance and upgrades between 00:00 PST Jan 26th until 00:00 PST Jan 28th. There may be brief interruption of services in that period. We apologize for the inconvenience.

×
The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

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

Back to all questions

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

Super Learner 7 months ago
Vote Up Vote Down
0
Votes
1
Answer

Could someone please draw the ER Diagram and the Relational Schema of the employees.sql database?

1 Answer

365 Team 7 months ago
Vote Up Vote Down
0
Votes

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://365datascience.teachable.com/courses/360102/lectures/5518597
Hope this helps.
Best,
Martin

You must to answer this question.