diff --git a/STINK_student_records/Test_classes/Assessment/STINK_student_records__Fixture_Assessment.xml b/STINK_student_records/Test_classes/Assessment/STINK_student_records__Fixture_Assessment.xml new file mode 100644 index 0000000..a16bbbc --- /dev/null +++ b/STINK_student_records/Test_classes/Assessment/STINK_student_records__Fixture_Assessment.xml @@ -0,0 +1,486 @@ + + + staff_id + surname + firstnames + phone + address + department + position + salary + comments + + 326 + Dyson + Sang Russell + 16139414116 + 74 Patmos Avenue + Manufacturing + Designer + 39278.42 + Good worker. + + + 327 + Soto + Teresa Stephanie + 16137076169 + 21 Elwyn Crescent + Inventory + Technician + 34254.4 + + + + 328 + Kwak + Patricia Helen + 16137254888 + 28 Cherry Drive + Manufacturing + Technician + 3809.79 + Excellent negotiator. + + + 329 + Reed + John Clifford + 16136507402 + 45 Pine Hill Road + Manufacturing + Researcher + 1246.01 + Argumentative. + + + 330 + Barajas + Charles William + 16132104933 + 34 Scobie Road + Manufacturing + Technician + 36551.12 + + + + 332 + Alexander + Mary Margaret + 16134041369 + 166 Moray Place + Inventory + Assembler + 52187.45 + + + + 333 + Hopkins + Michael Alex + 16134838045 + 67 Burgess Street + Manufacturing + Designer + 21964.16 + + + + 334 + Repollet + Kit Elsie + 16138136462 + 38 Massey Avenue + Manufacturing + Contractor + 33283.56 + + + + 331 + Ross + Tanya Johanna + 16137684316 + 107 Braeview Crescent + Sales & Marketing + Designer + 46555.36 + Lazy and shiftless. + + + 335 + Black + William Melvin + 16136246576 + 54 Koremata Street + Manufacturing + Researcher + 47618.8 + + +
+ + customer_id + name + contact_person + phone + address + email + comments + + 303 + GloboSolv + Sanchez, Sherry Sue + 61134253199 + 237 Princes Street + kyddxh@crvvio.invalid + Best. Customer. Ever. + + + 304 + Swanson Doughty + Revell, Charlotte Brandi + 61134254319 + 76 Dey Street + wsxkfh@gwmizf.invalid + Disputes almost every transaction. + + + 305 + Megatronix + Hunt, Bruce Michael + 61134255613 + 235 Campbells Road + zktazb@acpkwy.invalid + + + + 306 + HEE + Place, Kristin Phoebe + 61134253473 + 49 Gorman Street + pwjgqp@mibgxa.invalid + + + + 307 + Bell, Savary & Avila + Mawson, Ursula Frances + 61134251399 + 15 Melrose Street + kpykjf@ajgjlh.invalid + One of our top buyers. + + + 308 + Hypertron + Bitter, Ella Alice + 61134256623 + 38 Beverley Place + wlagwx@zrhgcd.invalid + + + + 309 + SEA + Tejada, Ruby Michelle + 61134257648 + 46 Edith Street + agvggg@ejdokk.invalid + Remember to ask after the children. + + + 310 + AIM + Mcdevitt, Thomas Nathan + 61134255401 + 190 Paterson Road + qrfayc@mjkopx.invalid + + + + 311 + Ultratronics + Huynh, Oscar Robert + 61134259431 + 79 Craigleith Street + syxxjk@brwuzu.invalid + + + + 312 + InterLite + Montgomery, Kyle Williams + 61134253114 + 127 Lombardy Street + mszdvk@hhyzyl.invalid + + +
+ + product_code + description + stock_count + restock_level + minimum_level + list_price + assembly_manual + assembly_program + + 237 + electrostatic wireless headphones + 542 + 393 + 245 + 63.91 + 00 + 00 + + + 238 + noise-cancelling headphones + 410 + 376 + 169 + 55.89 + 00 + 00 + + + 239 + 8-port 10/100/1000 Mb/s Ethernet hub + 627 + 517 + 223 + 22.7 + 00 + 00 + + + 240 + home theatre system + 469 + 458 + 214 + 16.41 + 00 + 00 + + + 241 + amplifier + 494 + 554 + 230 + 40.93 + 00 + 00 + + + 242 + dynamic microphone + 608 + 566 + 111 + 2 + 00 + 00 + + + 243 + fog machine + 85 + 418 + 126 + 41.24 + 00 + 00 + + + 244 + 5-port 10/100/1000 Mb/s Ethernet switch + 72 + 419 + 168 + 54.35 + 00 + 00 + + + 245 + 16-port 10/100/1000 Mb/s Ethernet hub + 318 + 432 + 128 + 44.48 + 00 + 00 + + + 246 + electrostatic BlueTooth noise-cancelling headphone + 634 + 365 + 107 + 2 + 00 + 00 + +
+ + sale_num + sale_date + status + staff_id + customer_id + comments + + 223 + 22-JAN-2011 + shipped + 332 + 306 + + + + 891 + 13-SEP-2011 + shipped + 326 + 308 + + + + 1199 + 31-DEC-2011 + shipped + 331 + 304 + + + + 1882 + 08-MAR-2011 + shipped + 333 + 308 + Slight delay on shipping. + + + 2538 + 19-DEC-2011 + shipped + 334 + 312 + + + + 4185 + 12-MAR-2012 + shipped + 329 + 311 + + + + 4992 + 26-APR-2012 + shipped + 327 + 311 + First shipment lost; reshipped. + + + 5589 + 09-JUL-2011 + shipped + 330 + 309 + + + + 5709 + 13-JUN-2011 + shipped + 331 + 305 + + + + 6613 + 24-JUN-2011 + shipped + 335 + 310 + + +
+ + sale_num + product_code + quantity + actual_price + + 223 + 237 + 370 + 65.93 + + + 891 + 237 + 1665 + 54.33 + + + 1199 + 237 + 1198 + 59.83 + + + 1882 + 237 + 808 + 66.03 + + + 2538 + 237 + 1801 + 54.51 + + + 4185 + 237 + 1306 + 67.02 + + + 4992 + 237 + 1087 + 66.8 + + + 5589 + 237 + 1376 + 55.82 + + + 5709 + 237 + 897 + 59.25 + + + 6613 + 237 + 1091 + 63.54 + +
+