you will need to create an SQL schema for your project, based on the UML data model that you propose for this week. To facilitate this, I will create a database server that you can connect to in order to test your SQL$,$ make sure that it runs$/$produces the schema you want, etc. Part of the submission of this project task will be building the database schema on this server.

In order to connect to the server, you'll need credentials for both the server itself, and the database. To ensure decent security, we will be using SSH public key authentication to connect to the server.

For this assignment, generate an SSH key pair and submit both your public SSH key and the username you'd like me to use to create your account. Once I have this information, I'll set up an account on the server so you can connect. I'll post more instructions on what to do following this once the accounts have been set up$.$

If you don't know how to set up SSH client and generate a keypair on your platform, please do a little research first and try to figure it out on your own.

Please format your submission like this,

desired username

ssh key $($starting with ssh$-$alg and ending with user@hostname$)$

An SSH public key looks like this,

ssh$-$rsa AAAAB$3$NzaC$1$yc$2$EAAAADAQABAAABgQCi$5$RFL$0$X$4877$eG$2$j$7$sROu$5$wgYMn$92$zK$+$MthzBrPFNCJl$4$GI$8$eGK$0$XZKuPrekY$1$HG$6$w$1$tvtz$8/5$G$5$TlhryECufBQCvJr$3$FPYHCZGvnIdjBoytX$7$aaFKGED$+7$TocCiWc$+$EEpuvhcE$4$yj$5$Y$2$hQSk$/$UnpNPFBYqJZc$24$uBuigwIbjWC$0$S$6+$awXicQGpcBtBywRktqvFiYhn$2$HA$0$NO$4$nmeSqFw$0$RdxTV$8/$Q$4$k$0+$wDIUKiWmd$9$iQAPDBmBQTnKeVWcrvYEnep$20$r$7$P$36$CReDvWRlB$1$wt$5$cAdKHHKrQeFvQTT$5$aLrXYBd$775$oYMav$5$Yrehu$3$Q$0$oy$1$ClWUHRkK$40$OQ$94$mLsuIE$1$XeN$5$hQsOoEBhmvdxLC$7$vqTiIoG$3$xgBVSoDeX$376$xcu$1$lClcbO$2$ymmqshYuGZjgAv$13$f$9$Y$85$Jx$1+$fpEeEOBRVfOsv$9$Fzl$2$jyqRJqcD$0$m$/$M$7$F$/8$LZUQaL$+$As$4$yI$+$m$/40$w$4$ZBuYntn$9$i$/$njJEdC$6$hr$2$KUdAMokPqMYgz$99$nwMxCjs$=$ douglas@laptop

Be careful not to upload your private key. This should be $($as the name suggests$)$ kept private.