Design and Implementation of a University Course Registration Database$$Introduction:This project involves designing and building a database system to support course registration at a university. Students will create an enhanced entity relationship $($EER$)$ diagram to model important entities and relationships. The EER diagram will be mapped to a relational schema, and SQL DDL statements will be written to implement the schema in a DBMS$.$ Finally, SQL DML statements will be used to populate the database with test data.The database will keep track of students, the courses offered, and the registration of students in courses. It will support common functions such as searching for courses, registering for courses, and producing transcripts. This project will provide good practice for database design and SQL skills.$$Requirements:$$Create an EER diagram with entities for students, courses, professors, registration. Include attributes, relationships, and cardinalities.$$Map the EER model into a normalized relational schema. Create tables and specify primary keys, foreign keys, and constraints.$$Use SQL DDL to implement the schema in MySQL or other DBMS$.$ Define tables, keys, indexes, etc.$$Insert test data into tables using SQL INSERT statements. Include at least $10$ sample rows in each of the main tables.$$Compose SQL SELECT queries to retrieve sample data from the database. Join tables in queries as needed.$$Implement a simple user interface or API to interact with the database, such as registering students for courses. Use SQL DML for insert, update, delete operations.$$Document the database schema and provide diagrams and sample code. Explain design choices and SQL syntax $($submit it as PDF or DOCX format$).$