acusick-p2 - Lab Project 2 Database and Spreadsheet...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Lab Project 2 Database and Spreadsheet Analysis TurnItIn Template Name: Cusick, Andrew Class: MIS 111 Section 1 Project: Project 2 Database and Spreadsheet Analysis E-Tegrity Statement : By submitting this assignment for grading, I state or affirm the work submitted is my own work and that I did not allow another student to copy my work. I understand copying can include directly giving another student a copy of my solution or simply leaving written or electronic copies of my work where another student may find them. Section 1: Edited Database Tables Inventory Table (paste special as HTML): Inventory Part Number Part Name Supplier ID Supplier Part Number Quantity on Hand Warehouse Bin Location Unit Price 32 Power Supply - 550 Watt - up to 85% Efficient 4 BP550 Plus 24 1224 64.99 33 Power Supply - 550 Watt - 80 PLUS Bronze 4 TP-550 25 1225 89.99 34 Power Supply - 850 Watt - 80 PLUS Bronze 4 TPQ-850 97 1225 139.99 35 Memory - 2GB - DDR3 1333 3 BL25664BN1337 316 287 60.99 36 Memory - 2GB - DDR3 1066 3 CT25664BA1067 712 288 56.99 37 Memory - 2GB - DDR3 1666 3 BL25664TG1608 145 289 63.99 40 Motherboard - Intel i7 1 P6X58D Premium 253 16 309.99 41 Motherboard - Intel i7 - supergamer 1 P6T7 WSSuper 735 17 399.99 42 Motherboard - AMD Phenom II 1 M4A78T-E 254 18 119.99 43 Graphics Card - GT 240 1 ENGT240/DI/512MD5/A 945 101 99.99 44 Graphics Card - GTS 250 1 ENGTS250 DK/DI/1G 19 102 149.99 Cusick, Andrew MIS 111 Section 1 Page 1 of 9 Lab Project 2 Database and Spreadsheet Analysis TurnItIn Template Inventory Part Number Part Name Supplier ID Supplier Part Number Quantity on Hand Warehouse Bin Location Unit Price 46 Graphics Card - GTS 250 1 ENGTS250/DI/512MD3 35 104 129.99 47 Case Shell - Mini Tower4 Nine Hundred Two 153 189 139.99 48 Case Shell - Mini Tower4 Three Hundred 543 190 59.95 49 Case Shell - Mini Tower4 Twelve Hundred 345 191 159.99 50 CPU - i7 - 2.66 GHz 2 BX80601920 23 2 288.99 51 CPU - i7 - 3.06 GHz 2 BX80601950 563 3 569.99 52 CPU - i7 - 3.2 GHz 2 BX80601960 296 4 589.99 53 CPU - Phenom II x4 65 watt 5 HD905EOCGIBOX 925 25 174.99 54 CPU - Phenom II x4 95 watt 5 HDX925WFGIBOX 296 26 139.99 55 Raid Controller 3-ware SATA II 6 9650SE-2LP SGL 28 37 179.99 56 Raid Controller 3-ware SATA II 6 9650SE-4LPML KIT 854 38 329.99 57 CPU Fan - Intel i7 (1366) 2 BXSTS100A 194 41 29.45 58 CPU Fan - AMD Phenom II (AM3) 4 N82E16835209019 523 42 34.99 59 Case Fan - 60 mm 4 76006 190 51 4.99 60 Case Fan - 80 mm...
View Full Document

Page1 / 9

acusick-p2 - Lab Project 2 Database and Spreadsheet...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online