Submit by email in $1$ txt file named as follows your$-$name$-$mt$.$txt

For each answer first copy the question and then your answer.

For attribute catalog use comma separated format.

For SQL$,$ simply copy and paste from your shell.

Explain.Data Description

Investment management firm RKE, has collected information has shown in the XLS$.$

Each Coumn represents the balance of a particular portfolio.

Some of the portfolios are custom portfolios belonging to customer$-1,$ customer$-2,$ customer$-3,$

etc

on a given date $($specified in mmddyyyy format$)$ as well as a sequence $).$

Different customers also wish to know how their portfolio performed relative to a standard

portfolio $--$ also known as $--$ benchmarks. You probably have heard of SP$500,$Nasdaq and Dow

Jones.

There are others such RUSSEL$-2000($with symbol RUT$2).$

In part$-1$ perform normalization as prescribed in the course.

Submit an attribute catalog $(10$ points$),1NF$ with explanations $(10$ points$)$ and $2NF$ with

explanations $(10$ points$)$

In part$-2,$

show how you loaded the given data into a PF$\_$RAW table. $(10$ points$)$

show how you populated the normalized schema from this PF$\_$RAW table. $(10$ points$)$

For each benchmark, list the benchmark name $($NDQ or BMK$-01)$ and the daily volatility

$($standard deviation$)(10$ points$)$

$[$hint $--$ please lookup the function for your database from the internet$]$

Performance of an investment between holding period is calculated as follows: $(50$ points$)$

$($ value$\_$of$\_$the$\_$investment$\_$at$\_$the$\_$end$\_$of$\_$the$\_$period LESS

value$\_$of$\_$the$\_$investment$\_$at$\_$the$\_$end$\_$of$\_$the$\_$period $)$ DIVIDED BY

$($value$\_$of$\_$the$\_$investment$\_$at$\_$the$\_$end$\_$of$\_$the$\_$period$)$Generate an output as follows:

PF$1,1,30,$performance

$PF1,31,60,$performance

PF$1,61,90,$performance

PF$1,91,120,$performance

PF$1,121,150,$ performance

PF$2,1,30,$performance

PF$2,31,60,$ performance

PF$2,61,90,$ performance

PF$2,91,120,$performance

PF$2,121,150,$performance

bmk$4,1,30,$perofrmance

bmk$4,31,60,$performance

bmk$4,61,90,$performance

bmk$4,91,120,$performance

bmk$4,121,150,$performance

where performance is computed as above.

bmk$4,91,120,$performance$-->($value of bmk$4$ on $120$th day LESS value of bmk$4$ on $91$ day$)/($

value of bmk$4$ on $91$ day$)$