Implement this database schema in MySQL/SQL:

• Dept(dname);

• Faculty(fid, name, rank, DeptName, foreignkey(Deptname) references to Dept(dname));

• Student(name, sid, standing, facultyID, foreignkey(facultyID) references to Faculty(fid));

• Course(number, title, DeptName, foreignkey(DeptName) references to Dept(dname));

• Can-teach(facultyID, cNumber, Deptname, foreignkey(facultyID) references to Faculty(fid), foreignkey(cNumber, Deptname) references to Course(number, DeptName);

• Class(schedule, semester, section#, room, cNumber, facultyID, DeptName, foregnkey(cNumber, DeptName) references to Course(number, dname), foreignkey(facultyID) references to Faculty(fid));

• enrolled-in(grade, sid, section#, semester, cNumber, DeptName, foreignkey(studentID) references to Student(sid), foreignkey(section#,semester,cNumber,DeptName) references to Class(section#,semester,number,dname);