Q:Question:Fclt_Id INT PRIMARY KEY, FcltName VARCHAR(255), Bd_num INT, FOREIGN KEY (Bd_num) REFERENCES Building(Bd_num) ); CREATE TABLE Departments ( DeptID INT PRIMARY KEY, DeptName VARCHAR(255), Fclt_id INT, FOREIGN KEY (Fclt_id) REFERENCES Faculties(Fclt_Id) ); CREATE TABLE Offered ( DeptID INT, C_Id INT, PRIMARY KEY (DeptID, C_Id), FOREIGN KEY (DeptID) REFERENCES Departments(DeptID), FOREIGN KEY (C_Id) REFERENCES Courses(C_Id) ); CREATE TABLE CoursesA:Answer:See a step by step answer