$1.-$ Process $$work$\_$filtered.gz$$ to create the following relations, attributes and keys $($attributes in

bold denote primary keys$)$:

$$ Work$($id$,$ title, rating, total$\_$votes, type$)$

o type FK to WorkType$($id$)$

$$ WorkType$($id$,$ name$)$

$$ Genre$($id$,$ name$)$

$$ WorkGenre$($wid$,$ gid$)$

o wid FK to Work$($id$)$

o gid FK to Genre$($id$)$

$$ BasedOn$($parentwid$,$ childwid$)$

o parentwid FK to Work$($id$)$

o childwid FK to Work$($id$)$

$$ Quotation$($parentwid$,$ childwid$)$

o parentwid FK to Work$($id$)$

o childwid FK to Work$($id$)$

$$ Part$($parentwid$,$ childwid, type$)$

o parentwid FK to Work$($id$)$

o childwid FK to Work$($id$)$

o type FK to PartType$($id$)$

$$ PartType$($id$,$ name$)$

$$ Artist$($id$,$ sort$\_$name, type, birth$\_$year, death$\_$year, deceased$)$

$$ Writer$($wid$,$ aid$)$

o wid FK to Work$($id$)$

o aid FK to Artist$($id$)$

$$ Arranger$($wid$,$ aid$)$

o wid FK to Work$($id$)$

o aid FK to Artist$($id$)$