MY SQL
Raskelly985
sql_files.zipSQL Files/Part 2.png
__MACOSX/SQL Files/._Part 2.png
SQL Files/Part 2b.png
__MACOSX/SQL Files/._Part 2b.png
SQL Files/Part 3.png
__MACOSX/SQL Files/._Part 3.png
SQL Files/Part1.png
__MACOSX/SQL Files/._Part1.png
SQL Files/Queries.png
__MACOSX/SQL Files/._Queries.png
SQL Files/Text Files /author.txt
1|Jane|Austen 2|Mark|Twain 3|James|Joyce 4|Herman|Melville 5|Franz|Kafa 6|Leo|Tolstoy 7|Joseph|Conrad 8|Tom|Paine 9|Isaiah|Berlin 10|John|Bell 11|Moshe|Machover 12|Thomas|Cormen 13|Charles|Leiserson 14|Ronald|Rivest 15|Edmund|Burke 16|John|Mill 17|Emily|Bronte 18|George|Eliot 19|Vladimir|Nabokov
__MACOSX/SQL Files/Text Files /._author.txt
SQL Files/Text Files /book.txt
1|Pride and Prejudice|397 2|Adventures of Huckleberry Finn|320 3|Ulysses|736 4|Moby Dick: Or, The Whale|752 5|Dubliners|152 6|Metamorphosis|201 7|War and Peace|1440 8|Heart of Darkness|80 9|Wuthering Heights|367 10|Middlemarch|736 11|Common Sense|128 12|Anna Karenina|808 13|Liberty|213 14|A Course in Mathematical Logic|600 15|Introduction to Algorithms|1026 16|On Liberty|100 17|Ada|700
__MACOSX/SQL Files/Text Files /._book.txt
SQL Files/Text Files /copies.txt
1|7|32.57 2|2|12.23 3|13|35.10 4|11|8.32 5|12|31.82 6|13|29.72 7|9|11.65 8|8|10.39 9|11|10.60 10|4|21.08 11|11|7.99 12|14|116.68 13|9|11.65 14|6|14.44 15|8|14.78 16|15|64.36 17|3|18.81 18|12|35.11 19|2|14.65 20|5|12.72 21|14|128.48 22|1|10.59 23|2|10.25 24|13|45.86 25|2|10.34 26|11|10.73 27|7|34.40 28|13|41.89 29|1|10.39 30|16|13.82 31|13|39.55 32|13|29.72 33|15|72.09 34|11|8.77 35|12|19.79 36|7|21.59 37|13|36.74 38|9|19.45 39|10|29.07 40|12|27.35 41|16|12.26 42|12|35.31 43|6|10.62 44|1|19.78 45|11|10.79 46|12|23.28 47|9|17.89 48|14|72.23 49|15|87.02 50|12|27.35 51|5|8.67 52|6|12.20 53|10|23.87 54|1|16.48 55|2|13.57 56|13|31.59 57|13|26.91 58|1|14.39 59|4|25.73 60|1|13.29 61|6|10.71 62|16|18.18 63|11|12.74 64|6|11.29 65|11|8.39 66|4|20.00 67|9|10.92 68|4|17.67 69|15|72.60 70|3|21.28 71|10|18.05 72|5|8.74 73|15|94.74 74|12|33.56 75|13|44.69 76|12|30.07 77|6|15.19 78|1|19.78 79|12|20.37 80|4|19.07 81|4|22.32 82|1|14.09 83|16|11.53 84|10|24.79 85|15|54.58 86|1|14.49 87|11|10.79 88|11|10.34 89|6|13.53 90|9|14.25 91|12|34.92 92|13|40.25 93|12|35.31 94|6|16.18 95|4|31.00 96|4|30.53 97|14|79.17 98|7|35.87 99|3|30.52 100|11|12.02 101|1|10.79 102|13|42.12 103|8|9.03 104|13|37.44 105|1|11.09 106|4|16.58 107|2|15.55 108|8|9.59 109|10|16.07 110|4|21.85 111|10|19.74 112|15|95.26 113|1|12.49 114|6|16.35 115|15|95.26 116|5|12.09 117|10|28.46 118|4|21.85 119|11|7.41 120|15|64.36 121|2|16.36 122|9|13.83 123|11|6.82 124|2|15.64 125|3|25.74 126|15|92.68 127|10|16.22 128|16|10.91 129|10|23.72 130|4|22.48 131|3|17.66 132|6|11.87 133|9|19.76 134|5|11.11 135|5|7.62 136|9|10.82 137|6|12.37 138|11|10.92 139|1|12.99 140|15|97.32 141|10|29.22 142|10|25.09 143|14|134.04 144|6|12.70 145|8|15.10 146|2|12.32 147|7|22.33 148|1|12.89 149|3|24.58 150|7|35.68 151|12|27.94 152|3|21.28 153|5|12.72 154|11|10.40 155|8|10.79 156|13|27.14 157|9|13.52 158|5|13.00 159|16|14.13 160|5|9.72 161|6|15.77 162|5|13.49 163|8|11.59 164|7|33.49 165|6|14.11 166|9|16.85 167|9|12.27 168|10|27.85 169|7|23.06 170|16|18.49 171|3|20.95 172|10|17.59 173|14|110.43 174|11|6.57 175|7|35.68 176|9|18.62 177|3|31.51 178|11|9.88 179|16|20.16 180|4|17.51 181|15|80.32 182|11|7.34 183|11|11.05 184|3|25.74 185|13|31.36 186|1|13.89 187|11|12.02 188|2|9.62 189|10|21.11 190|4|18.29 191|2|16.54 192|11|11.31 193|2|16.54 194|15|81.35 195|8|10.39 196|4|18.44 197|10|28.92 198|2|14.20 199|6|13.20 200|12|22.89 201|2|14.74 202|11|11.31 203|16|16.94 204|15|99.38 205|2|10.43 206|14|121.54 207|12|29.49 208|14|95.84 209|15|67.45 210|14|126.40 211|13|24.10 212|12|38.22 213|5|8.32 214|3|26.90 215|4|27.59 216|1|10.49 217|12|20.95 218|10|22.18 219|8|10.23 220|5|11.25 221|2|14.74 222|13|26.21 223|15|98.86 224|12|22.31 225|9|20.18 226|6|15.19 227|7|21.59 228|6|14.53 229|2|16.81 230|16|18.18 231|10|27.54 232|11|11.44 233|8|8.87 234|7|21.59 235|12|26.77 236|2|12.95 237|9|13.10 238|7|21.78 239|5|11.46 240|3|26.24 241|9|17.89 242|2|16.72 243|2|9.44 244|14|104.87 245|8|14.86 246|4|21.70 247|1|16.78 248|12|34.53 249|14|115.29 250|13|36.50 251|15|57.67 252|5|13.77 253|10|26.16 254|13|29.95 255|9|19.14 256|7|23.97 257|12|29.29 258|14|79.87 259|3|24.42 260|11|8.84 261|5|10.83 262|11|12.15 263|7|29.28 264|15|94.74 265|9|12.90 266|1|12.29 267|8|9.75 268|6|12.28 269|1|16.98 270|14|72.23 271|14|75.01 272|9|11.13 273|1|18.48 274|7|36.42 275|9|20.70 276|13|40.25 277|8|8.55 278|9|13.00 279|12|19.59 280|14|106.95 281|11|9.03 282|3|27.72 283|8|15.02 284|5|8.60 285|4|23.41 286|15|79.81 287|12|22.12 288|7|33.31 289|12|23.47 290|15|93.71 291|8|15.74 292|13|28.78 293|8|15.82 294|15|93.71 295|16|16.42 296|4|31.00 297|10|28.15 298|11|11.57 299|12|25.80 300|14|115.98 301|13|42.82 302|6|15.52 303|3|31.51 304|3|29.20 305|13|45.16 306|9|14.56 307|3|22.60 308|3|23.76 309|1|18.28 310|7|28.55 311|2|10.43 312|14|106.95 313|11|11.96 314|2|17.80 315|7|31.11 316|12|29.10 317|1|13.99 318|1|11.09 319|2|17.17 320|16|15.90 321|8|14.22 322|2|15.01 323|10|21.73 324|9|20.70 325|12|34.34 326|3|21.28 327|1|10.89 328|15|101.95 329|9|18.20 330|9|13.10 331|12|21.92 332|15|62.82 333|7|25.62 334|6|13.28 335|14|107.65 336|11|11.24 337|5|10.69 338|15|94.23 339|10|23.72 340|8|8.55 341|13|44.69 342|12|33.56 343|2|14.38 344|8|14.46 345|1|19.08 346|3|25.25 347|8|13.58 348|2|16.54 349|1|10.09 350|7|30.74 351|2|11.96 352|9|18.30 353|14|78.48 354|10|20.96 355|5|10.14 356|10|17.59 357|11|8.26 358|8|11.19 359|16|15.90 360|10|29.22 361|14|91.67 362|9|14.14 363|8|14.22 364|2|17.89 365|12|30.26 366|5|10.97 367|6|10.29 368|4|24.65 369|13|34.16 370|10|29.22 371|3|16.67 372|4|25.58 373|9|16.64 374|2|13.04 375|7|27.82 376|8|9.59 377|8|8.39 378|14|122.23 379|12|32.59 380|1|12.99 381|5|9.23 382|8|9.51 383|16|18.49 384|1|17.38 385|7|23.06 386|14|136.82 387|6|12.78 388|3|29.86 389|14|103.48 390|15|66.94 391|3|26.57 392|9|12.48 393|10|15.76 394|9|13.21 395|6|11.70 396|4|21.55 397|14|91.67 398|13|24.80 399|14|133.34 400|15|62.82 401|6|14.28 402|8|15.66 403|1|18.88 404|3|28.05 405|2|9.98 406|15|69.00 407|12|34.92 408|2|17.98 409|12|32.01 410|3|30.85 411|6|9.63 412|10|17.14 413|6|15.60 414|6|11.95 415|7|28.36 416|5|9.79 417|16|12.36 418|1|16.98 419|13|31.36 420|15|61.79 421|4|29.14 422|14|104.87 423|3|22.77 424|10|16.98 425|9|10.92 426|14|90.28 427|1|19.28 428|3|17.49 429|4|25.11 430|3|24.42 431|3|31.02 432|16|19.74 433|2|11.42 434|11|8.90 435|4|29.92 436|1|12.19 437|1|16.68 438|3|20.46 439|6|15.36 440|9|13.73 441|6|13.78 442|9|17.68 443|4|19.07 444|8|13.58 445|2|15.91 446|12|27.35 447|16|17.97 448|10|19.58 449|15|58.18 450|13|29.25 451|6|15.52 452|11|12.68 453|12|27.55 454|16|14.34 455|15|98.35 456|11|7.41 457|9|16.43 458|12|28.52 459|11|8.19 460|5|8.53 461|11|8.77 462|14|109.04 463|14|120.15 464|12|21.73 465|4|25.11 466|7|21.41 467|7|26.53 468|3|27.72 469|14|109.73 470|13|35.33 471|9|18.41 472|7|28.18 473|16|20.68 474|6|11.45 475|1|14.09
__MACOSX/SQL Files/Text Files /._copies.txt
SQL Files/Text Files /copiesPart2.txt
476|17|32.57|1 477|17|32.23|2 478|17|35.10|3 479|17|38.32|4 480|17|31.82|5 481|17|19.72|6 482|14|81.65|1 483|14|20.39|2 484|14|30.60|3 485|14|31.08|4 486|14|31.82|5 487|14|19.72|6
__MACOSX/SQL Files/Text Files /._copiesPart2.txt
SQL Files/Text Files /customer.txt
1|Gladys|Davis 2|Bonnie|Baker 3|Thelma|Eisen 4|Doris|Sams 5|Norm|Derringer 6|Ruth|Lessing 7|Dave|Bancroft 8|Jimmie|Foxx 9|Dorothy|Kamenshek 10|Mary|Baker 11|Sophie|Kurys 20|David|Hilbert 12|Clerk|Maxwell 13|Bertrand|Russell 14|Ada|Byron 15|Mary|Everest 16|Gottlob|Frege 17|Ludwig|Wittgenstein 18|Alan|Turing 19|John|Mauchly 28|Winifred|Merrill 21|Sophie|Germain 22|Leonhard|Euler 23|Maxwell|Weber 24|Alonzo|Church 25|Kurt|Godel 26|Sofia|Kovalevskaya 27|Emmy|Noether
__MACOSX/SQL Files/Text Files /._customer.txt
SQL Files/Text Files /library.txt
1|South Branch|500 2|Main|1000 3|North Branch|250 4|East Branch|200 5|West Branch|300 6|River Road|600
__MACOSX/SQL Files/Text Files /._library.txt
SQL Files/Text Files /ReadMe.rtf
Order of values in data files for Part 1 author.txt aid|first|last book.txt booknum|title|pages writes.txt aid|booknum|percent copies.txt copynum|booknum|price customer.txt cid|first|last Additional files for Part 2 library.txt libnum|libname|capacity staff.txt sid|first|last|libnum|mid mid is the manager id. if a staff member has no manage then sid and mid are the same. This way you do not have to deal with importing files with null values. See the assignment text to reset the mid value to null for those staff where it sid and mid value are the same. copiesPart2.txt copynum|booknum|price|libnum These are new copies added as part of part 2. Your copy table should include the data in copies.txt (from part 1) and copiesPart2.txt
__MACOSX/SQL Files/Text Files /._ReadMe.rtf
SQL Files/Text Files /staff.txt
1|Sully|Prudhomme|1|1 2|Theodor|Mommsen|1|1 3|Bjornstjerne|Bjornson|2|1 4|Frederic|Mistral|2|2 5|Jose|Echegaray|2|2 6|Henryk|Sienkiewicz|3|2 7|Giosue|Carducci|4|2 8|Rudyard|Kipling|4|6 9|Rudolf|Eucken|4|6 10|Selma|Lagerior|4|10 11|Rabindranath|Tagore|5|10 20|Thomas|Mann|5|10 12|Ivan|Bunin|5|11 13|Pearl|Buck|5|11 14|Gabriela|Mistral|5|11 15|Andre|Gide|6|11 16|William|Faulkner|6|11 17|Albert|Camus|6|16 18|Boris|Pasternak|6|16 19|Aleksandr|Solzhenitsyn|7|16 28|Odysseas|Elytis|7|16 21|Czeslaw|Milosz|7|19 22|Nadine|Gordimer|8|15 23|Toni|Morrison|8|15 24|Kenzaburo|Oe|8|15 25|Doris|Lessing|9|24 26|Alice|Munro|9|24 27|Patrick|Modiano|9|24
__MACOSX/SQL Files/Text Files /._staff.txt
SQL Files/Text Files /writes.txt
1|1|100 2|2|100 3|3|100 4|4|100 3|5|100 5|6|100 6|7|100 7|8|100 17|9|100 18|10|100 8|11|100 6|12|100 9|13|100 10|14|50 11|14|50 13|15|33 14|15|33 12|15|34 16|16|100 19|17|100
