Answer to Question #125492 in Databases | SQL | Oracle | MS Access for kihjugyhvbnj

Question

Draw an ERD based upon the following Scenario. Also mention the attributes name and relationship between the entities.

I am the manager of a training company that provides instructor-led courses in management techniques. We teach courses, each of which has a code, a name, and a fee. Introduction to UNIX and C Programming are two of our more popular courses.
Courses vary in length from one to four days. Paul Rogers and Maria Gonzales are two of our best teachers. We need each instructor’s name and phone number. The students can take several
courses over time, and many do this. Jamie Brown from AT&T took every course we offer!
We like to have each student’s name and phone number.

Answer 1

The ER diagram of the given question is attached below.

There is three set of tables Students, Teachers and courses, all of the records have the particular set of attributes.