Task $4$: $(5$ pt$)$ The company asks you to implement a Python program for the

following function:

summary.py: Return the summary report of the company. The report

includes:

A total number of musicians and a list of musicians $($name and ssn$).$

A total number of albums and a list of albums recorded at Notown $($name

and album id$).$

A total number of instruments and a list of instruments at Notown $($name$,$

key, and id$).$

A table consists of the names of musicians and the total number of albums

written by them. 'num'

A

B

'street'

$1000$

'University'

'street$\_$type'

$\text{'}$n

$\backslash$table$[[,,,,,,,,],[\text{'}$Antonio$\text{'},100000000,7,\text{'}$F$\text{'},2004,\text{'}$CD$\text{'},",$'flute',$\text{'}$C$\text{'}],[\text{'}$Antonio$\text{'},100000000,21,\text{'}$X$\text{'},2010,\text{'}$MC$\text{'},5,$'synthesizer',$\text{'}$B$\text{'}],[\text{'}$Antonio$\text{'},100000000,21,\text{'}$X$\text{'},2010,\text{'}$MC$\text{'},8,$'synthesizer',$\text{'}$B$-$flat'$],[\text{'}$Antonio$\text{'},100000000,21,\text{'}$X$\text{'},2010,\text{'}$MC$\text{'},9,$'flute',$\text{'}$C$\text{'}],[\text{'}$Antonio$\text{'},100000000,24,\text{'}$V$\text{'},2015,\text{'}$MC$\text{'},6,$'synthesizer',$\text{'}$C$\text{'}],[\text{'}$Abel$\text{'},100000001,5,\text{'}$D$\text{'},1991,\text{'}$CD$\text{'},3,$'guitar',$\text{'}$E$\text{'}],[\text{'}$Abel$\text{'},100000001,5,\text{'}$D$\text{'},1991,\text{'}$CD$\text{'},6,$'synthesizer',$\text{'}$C$\text{'}],[\text{'}$Abel$\text{'},100000001,7,\text{'}$F$\text{'},2004,\text{'}$CD$\text{'},9,$'flute',$\text{'}$C$\text{'}],[\text{'}$Abel$\text{'},100000001,16,\text{'}$P$\text{'},1995,\text{'}$MC$\text{'},3,$'guitar',$\text{'}$E$\text{'}],[\text{'}$Abel$\text{'},100000001,16,\text{'}$P$\text{'},1995,\text{'}$MC$\text{'},5,$'synthesizer',$\text{'}$B$\text{'}],[\text{'}$Abel$\text{'},100000001,16,\text{'}$P$\text{'},1995,\text{'}$MC$\text{'},8,$'synthesizer',$\text{'}$B$-$flat'$],[\text{'}$Alex$\text{'},100000002,9,\text{'}$I$\text{'},2004,\text{'}$CD$\text{'},6,$'synthesizer',$\text{'}$C$\text{'}],[\text{'}$Alex$\text{'},100000002,9,\text{'}$I$\text{'},2004,\text{'}$CD$\text{'},12,$'guitar',$\text{'}$B$\text{'}],[\text{'}$Alex$\text{'},100000002,14,\text{'}$M$\text{'},1995,\text{'}$CD$\text{'},3,$'guitar',$\text{'}$E$\text{'}],[\text{'}$Alex$\text{'},100000002,14,\text{'}$M$\text{'},1995,\text{'}$CD$\text{'},5,$'synthesizer',$\text{'}$B$\text{'}],[\text{'}$Alex$\text{'},100000002,14,\text{'}$M$\text{'},1995,\text{'}$CD$\text{'},9,$'flute',$\text{'}$C$\text{'}],[\text{'}$Alex$\text{'},100000002,15,\text{'}$O$\text{'},1995,\text{'}$CD$\text{'},2,$'guitar',$\text{'}$C$\text{'}],[\text{'}$Alex$\text{'},100000002,15,\text{'}$O$\text{'},1995,\text{'}$CD$\text{'},12,$'guitar',$\text{'}$B$\text{'}],[\text{'}$Alex$\text{'},100000002,21,\text{'}$X$\text{'},2010,\text{'}$MC$\text{'},5,$'synthesizer',$\text{'}$B$\text{'}],[\text{'}$Alex$\text{'},100000002,21,\text{'}$X$\text{'},2010,\text{'}$MC$\text{'},8,$'synthesizer',$\text{'}$B$-$flat'$],[\text{'}$Alex$\text{'},100000002,21,\text{'}$X$\text{'},2010,\text{'}$MC$\text{'},9,$'flute',$\text{'}$C$\text{'}],[\text{'}$Tristan$\text{'},100000003,2,\text{'}$A$\text{'},1991,\text{'}$CD$\text{'},4,$'guitar',$\text{'}$B$-$flat'$],[\text{'}$Tristan$\text{'},100000003,2,\text{'}$A$\text{'},1991,\text{'}$CD$\text{'},8,$'synthesizer',$\text{'}$B$-$flat'$],[\text{'}$Tristan$\text{'},100000003,8,\text{'}$H$\text{'},2004,\text{'}$CD$\text{'},6,$'synthesizer',$\text{'}$C$\text{'}],[\text{'}$Tristan$\text{'},100000003,10,\text{'}$J$\text{'},2004,\text{'}$CD$\text{'},4,$'guitar',$\text{'}$B$-$flat'$],[\text{'}$Tristan$\text{'},100000003,10,\text{'}$J$\text{'},2004,\text{'}$CD$\text{'},8,$'synthesizer',$\text{'}$B$-$flat'$],[\text{'}$Tristan$\text{'},100000003,10,\text{'}$J$\text{'},2004,\text{'}$CD$\text{'},9,$'flute',$\text{'}$C$\text{'}],[\text{'}$Tristan$\text{'},100000003,14,\text{'}$M$\text{'},1995,\text{'}$CD$\text{'},3,$'guitar',$\text{'}$E$\text{'}],[\text{'}$Tristan$\text{'},100000003,14,\text{'}$M$\text{'},1995,\text{'}$CD$\text{'},5,$'synthesizer',$\text{'}$B$\text{'}],[\text{'}$Tristan$\text{'},100000003,14,\text{'}$M$\text{'},1995,\text{'}$CD$\text{'},9,$'flute',$\text{'}$C$\text{'}],[\text{'}$Tristan$\text{'},100000003,15,\text{'}$O$\text{'},1995,\text{'}$CD$\text{'},2,$'guitar',$\text{'}$C$\text{'}],[\text{'}$Tristan$\text{'},100000003,15,\text{'}$O$\text{'},1995,\text{'}$CD$\text{'},12,$'guitar',$\text{'}$B$\text{'}],[\text{'}$Tristan$\text{'},100000003,19,\text{'}$S$\text{'},2010,\text{'}$MC$\text{'},4,$'guitar',$\text{'}$B$-$flat'$],[\text{'}$Graham$\text{'},100000004,1,\text{'}$Z$\text{'},1991,\text{'}$CD$\text{'},6,$'synthesizer',$\text{'}$C$\text{'}],[\text{'}$Graham$\text{'},100000004,1,\text{'}$Z$\text{'},1991,\text{'}$CD$\text{'},7,$'synthesizer',$\text{'}$E$\text{'}],[\text{'}$Graham$\text{'},100000004,4,\text{'}$C$\text{'},1991,\text{'}$CD$\text{'},2,$'guitar',$\text{'}$C$\text{'}]]$Notown Records has decided to store information about musicians who per$-$

form on its albums $($as well as other company data$)$ in a database. The company

has wisely chosen to hire you as a database designer. Here is the background

information provided by the company:

Each musician that records at Notown has a name, address $($number$,$ street

name, and street type$),$ and an SSN$.$

Each instrument purchased at Notown has an id$,$ a name $($suppose only

three names: guitar, synthesizer, flute$),$ and a musical key $($suppose only

six types: C$,$ B$,$ E$,$ C$-$flat, B$-$flat, E$-$flat$).$

Each album recorded on the Notown label has a title, an album identifier,

a copyright date, and a format $($CD or MC$).$

Each musician may participate in several albums and a given album may

be designed by several musicians.

Each instrument can be used in any number of albums, and an album may

use several instruments.

The data is stored in a huge CSV file provided to you $($no$\_$town.csv$).$ And

now, they want to take advantage of advanced database design to better manage

the data. To help the company, these are the tasks you need to address:

Task $1$: $(5$ pt$)$ Build a database $($named as original$\_$db$.$db$)$ via Python and

SQLite. And import the data in the CSV file into the database. Your code

should be written in $"$

task$1.$py$".$

Task $2$: $(5$ pt$)$ Draw an ER$-$model based on the description and build the

database via Python and SQLite that is generated from the ER model. En$-$

forcing all the key$/$participation constraints. Your code should be written in

$"$

task$2.$py$".$

Task $3$: $(5$ pt$)$ Extract the corresponding information from the database $".$py$"$

and put it into the corresponding table in the database.