Please use the dataset provided below and output using mariaDB

UniversityDDL.sql :

DROP DATABASE IF EXISTS university;

CREATE DATABASE university;

use university;

drop table if exists prereq;

drop table if exists time_slot;

drop table if exists advisor;

drop table if exists takes;

drop table if exists student;

drop table if exists teaches;

drop table if exists section;

drop table if exists instructor;

drop table if exists course;

drop table if exists department;

drop table if exists classroom;

create table classroom

(building varchar(15),

room_number varchar(7),

capacity numeric(4,0),

primary key (building, room_number)

);

create table department

(dept_name varchar(20),

building varchar(15),

budget numeric(12,2) check (budget > 0),

primary key (dept_name)

);

create table course

(course_id varchar(8),

title varchar(50),

dept_name varchar(20),

credits numeric(2,0) check (credits > 0),

primary key (course_id),

foreign key (dept_name) references department (dept_name)

on delete set null

);

create table instructor

(ID varchar(5),

name varchar(20) not null,

dept_name varchar(20),

salary numeric(8,2) check (salary > 29000),

primary key (ID),

foreign key (dept_name) references department (dept_name)

on delete set null

);

create table section

(course_id varchar(8),

sec_id varchar(8),

semester varchar(6)

check (semester in ('Fall', 'Winter', 'Spring', 'Summer')),

year numeric(4,0) check (year > 1701 and year

building varchar(15),

room_number varchar(7),

time_slot_id varchar(4),

primary key (course_id, sec_id, semester, year),

foreign key (course_id) references course (course_id)

on delete cascade,

foreign key (building, room_number) references classroom (building, room_number)

on delete set null

);

create table teaches

(ID varchar(5),

course_id varchar(8),

sec_id varchar(8),

semester varchar(6),

year numeric(4,0),

primary key (ID, course_id, sec_id, semester, year),

foreign key (course_id, sec_id, semester, year) references section (course_id, sec_id, semester, year)

on delete cascade,

foreign key (ID) references instructor (ID)

on delete cascade

);

create table student

(ID varchar(5),

name varchar(20) not null,

dept_name varchar(20),

tot_cred numeric(3,0) check (tot_cred >= 0),

primary key (ID),

foreign key (dept_name) references department (dept_name)

on delete set null

);

create table takes

(ID varchar(5),

course_id varchar(8),

sec_id varchar(8),

semester varchar(6),

year numeric(4,0),

grade varchar(2),

primary key (ID, course_id, sec_id, semester, year),

foreign key (course_id, sec_id, semester, year) references section (course_id, sec_id, semester, year)

on delete cascade,

foreign key (ID) references student (ID)

on delete cascade

);

create table advisor

(s_ID varchar(5),

i_ID varchar(5),

primary key (s_ID),

foreign key (i_ID) references instructor (ID)

on delete set null,

foreign key (s_ID) references student (ID)

on delete cascade

);

create table time_slot

(time_slot_id varchar(4),

day varchar(1),

start_hr numeric(2) check (start_hr >= 0 and start_hr

start_min numeric(2) check (start_min >= 0 and start_min

end_hr numeric(2) check (end_hr >= 0 and end_hr

end_min numeric(2) check (end_min >= 0 and end_min

primary key (time_slot_id, day, start_hr, start_min)

);

create table prereq

(course_id varchar(8),

prereq_id varchar(8),

primary key (course_id, prereq_id),

foreign key (course_id) references course (course_id)

on delete cascade,

foreign key (prereq_id) references course (course_id)

);

UniversityDML.sql :

https://drive.google.com/file/d/1uDPYU_otKOfFuQuCObZZ4AgAkZpMa4sO/view?usp=sharing

1. Create a View that shows the most popular departments by the number of courses offered in 2010 ; 2. For each building, find the number of different instructors who have taught at least one course section in that building since the year 2018. Do not display the building if no instructors have taught there since 2008. The result should display the building name and the number of instructors (give a proper column name). Note: there is more than one table which has a building column, and you need to figure out which one to use. 3. Find the ID and name of the instructors who taught at least one course in another department. Remove duplicates in the results. 4. Find the instructors who earn the second highest salary in their own departments. Display the name, department name, and salary of these instructors in alphabetical order of the department name. 5. A list of all the perquisite courses for the course that have more than 2 prerequisites