Q$1.$ Open the previous website $($SHEET$7)$ and do the following:

Create a KSU Database which contains Three tables:

The first table represents a list of colleges in KSU. The table is entitled College and has two attributes: college$-$code and college$-$name. For example, one record might be CBA for the c$-$code and College of Business Administration for the cname. The $c-$code is the primary key.

The second table is entitled Department and contains a college's departments. The table has three attributes $-$ the college$-$code, $d-$code and $d-$name. The $d$ code attribute is the primary key. For example, one record might be CBA for the college$-$code, MIS for the $d-$code and Management Information System for the $d-$name $.$

The third table is entitled Course and contains a department's courses. The table has three attributes: the $d-$code, $c-$code and $c-$name. The $c-$code attribute is the primary key. For example, one record might be MIS for the d$-$code, MIS$366$ for the c$-$code and Web$-$based application for the c$-$name.

Make sure to add foreign key constraints whenever it is suitable.

Fill your three tables with at least $3$ records, these records should be true and understandable values, not dummy values.

In HomePage.aspx: create a form that allow user to insert college$-$code and collagename in the table 'College'.

please solve this with full details and codes for each page