Q1. (25 30+30+15 100 points) Consider the following requirements list for a university database: . The university offers one or more programs . A program is made up of one or more courses. . A student must enroll in a program. . A student takes the courses that are part of her program . A program has a name, a program identifier, the total credit points required to graduate, and the year it commenced . A course has a name, a course identifier, a credit point value, and the year it commenced Students have one or more given names, a surname, a student identifier, a date of birth, and the year they first enrolled. We can treat all given names as a single object -for example, "John Paul . When a student takes a course, the year and semester he attempted it are recorded. When he finishes the course, a grade (such as A or B) and a mark (such as 60 percent) are recorded. . Each course in a program is sequenced into a year (for example, year 1) anda semester (for example, semester 1) (a) (25 points) Draw the Entity-Relationship diagram (ERD) derived from above requirements. Also, you need to identify attributes of each entity, primary key, foreign key and relationship (like many-to-many, one-to-many, many-to-one, etc.) among the entities. (b) (30 points) Implement ERD diagram (part - (a) of this question) using MySQL. You need to submit MySQL code as "university.sql" file and screenshot of your executed commands in a pdf file like "university.pdf". (Hint: Assume appropriate datatypes for all attributes of the entities) (c) (30 points) Write MySQL queries to insert 5 records in above tables (part-b) and show the entered values at command prompt. You need to submit the MySQL code of insert commands and screen shot of command prompt after the execution of required queries