Problem: You are to create a design for a database for the ABC college. The ABC collegehas several departments. Each department has a unique department code. For eachdepartment the information about its location $($building name, office number$),$ itscontact phone number and its email address is stored.For each ABC student, the information about the students unique ID$,$ name $($first andlast$),$ and emails is stored. Every student has a unique college email address and mightalso have several personal emails.Every student is assigned to exactly one department and every department has multiplestudents assigned to it$.$The ABC college students can work at the college departments. If a student opts towork at any ABC college department, then this student can work at only one collegedepartment that currently has openings. A department can hire any students, notnecessarily those that are assigned to this department. A department can hire severalstudents or skip hiring anyone.The ABC college departments might run student clubs. Each department might runseveral clubs. However, each club is assigned to exactly one department. The ABCcollege students can participate in the college clubs $($club participation is notmandatory$).$ If a club exists, then it should have at least one member belonging to it$.$ Foreach club the information regarding its unique code and its name is stored. For everystudent joining a club the information regarding the beginning date of the membershipis stored.