MySQL

a) Download the clinvar data set in VCF format from the link below

b) Clean and do some normalization of this data (get to at least 1NF) and put this into a new schema called clinvar inside a table called variants. Infer from reading the VCF specification and the downloaded clinvar data what attributes are needed and how you can determine each row and each column. Use any programming language or processing tool to complete this section. Take screenshots of the final solution (1NF) and some steps on the way

Download link: ftp://ftp.ncbi.nlm.nih.gov/pub/clinvar/vcf_GRCh37/clinvar_20180401.vcf.gz