DC$15$ Duya rayt wan stored f$$nsh$$n we nem fHW$\_9\_$xxxx$()$ we go rit$$n di k$$s id we di k$$s nem g$$t wan giv$$n paramita pat$$n string. Yu f$$ yuz LIKE f$$ di pattem mach. Duya luk na di K$$s tebul. $9\mathrm{.}1>$ pik fHW$\_9\_$demo$(\text{'}$Z$\text{'})$ as autput; $9\mathrm{.}3>$ pik fHW$\_9\_$demo$(")$ as $$tput; Di SQL stetm$$nt we de $$p go kam bak Di SQL stetm$$nt we de $$p go rit$$n I autput $1|$tput I $+-+---+|$ N$$ r$$k$$d n$$ f$$n$.1|$ Duya input valid string. I $9\mathrm{.}2>$ select fHW$\_9\_$demo$(\text{'}$M$\text{'})$ as output;Di SQL stetm$$nt we de $$p go rituin $9\mathrm{.}4>$ pik fHW$\_9\_$demo$($null$)$ as autput; Duya input valid string I $10.$Duya rayt wan stored f$$nsh$$n we nem fHW$\_10\_$xXxx $()$ we go rit$$n di tot$$l pem$$nt m$$nt f$$ wan giv$$n stud$$nt ID $$n wan ia Duya luk na Stud$$nt$,$ K$$s$,$ Stud$$nt$\_$K$$s tebul d$$n $>$ pik fHW$\_10\_$demo$(2000,1001)$ as autput; f$$ stud$$nt ID: $1001$ na ia: $2000|\mathrm{.}400|.$ Di SQL stetm$$nt we de $$p go rit$$n $10\mathrm{.}4(5$ pts$)>$ pik fHW$\_10\_$demo$(2017,$ null$)$ as $$tput; Di SQL stetm$$nt we de $$p go rit$$n $|$tput $$tput $|$ Duya input valid ia$.|+--+|$ Duya, put valid stud$$nt id$.|$ mysql$>$ desc Stud$$nt d$$n; $|$ Fild $|$ Tayp $|$ Null we n$$ g$$t wan b$$t $|$ Ki $|$ Dif$$lt f$|$ Ekstra $+-+--$ Isid $|$ int $(11)1$ N$$ PRI NUL $|$ f$$s$\_$nem $|$ varchar $(20)$ we d$$n k$$l $|$ NO $|$ NULL $|$ las nem $|$ varchar $(20)$ we d$$n k$$l $|$ NO $|$ NULL $|$ batde f$$ yu $|$ deti we d$$n mek $|$ NO $|$ NULL $|$ major $|$ varchar $(20)$ we d$$n k$$l $|$ NO $|$ NULL $|$ zipk$$d f$$ di $|$ varchar $(10)$ we d$$n k$$l $|$ NO $|$ NULL $+---+--6$ row in set $(0\mathrm{.}00$ sek$)$ mysql$>$ pik $*$ fr$$m Stud$$nt d$$n; $+----------+-|$ sid $|$ f$$s$\_$nem $|$ las$\_$nem f$|$ batde major $|$ zipk$$d $1|1001$ we d$$n k$$l $|$ Austin $|1002$ we d$$n k$$l $|$ Meri $|1003$ we d$$n k$$l $|$ Kl$$dia $|1004$ we d$$n k$$l $|$ Andru $|1005$ we d$$n k$$l $|$l$$n $|1007$ we d$$n k$$l $|$ Sera $|$ Huang $|$ Smit $|$ Lee $|$ Lin na $|$ Wu $|$ Lee $1990-01-01$ C$.$ S$.|071231976-02-08$ IT $|08348$ na di $|1987-03-21|$ Math $|913841947-08-25|$ Bayoloji $|07101$ na di $|1997-01-25$ Di wan d$$n we de wok $|$ C$.$ S$.$ Di wan d$$n we de wok $|07083$ na di $|1995-09-15$ Di wan d$$n we de wok $|$ IT $|041016$ row in set $(0\mathrm{.}00$ sek$)$ mysql$>$ desc K$$s d$$n; $|$ Fild $|$ Tayp $|$ Null we n$$ g$$t wan b$$t $|$ Ki $|$ Dif$$lt f$|$ Ekstra $|$ cid $|$ varchar $(20)$ we d$$n k$$l $|$ NO $|$ nem $|$ varchar $(20)$ we d$$n k$$l $|$ NO $|$ kredit d$$n f$|$ int$(11)$ we d$$n k$$l $|$ NO $+---3$ row in set $(0\mathrm{.}00$ sek$)|$ PRI $|$ NULL T$.|$ NULL I. $|$ NULL $-----$ mysql$>$ pik $*$ fr$$m K$$s d$$n; cid $|$ nem $|$ kredit d$$n f$||$ CPS$1231$ we g$$t f$$ du wit $|$ Javal we d$$n k$$l $|$ CPS$2231$ we g$$t f$$ du wit $|$ Java$2|$ CPS$2232$ we g$$t f$$ du wit $|$ Data Strukch$|$ CPS$3500$ we g$$t f$$ du wit $|$ W$$b Progr$$m we d$$n de mek $|$ CPS$3740$ we g$$t f$$ du wit $|$ Database Introduksh$$n $||$ CPS$5920$ we g$$t f$$ du wit $|$ Database Sistem d$$n T $|$ CPS$5921$ we g$$t f$$ du wit $|$ Data Mayning $4144131313137$ row in set $(0\mathrm{.}00$ sek$)$ mysql$>$ desc Stud$$nt$\_$K$$s; $|$ Fild $|$ di wan d$$n we de wok $|$ Null we n$$ g$$t wan b$$t $|$ Ki $|$ Dif$$lt f$|$ Ekstra $+--+-$ Isid $|$ int$(11)$ we d$$n k$$l $|$ NO MUL $|$ NULL $|$ cid $|$ varchar $(20)$ we d$$n k$$l $|$ NO $|$ MUL $|$ NULL $1$ ia $1$ ia $|$ int $(11)$ we d$$n k$$l $|$ NO $|$ NULL $|$ s$$msta f$|$ varchar $(20)$ we d$$n k$$l $|$ NO $|$ NULL $|$ gred we d$$n k$$l $|$ char$(2)$ we d$$n k$$l $|$ YES $|$ NULL $+------+--5$ row in set $(0\mathrm{.}00$ sek$)$ mysql$>$ pik $*+-------|$ sid $|$ cid fr$$m Stud$$nt$\_$K$$s; $--------|$ ia $|$ s$$msta f$|$ gred we d$$n k$$l $||1001$ we d$$n k$$l $|$ CPS$2231$ we g$$t f$$ du wit $|2013$ we d$$n k$$l $|$ F$$l $|1003$ we d$$n k$$l $|$ CPS$2231$ we g$$t f$$ du wit $|2015$ we d$$n k$$l $|$ Spring $|1004$ we d$$n k$$l $|$ CPS$2231$ we g$$t f$$ du wit $|2014$ we d$$n k$$l $|$ Spring $|1001$ we d$$n k$$l $|$ CPS$2232$ we g$$t f$$ du wit $|2016$ we d$$n k$$l $|$ F$$l $|1004$ we d$$n k$$l $|$ CPS$2232$ we g$$t f$$ du wit $|2014$ we d$$n k$$l $|$ Spring $|1005$ we d$$n k$$l $|$ CPS$2231$ we g$$t f$$ du wit $|2016$ we d$$n k$$l $|$ Spring $|1007$ we d$$n k$$l $|$ CPS$2231$ we g$$t f$$ du wit $|2015$ we d$$n k$$l $|$ Spring $|1003$ we d$$n k$$l $|$ CPS$5920$ we g$$t f$$ du wit $|2016$ we d$$n k$$l $|$ F$$l $|1007$ we d$$n k$$l $|$ CPS$3740$ we g$$t f$$ du wit $|2014$ we d$$n k$$l $|$ F$$l $|1003$ we d$$n k$$l $|$ CPS$5921$ we g$$t f$$ du wit $|2016$ we d$$n k$$l $|$ Spring $|1001$ we d$$n k$$l $|$ CPS$3500$ we g$$t f$$ du wit $|2017$ we d$$n k$$l $|$ Spring $|1003$ we d$$n k$$l $|$ CPS$2231$ we g$$t f$$ du wit $|2014$ we d$$n k$$l $|$ F