Please convert figure 4.9 into relational schemas. In the table, the primary key and foreign keys (arrows) must be identified.

Frame) Minit Lname Ssn Bdate Sex (No Street (Apt no City (State Zip Name PERSON Address OFphone Salary Class Foffice College Degree Wear ADVISOR STUDENT Degrees Class 5 COMM TTEE GRAD STUDENT Title No GRANT Agency St date MINOR KN Start MAOR SUPPOR Time Grade BELONGS REGISTERED M INSTRUCTOR RESEARCHER CHAIRS N TRANSCRIPT TEACH CURRENT SECTION atr Current r and Year Current year SECTION Qtr DEPARTMENT Year Dname Office CS Dphone CD COLLEGE DC COURSE Figure 8.9 Cname Coffice Cdesc An EER conceptual schema Dean Cname for a UNIVERSITY database