SQL in Python

Create a database, called hw.db, that contains the following three tables: level in number, 1,2,3,4 (for freshmen, to senior) Student (CWID, name, major, level) Enrollment (CID, type, student) Course (CID, title, credit) Note that the underlined attributes are primary keys. Zero more more classes are offered from a course. For example, Course (505, 'Foundation of CSEC', 3) can be offered and enrolled in Enrollment, (505, 'DFA', 'Adam'), (520, 'DFA', 'Bob') and (505, 'DLA Bob) Make sure that your name should be in the table Student. Write all the steps in a Python script: 1. Create three tables as shown above 2. Populate at least 5 students, at least two courses, and about 10 classes. 3. Select all from Student 4. Select all from Course 5. Select all from Enrollment 6. Select course course ID, type and student names who are enrolled in 7. Select student name and course title that the students are enrolled