Create a database scheme for school and make Referential constraints displayed on the school relational database schema... your solution will be like that example:

The COMPANY database schema. LNAME EMPLOYEE FNAME MINIT John B Franklin T Alicia J Jennifer S Ramesh K Joyce Ahmad V James E BDATE 1965-01-09 1955-12-08 1968-07-19 Smith Wong Zelaya Wallace Narayan English Jabbar Borg SSN 123456789 333445555 999887777 987654321 666884444 453453453 987987987 889665555 SEX SALARY M 30000 40000 F 25000 F 43000 M 39000 F 25000 M 25000 M 55000 ADDRESS 731 Fonden, Houston, TX 639 Voss, Houston, TX 3321 Castle Spring, TX 291 Berry, Bellaire, TX 975 Fire Oak, Humblo, TX 5631 Rice, Houston, TX eo Dallas, Houston, TX 450 Store, Houston, TX SUPERSSN DNO 333445555 5 889865555 5 987654321 4 4 B88865555 4 4 333445555 5 333445555 5 5 987654321 4 nul 1 1941-06-20 1962-09-15 1972-07-31 1969-03-29 1937-11-10 DEPT LOCATIONS DNUMBER 1 4 DLOCATION Houston Stafford Bellaire Sugartand Houston DEPARTMENT DNAME Research Administration Headquarters DNUMBER 5 4 1 MGRSSN 333445555 987654321 888665555 MGRSTARTDATE 1988-05-22 1995-01-01 1981-06-19 5 5 5 5 WORKS ON PNO 1 2 3 1 2 2 2 HOURS 32.5 7.5 40.0 20.0 20.0 10.0 10.0 10.0 10.0 PROJECT PNUMBER ESSN 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333443553 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 DNUM 3 TU 20 PNAME ProductX ProductY Productz Computerization Reorganization Newbenefits 1 1 2 3 3 10 20 30 PLOCATION Bellaire Suryadland Houston Stafford Houston Stafford 5 5 5 4 1 30 10 4 10 30 30.0 10.0 35.0 5.0 20.0 15.0 null 30 20 20 DEPENDENT NAME ESSN SEX BDATE RELATIONSHIP DEPENDENT F M F Alice Theodore Joy Abner Michael Alice Elizabeth 333445555 333445555 333445555 987654321 123456789 123456789 123456789 M 1986-04 05 1983-10 25 1958-05 03 1942-02-28 1988-01 04 1988-12-30 1967-05-05 DAUGHTER SON SPOUSE SPOUSE SON DAUGHTER SPOUSE M F F Referential integrity constraints displayed on the COMPANY relational database schema. EMPLOYEE ADDRESS BDATE SEX SALARY SUPERSSN DNO LNAME SSN FNAME MINIT DEPARTMENT DNAME DNUMBER MGRSSN MGRSTARTDATE DEPT_LOCATIONS DNUMBER DLOCATION PROJECT PNAME PNUMBER PLOCATION DNUM WORKS_ON ESSN PNO HOURS DEPENDENT SEX BDATE RELATIONSHIP ESSN DEPENDENT_NAME