Problem $7$: Grade Database

In this problem, you will be displaying $($fictional$)$ grade information that is assumed to be taken fr

database. The information is stored in two dictionaries and three lists, as shown below.

Copy the code below into a code cell, and then execute that cell.

students $=\{$

$146832$:$\{\text{'}$first$\text{'}$:'Brendan', 'last':'Small'$\},$

$147354$:$\{\text{'}$first$\text{'}$:'Melissa', 'last':'Robbins'$\},$

$149126$:$\{\text{'}$first$\text{'}$:'Jason', 'last':'Penopolis'$\},$

$149735$:$\{\text{'}$first$\text{'}$:'Fenton', 'last':'Mulley'$\}$

$\}$

courses $=\{$

'ENGL $101\text{'}$:'Composition I$\text{'},$

'ENGL $104\text{'}$:'Composition II$\text{'},$

'MATH $117\text{'}$:'College Algebra',

'MATH $151\text{'}$:'Calculus I$\text{'},$

'CHEM $103\text{'}$:'General Chemistry I$\text{'},$

'ECON $201\text{'}$:'Macroeconomics'

$\}$

sid $=[149126,146832,147354,149735,149126,146832,$

$146832,149735,149126,147354,147354,149735]$

cid $=[\text{'}$ENGL $101\text{'},$ 'MATH $117\text{'},$ 'ENGL $104\text{'},$ 'CHEM $103\text{'},$ 'MATH $117\text{'},$ 'ECON $201\text{'},$

'ENGL $101\text{'},$ 'ENGL $101\text{'},$ 'CHEM $103\text{'},$ 'ENGL $104\text{'},$ 'MATH $151\text{'},$ 'MATH $117\text{'}]$

grade $=[\text{'}$D$\text{'},\text{'}$C$\text{'},\text{'}$B$\text{'},\text{'}$A$\text{'},\text{'}$B$\text{'},\text{'}$C$\text{'},$

$\text{'}$A$\text{'},\text{'}$F$\text{'},\text{'}$B$\text{'},\text{'}$A$\text{'},\text{'}$A$\text{'},\text{'}$C$\text{'}]$

The students dictionary is a lookup table that allows you to obtain the name of a student based on their Student ID

number. The courses dictionary is a lookup table that allows you to obtain the name of a course based on the Course ID

$($which consists of a department name and course number$).$ The lists sid, cid, and grade are parallel lists that represent

columns from a grade database. The sid list contains student ID numbers associated with $12$ different records form the

database, the cid list contains course ID information for the $12$ records, and the grade list contains the grade obtained by

the corresponding student in the corresponding course.

Use a loop to print a table displaying the twelve records. The table should be formatted as follows:

$$ The first row of output should contain column headers.

$$ The second row should be a dividing line consisting of $69$ dashes.

$$ The table should have columns for student ID$,$ first name, last name, course id$,$ course name, and grade.

$$ The number of characters reserved for each column should be $9,10,12,11,22,$ and $5($in that order$).$

$$ All columns should be left$-$aligned except for the grade column, which should be right$-$aligned.

The first few rows rows of the output are shown below. Try to match the format of this output exactly.

SID First Last CID Course Name Grade

$-------------------------------------------------$

$149126$ Jason Penopolis ENGL $101$ Composition I D

$146832$ Brendan Small MATH $117$ College Algebra C