Take clear pictures and make sure the code works.

MYSQL PRACTICE WORK. Universities university id (PK) name address email tel Students student id (PK) fname Iname email tel major major dob university id (FK) Courses course id (PK) name department University_Courses university id (PK + FK) course id (PK + FK) Student Courses Student id (PK + FK) Course id (PK + FK) Key: PK (Primary key) > FK (Foreign key) PK + FK (create a composite key, and make sure both are foreign keys as well) Section 1a): 1. Create a database called 'universityDB' 2. Create all the tables (be sure to use the most appropriate data types, data type lengths, and constraints) 3. Insert 2 records into the 'universities' table (Ashesi & University of Ghana) 4. Insert 7 records into the 'courses table' (Database Systems, Finance for Non-Finance, Discrete Math, Written and Oral Communication, Intro to Computing, Intro to Finance, Accounting) 5. Insert at least 3 courses for each university into the 'university_courses' table 6. Insert 3 students for each university (make sure each university has a CS, MIS and BA student) 7. Make sure every student is taking at least 2 courses ('student_courses' table)