You are to create a design for a database for the ABC college. The ABC college

has several departments. Each department has a unique department code. For each

department the information about its location $($building name, office number$),$ its

contact phone number and its email address is stored.

For each ABC student, the information about the student$$s unique ID$,$ name $($first and

last$),$ and emails is stored. Every student has a unique college email address and might

also have several personal emails.

Every student is assigned to exactly one department and every department has multiple

students assigned to it$.$

The ABC college students can work at the college departments. If a student opts to

work at any ABC college department, then this student can work at only one college

department that currently has openings. A department can hire any students, not

necessarily those that are assigned to this department. A department can hire several

students or skip hiring anyone.

The ABC college departments might run student clubs. Each department might run

several clubs. However, each club is assigned to exactly one department. The ABC

college students can participate in the college clubs $($club participation is not

mandatory$).$ If a club exists, then it should have at least one member belonging to it$.$ For

each club the information regarding its unique code and its name is stored. For every

student joining a club the information regarding the beginning date of the membership

is stored.