i asked for this problem and i recived this solution and it's not working, I need another one please

- Making a construction table Building table: CREATE TABLE (Bu Code INT PRIMARY KEY, Bu Name VARCHAR(255), Bu Location VARCHAR(255)); - Creating Room table - Creating the Room Class table. CREATE TABLE Room (Room Code INT PRIMARY KEY, Room Name VARCHAR(255), Bu Code INT, FOREIGN KEY (Bu Code) REFERENCES Building(Bu Code) Create the Room Class table by entering the following information: Room Class (Room Code INT, Class Code INT, Time VARCHAR(255), FOREIGN KEY (Room Code) REFERENCES Room(Room Code), FOREIGN KEY (Class Code) REFERENCES Class(Class Code) Make a table called Class with the following columns: Class Code (INT PRIMARY KEY), Class Name (VARCHAR(255), Room Code (INT), Foreign Key (Room Code) REFERENCES Room(Room Code); \begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ Class } \\ \hline PK & Class_Code \\ FK & Class_Name \\ Room_Code \\ \hline \end{tabular}