1. A University has many programmes. A student can take any course in the Unversity. The following E-R diagram shows these hypothetical entities and relationships:

<img src='./qimages/13945-1.jpg'>

The assumptions are:

• A student can enrol only for one programme.

• Student can opt for many courses and one course can be opted by many students.

• S_ID is subject id; P_code is programme code and Enrolno is enrolment number.

Perform the following tasks for the E-R diagram given above:

Design and implement normalised relations/tables. You must include primary key, validation checks and referential integrity constraints in the relations/tables.

Enter 5 sets of meaningful data in every table created by you in part

Design and implement the following queries/reports/forms for the database so created:

Create two forms -one for entering the student information and the other for entering the programme information.

List the enrolment number and name of all the students who have enrolled in the programme whose programme code is BCA.

Display all the results of the student whose enrolment number is "0001".

Write SQL command to count the number of programmes offered by the University.

Create a report displaying S_NAME and credits of all the subjects in the alphabetical order of S_NAME.