in python

Department of Business Information Technology Database Tools (1904415) Homework(10) 2020-2021 First semester Name: ---------- St_ID: ---- Section time: ------- Serial No:------- Question 1.(10 marks). Consider the following relational schema. Student course Id 1 2 Name Ahmad Maha Mona Mahdi Suha Address Amman Amman Amman Amman Amman cno 1903321 1902212 1902112 1903341 1903442 cname Database Management E-commerce Fundamental simulation credit 2 3 3 2 3 3 4 5 Registration id cno Mark Regdate 1 1903321 90 12-09-2006 1 1902212 80 12-10-2006 2 1903341 85 18-06-2006 2 1903321 90 21-09-2006 3 1903321 70 01-08-2006 3 1902212 84 15-07-2006 Q1) Write a PL/SQL code to get the following output. 1 Ahmad Amman 1903321 Database 2 credit hours in September 1902212 Management 3 credit hours in October 2 Maha Amman 1903341 Fundamental 3 credit hours in June 1903321 Database 2 credit hours in September 3 Mona Amman 1903321 Database 2 credit hours in August 1902212 Management 3 credit hours in July 4 Mahdi Amman didn't take any subject 5 Suha Amman didn't take any subject