Construct a relational database (relational schema table) with the given information.

1. Listing the entities: The given instructions says that system will have below entities: a) College b) Department c) Office d) Instructor e) Courses 2. Constructing schema by adding attributes The entities will have below attributes: a) College College (collegelD, college_name, established_date) a) Department(dept_name) b) Office(office_name, size) C) Instructor(instructor_id, name): added instructor_id as names can be same for 2 or more instructors d) Courses(course_code, name): added appropriate attributes, as not given in description 3. Identify primary key: The identified primary key in each entity is as below(bold and underlined): a) College(collegelD, college_name, established_date) b) Department dept_name) c) Office office_name, size) d) Instructor(instructor_id, name) e) Courses(course_code, name) 4. Listing relationship: a) Department must belong to exactly one college, a college has many departments. Thus department must have a foreign key to its college. b) Department has an office, thus department will store the foreign key to its office also. c) Department has many instructors, but an instructor has one department, thus instructor will have foreign key to its department d) Course is taught by many instructors and an instructor teaches many courses. It is Many to Many relationship to be stored in new table. 5. Adding foreign keys: The entities will have below foreign keys marked as italic: a) College collegeld, college_name, established_date) b) Office office_name, size) c) Department(dept_name, office_name, collegelD) d) Instructor(instructor_id, name, dept_name) e) Courses(course_code, name) f) Curselnstructor(course_code, instructor_id) The above list of tables are final tables for the given database