Fundamentals of Database Systems

Create ERD based on the following tables. The underlines attributes are primary keys. The links are connection between primary keys and foreign keys

EMPLOYEE FNAMEMINITLNAMESSNBDATEADDRESS SEX SALARY SUPERSSN DNO DEPARTMENT DNAME DNUMBER MGRSSN MGRSTARTDATE DEPT LOCATIONS DNUMBER DLOCATION PROJECT PNAME PNUMBER PLOCATION DNUM WORKS ON ESSN PNO HOURS DEPENDENT ESSN DEPENDENT NAME SEX BDATE RELATIONSHIP