Lab 4 Analyze and Visualize Relational #Database data in #Python

Objectives:
• To learn how to use Python codes to execute SQL statements
Data:
• The database you created from lab2.
Requirements:
• Design your Python codes to accomplish those tasks:
1. Display all the records in the student table.
2. Display the teachers' names and the corresponding course names jointly based on the teacher's email.
3. Use a bar chart to show the number of enrolled students by each course number.
4. Use a bar chart to show the number of courses taught by each professor's name.
5. A new professor just joined JMU and will teach a new course. Add a new record of the new professor in the teacher table, and the corresponding new course record in the course table. You can make up the professor's info and the new course info. Display the modified professor table and the course table.
6. An existing professor will retire soon, and the newly hired professor will teach his/her courses. Delete one of the existing professors in the teacher table and change the instructor of his/her classes in the course table to the newly hired professor. Display the modified professor table and the course table.

Demo code: https://github.com/xbwei

More about databases: https://www.youtube.com/playlist?list=PLHutrxqbP1ByGhrCv0tZADlIQxwHEbhdL


A more concise tutorial: https://www.youtube.com/playlist?list=PLHutrxqbP1BxK4KzYL8tJmMhV2yhGZNlY