Part I. Reverse Engineering

Map the following set of tables to an ER diagram:

Student(sname, major, stno)

Enroll (stno, sect_no)

Course(book, cname, sect_no, Prof_id, bldg_num)

Instructor(Prof_id, iname, bldg_num)

Building(occupancy, supervisor, bldg_num, sqft)

Lives_in(bldg_num, stno, Rm_num)

Dependent(dname, stno, school)

Dependent_hobbies(dname, stno, hobby)