Use MySQL Workbench to create an EER diagram for a database named school_db that stores information about professors, students, and their courses. A table for professors that includes name, department, and birth date.A table for students that includes name, start date, and major.A table for classes that includes course name, course code, professor, start date, and end date.Pick smart data types for all of the required fields. Don’t forget about primary keys.You will need a fourth table for joining purposes. You need to figure out what gets joined with this fourth table.All four tables must show the correct relationships (i.e the primary keys and foreign keys need to match up) Screen capture (or Export an image) of your diagram and paste the image below.

An Entity–relationship model (ER model) describes the structure of a database with the help of a…

Answered: Use MySQL Workbench to create an EER…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Use MySQL Workbench to create an EER diagram for a database named school_db that stores information about professors, students, and their courses.

A table for professors that includes name, department, and birth date.
A table for students that includes name, start date, and major.
A table for classes that includes course name, course code, professor, start date, and end date.
Pick smart data types for all of the required fields. Don’t forget about primary keys.
You will need a fourth table for joining purposes. You need to figure out what gets joined with this fourth table.
All four tables must show the correct relationships (i.e the primary keys and foreign keys need to match up)

Screen capture (or Export an image) of your diagram and paste the image below.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions