Student Sname VARCHAR(45) Sid NOHAR(9) Sssn NOHAR(9) sex NCHAR1 Sdassifcaton NOHAR(2) SCurrentAddr VARCHAR (45) SPermAddr VARCHAR(45) SPhoneNo NCHAR(10) SDegProg VARCHAR(S) MajorDcode INT(4) MinorDcode INT (4) Dname VAROHAR (30) Dcode INT (4) DoffceNo VAR AR(20) Dphone NCHAR(10) CollegeName VARCHAR(30) Indexes Indexes Crame VARCHAR( 30) Cnumber VARCHAR(10) Cdescription VARCHAR(60) Chours VARCHAR(45) Scnumber Scnum ber VARCHAR(10) Snum ber VAROHAR(10) Semester VAROHAR(3) Syear NCHAR(4) Sinstuctor VARCHAR(30) StudentGrade Student_Sid NCHAR(9) Scnum ber Scnumber VARCHAR (10) cnum ber Snumber VARCHAR(10) Scnum ber Sem ester VARCHAR(3) Scnumber Syear NCHAR(4) LG NOHAR(1) devel VARCHAR(45) Cdcode INT (4) Indexes NG DECIMAL(5,2 a) Draw ER diagram using MySQL WB based on the logical university database schema (b) Populate at least 7 tuples for each table of the university database table schemas shown in (c) Generate DDL scripts (SQL scripts) to create database and database tables. Then create you derived from the conceptual model (mapping done in Assignment 1). the above diagram (Use insert SQL statement). university database in MySQL DBMS