ࡱ> 463c jbjbSS &11w]" " " " " " " R R R R 8  $R         UWWWWWW,9"       " "    P"  "  U6 D " " " "  U P:T" " U <R R b LK Accessing Atomic Spectra Database Assignment Log all your work. When through, print the log file. Write the question number by the command. Start the database management system XE "database management system"  (DBMS XE "DBMS" ) software, such as MySQL. Get into the database spectradb of Atomic Spectra. Obtain the name of the table. Get a description of the table's format. (yyy link) Table 1 contains the attribute names with their meanings. Table  SEQ Table \* ARABIC 1. Attributes for spectra table AttributeMeaningspecSpectrawavelengthCentral wavelengthRel_intRelative intensityAkiEmission transition probability (Aki) in units of 108 sec-1AccAccuracyEiLower level energy (Ei)EjUpper level energy (Ei)ConfigurationsConfigurationsTermsTermsJiLower level total electronic angular momentum (Ji)JkUpper level total electronic angular momentum (Jk)GiLower level statistical weight (Gi)GkUpper level statistical weight (Gk)TypeType; transition multipole moment dipole, etc.Tp_refsTransition Probability ReferencesLine_refsLine References Display a list of the spec and the non-null values in one of the following attributes: Rel_int, Aki, Acc, Ei, Ej, Configurations, Terms, Ji, Jk, Gi, Gk, Type, Tp_refs, Line_refs. Determine the number of tuples. Display wavelength (list first) and spec, ordered by wavelength and then spec, for those spectra NA IX or S VII. Display the Rel_int, Aki, Acc values for one of the following spectra. Sc XIX, Al X, Ni XVIII, Mg VII, Al IX, B IV Display spec and Aki, sorted by Aki, where Aki is between 2.0e+01 and 9.9e+01. Display the tuple for the maximum lower level energy, Ei. Display the Configurations ending in 4s. Display the wavenumber (s = Ek - Ei), Ritz wavelength (1/s), and spec for wavelength less than 60.15 . For spec being 'Co XVI', display wavelength, Aki, Ji, gi = 2Ji + 1, Jk, and gk = 2Jk + 1 and the absorption oscillator strength or f-value (fik), where fik = Aki 1.4992 e-16 gk/gi l2, where l is the wavelength in ngstrms Get out of the database management system XE "database management system"  (DBMS XE "DBMS" ), such as MySQL.  PAGE 2 %&1EMae FGHKN}~2<dh6H*CJEH 565mH jU>*6<j<UT-9W%&1DEM`ae8|p8!$$l40T$) & F-9W%&1DEM`aeyrng`\UN  M  PQ  Z  ^_                    )9:       r  JKNpp|4ڠڠ!$$l40T$ JKN12<ž}vokd]YR        )  ./  S  VW  {  ~                  1  4512<LMN "  p B r wڬl & F & F!$$l40T$<LMN "  p B r vwü           m           " * 4 5 F J W a b k o  $ . 4 L R b h ~   6 R J R H J Z ` v OJQJ5CJB*6_v | -.2PQWX\depuyz0JmH0J j0JU<j<UH*OJQJ6w & F# 0/ =!"#$%| HH@R),, P `,-^&'0940-0000-0000-C000-000000000046}Comments\\ProxyStubClsid&&{00020424-0000-0000-C000-000000000046}rrTypeLib&&{00020905-0000-0000-C000-000000000046}Version8.0VV&&{0002093F-0000-0000-C000-000000000046}Footnote+ [,@,Normal CJPJmH << Heading 1 @&5>*OJQJ4@ab4 Heading 2,b d@&22 Heading 3 h@&522 Heading 4 h@&>*66 Heading 5 @&5CJ66 Heading 6 @&>*CJ66 Heading 7 @&6CJ66 Heading 8 @&6CJ6 6 Heading 9 @&6CJ<A@<Default Paragraph Font" "Index 1&(@& Line Number, ,Footer  !,@",Header  !<&@1<Footnote ReferenceCJEH2B2 Footnote TextCJ&)@Q& Page NumberZObZtext,t,body,times%d 8Tp arcode,c,body computer,compV8d C8Tp t @ |HPX "# CJOJQJ8Z8 Plain TextCJOJPJQJ:a: long quote,ldOa3exercises,e,body exercises,body figure,body problem& 4Pl4a4instructions,i6@@part exercises,p 8 8JJobject equation,oTd 8T@a@ pseudocode,s8-D 8hh!exercised,d,coded,body exercises28 8@@ u,pseudocode2 h >> f,definition! 8B"B Geneva 10"h  CJOJQJt2t data op defC#T 6T 4l @ xH X OJQJ8B8indent1$0dOJQJr2rdata opC%T 6T 4l @ xH X 56OJQJ6Oab6 bb,bold title&$5rq 'iqr(@"@@Caption)#dx 858Y8 Document Map*-D OJQJ&%&!v  w <   !$ELFHKM}2;afSUWYegmopuw(NwAngela ShifletkMacintosh HD: A's Work:ECS DB: DB Text 2001: 4 Accessing Databases with SQL:Accessing spectra w/ SQL Assn.Angela ShifletkMacintosh HD: A's Work:ECS DB: DB Text 2001: 4 Accessing Databases with SQL:Accessing spectra w/ SQL Assn.Angela ShifletkMacintosh HD: A's Work:ECS DB: DB Text 2001: 4 Accessing Databases with SQL:Accessing spectra w/ SQL Assn.Angela ShifletkMacintosh HD: A's Work:ECS DB: DB Text 2001: 4 Accessing Databases with SQL:Accessing spectra w/ SQL Assn.Angela ShifletkMacintosh HD: A's Work:ECS DB: DB Text 2001: 4 Accessing Databases with SQL:Accessing spectra w/ SQL Assn.Angela ShifletkMacintosh HD: A's Work:ECS DB: DB Text 2001: 4 Accessing Databases with SQL:Accessing spectra w/ SQL Assn.Angela ShifletkMacintosh HD: A's Work:ECS DB: DB Text 2001: 4 Accessing Databases with SQL:Accessing spectra w/ SQL Assn.Angela ShifletkMacintosh HD: A's Work:ECS DB: DB Text 2001: 4 Accessing Databases with SQL:Accessing spectra w/ SQL Assn.Angela ShifletkMacintosh HD: A's Work:ECS DB: DB Text 2001: 4 Accessing Databases with SQL:Accessing spectra w/ SQL Assn.Angela ShifletkMacintosh HD: A's Work:ECS DB: DB Text 2001: 4 Accessing Databases with SQL:Accessing spectra w/ SQL Assn.   hhOJQJo(hh.@ǨT @4`@` ` `@GTimes New Roman5Symbol3 Arial3Times;Helvetica7Courier? Courier New5 Geneva"qhXX!HJ&a#>0&CS 370 SQL AssignmentAngela B. ShifletAngela Shiflet&{00020919-0000-0000-C000-000000000046}MailMergeDataField\a\ProxyStubClsid&&{00020424-0000-0000-C000-000000000046}rbrTypeLib&&{00020905-00 Oh+'0   < H T `lt|'CS 370 SQL Assignment8S 3Angela B. ShifletenngeNormalBAngela Shiflete25eMicrosoft Word 8.0n@zT@u&1@LD -@-a];-0$GÂ+[vCTqkHo்tDV@;@fQm@2\3?9[}!A I%O,FY5$Q$%U'[ggۗ1;JX;U,4)y:-~M6L/$%E jF싶`#K'wXsŊ,?..b/!(U%%4v:*3 LFNHȆ @f\,ðhp.WpMVNкgq a)JnmIpk6-% /ʜL#[Uj9Y?vJ;H8%AO̬„E+R#0ފU#F!p֟ F]5P eNe4-Q k4bq\"`GnK*4#NLv]]'pʼnؕҒ&4_lO~Z@$ 1n3o+ FVFCE;w@VhB_yAv+6?B|ͺb3Ys$/ T%BB33 ?5t;$~aT8.rrdG%%ݷJ"E3_.ҟGI6/OXq,1ߋϙϗUEO/L0Gu>"c%}3A@1~`-#o4w |ӑJ ?+o{m~PEaAY=̥}lϨaBI v-$<3T,$6L&CFN4z+lH] Y# }GÆsE=E輚r~JNH`zm |"u& ,H|߆:mG%xBh_~beEmy(.̛<2f,%Q(Ye#\\-mN<W$/E"FTc9H?CVEZ7H ` Z8[u,8 $zF[rOek>&9Lwjf!ʞ9{a)r`G{~'4+B2.OOi>[p%:" ܺ g}.d>ͻ5&)!Τ=EQAex{{3E<@"R@k2EZՊk:EAN'4w!KEEݵ&pO),ѻ,'|-U9;O:]J$oH Ԭ #N$ٹ n,<4,Y-vOb%V榥J!M$6Rb!G-h4>Q%,1N6N/.&x%~{;_, @JX2!v; /s2 Z4bJm.bEoC# ڃx| ^ze|7pGq"ۘAghe!4=&A7uIZʼnF+BW]`{ FCw%R!|,5"2I?I L9NA&g9>NQAO)n4i4%s5$8[9n ҄?Ä֫#=ghPS`7 63WeA/cD&!@q3VGHG{[nYLnM~Rq00{:A iD4gԠ2|s'驛Rm0OCGvTE}A@-Vp8p=*$YL(4m*/ 3sBb{{%L/Va|AI8NvE>ȕ+PE\ũyr-6dC7!GFrAFjsZ4SGv;||Epf(͞6plTOsR+iMO/V%잭3mGJBKZPOdn,Klz m(?c$%F9uNd,5cFE143!+D)R}@E8$Ѐ `|!.}֨AD4߼,pW| ]5Wv&} e(E PV\E)$ S~ D-zx`x8DH=OOcE>)zʯev^!(I4|'j}~35Q`DEf]%$Ҏ!p.$peދn,/=K;N;#'w9O{͟KOY ^!;/zN$4,xq6+ &|̷ا A29g-|ጺص4DYm6"ybP a RBag%$@j㫪qNVHjâ }tG:V7~SK$1ڷGO^ B*ϲ(( ,|<ȩ>JS 9lRdJ'G҆ +ZF0s2&T84~-*!GCW'GJ>f[-|n9f%::5aPȸmf{؀Q٪UBC«-OK!o?8$t{[zE\mo1R13%Cc༛%x@s+kpԼ\ `AK|$ u4KsFJ+F P͜~O̸֯+"U_cF]59];-0$GÂ+[vCTqkHo்tDV@;@fQm@2\3?9[}!AǍ$4,xq6+ &|̷ا A29g-|ጺص4DYm6"ybP a RBag%$@j㫪qNVHjâ }tG:V7~SK$1ڷGO^ B*ϲ(( ,|<ȩ>JS 9lRdJ'G҆ +ZF0s2&T84~-*!GCW'GJ>f[-|n9f%::5aPȸmf{؀Q٪UBC«-OK!o?8$t{[zE\mo1R13%Cc༛%x@s+kpԼ\ `AK|$ u4KsFJ+F P͜~O̸֯+"U_cF]59];-0$GÂ+[vCTqkHo்tDV@;@fQm@2\3?9[}!A ՜.+,D՜.+,@ hp|  '70&: CS 370 SQL Assignment Title 6> _PID_GUID'AN{C6CC7284-9C93-11D4-AF9B-0005021FB0BB}ͺb3Ys$/ T%BB33 ?5t;$~aT8.rrdG%%ݷJ"E3_.ҟGI6/OXq,1ߋϙϗUEO/L0Gu>"c%}3A@1~`-#o4w |ӑJ ?+o{m~PEaAY=̥}lϨaBI v-$<3T,$6L&CFN4z+lH] Y# }GÆsE=E輚r~JNH`zm |"u& ,H|߆:mG%xBh_~beEmy(.̛<2f,%Q(Ye#\\-mN<W$/E"FTc9H?CVEZ7H ` Z8[u,8 $zF[rOek>&9Lwjf!ʞ9{a)r`G{~'4+B2.OOi>[p%:" ܺ g}.d>ͻ5&)!Τ=EQAex{{3E<@"R@k2EZՊk:EAN'4w!KEEݵ&pO),ѻ,'|-U9;O:]J$oH Ԭ #N$ٹ n,<4,Y-vOb%V榥J!M$6Rb!G-h4>Q%,1N6N/.&x%~{;_, @JX2!v; /s2 Z4bJm.bEoC# ڃx| ^ze|7pGq"ۘAghe!4=&A7uIZʼnF+BW]`{ FCw%R!|,5"2I?I L9NA&g9>NQAO)n4i4%s5$8[9n ҄?Ä֫#=ghPS`7 63WeA/cD&!@q3VGHG{[nYLnM~Rq00{:A iD4gԠ2|s'驛Rm0OCGvTE}A@-Vp8p=*$YL(4m*/ 3sBb{{%L/Va|AI8NvE>ȕ+PE\ũyr-6dC7!GFrAFjsZ4SGv;||Epf(͞6plTOsR+iMO/V%잭3mGJBKZPOdn,Klz m(?c$%F9uNd,5cFE143!+D)R}@E8$Ѐ `|!.}֨AD4߼,pW| ]5Wv&} e(E PV\E)$ S~ D-zx`x8DH=OOcE>)zʯev^!(I4|'j}~35Q`DEf]%$Ҏ!p.$peދn,/=K;N;#'w9O{͟KOY ^!;/zN$4,xq6+ &|̷ا A29g-|ጺص4DYm6"ybP a RBag%$@j㫪qNVHjâ }tG:V7~SK$1ڷGO^ B*ϲ(( ,|<ȩ>JS 9lRdJ'G҆ +ZF0s2&T84~-*!GCW'GJ>f[-|n9f%::5aPȸmf{؀Q٪UBC«-OK!o?8$t{[zE\mo1R13%Cc༛%x@s+kpԼ\ `AK|$ u4KsFJ+F P͜~O̸֯+"U_cF]59];-0$GÂ+[vCTqkHo்tDV@;@fQm@2\3?9[}!AǍ$4,xq6+ &|̷ا A29g-|ጺص4DYm6"ybP a RBag%$@j㫪qNVHjâ }tG:V7~SK$1ڷGO^ B*ϲ(( ,|<ȩ>JS 9lRdJ'G҆ +ZF0s2&T84~-*!GCW'GJ>f[-|n9f%::5aPȸmf{؀Q٪UBC«-OK!o?8$t{[zE\mo1R13%Cc༛%x@s+kpԼ\ `AK|$ u4KsFJ+F P͜~O̸֯+"U_cF]59];-0$GÂ+[vCTqkHo்tDV@;@fQm@2\3?9[}!A Lۃny@%Ѭ6s)kmd$\Gc9Ŭ@=CDFzs]w3TE}9e_$-m$͂,3s˧w!ț%^KGjl| NAe|fPO[ YLnM3@g+ sK%zEG?j!  # \^&x7zomF$PnAuYmv#P gL