answer the following questions in the world documentations feel free to ask when it is not clear. thanks

answer the following questions in the world documentations feel free to ask when it is not clear.

thanks


Please only answer the following questions 1,2,3,4,5,6,7, and 8 thanks.
HW#1
(NOTE: You may make any reasonable assumptions but you have to state them clearly)
[1] Please draw an ERD based on following description.
A painter can paint many paintings; each paining is painted by one painter. A gallery
can have many paintings. A painting can be exhibited by a gallery.
[2] Please draw an ERD based on following description.
Each department has many professors assigned to it. A professor is belongs to one
department. Among professors, some chair a department. A department must have only one
chair. And no professor is required to accept the chair position. Therefore, DEPARTMENT
(Name) is optional to PROFESSOR (ID, Name, hired-year, rank) in the “chairs” relationship.
[3] Please draw an ERD based on following description.
Each professor (ID, Name, rank) may teach up to four classes, each is a section
(Section ID) of a course (course ID, title). A professor may also be on a research contract and
teaches no classes at all. Each class is taught by a professor.
[4] Please draw an ERD based on following description.
An employee can learn many skills; each skill can be learned by many employees and
these skills could have different skill levels (let say from L1 to L5).

Purchase answer to see full
attachment