management information system and app
Mo7ammedaziz 
a04t1Phones.accdb| ColorID | Color |
|---|---|
| 1 | Black |
| 2 | Blue |
| 3 | Pearl |
| 4 | Silver |
| 5 | White |
| TypeOfDevice | DeviceDescription |
|---|---|
| A | Accessory |
| M | MP3 Player |
| P | Phone |
| InventoryID | TypeOfDevice | ManufacturerID | Model | ColorID | PurchaseDate | Features | PurchasePrice | AskingPrice | SellingPrice | BuyerName | SellDate | Photo |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | P | 2 | EVO 3D | 1 | 1/1/12 | Uneven call quality doesn't stop the EVO 3D from being the best phone currently available on Sprint. | ¤ 150.00 | ¤ 165.00 | ¤ 150.00 | Jim Everly | 6/1/12 | |
| 2 | P | 2 | ThunderBolt | 1 | 3/5/12 | The well-appointed ThunderBolt is the phone to buy if you want to see what 4G can do. | ¤ 50.00 | ¤ 70.00 | ||||
| 3 | P | 2 | Sensation 4G | 4 | 6/1/13 | The Sensation delights with a gorgeous display, a beautiful design, and dual-core power, but possible “death grip” issues are worrisome. | ¤ 25.00 | ¤ 99.99 | ¤ 69.50 | Susan Dykas | 7/5/13 | |
| 4 | P | 6 | G2x | 1 | 9/18/12 | The T-Mobile G2X is a no-frills powerhouse that excels at gaming, multitasking and video. | ¤ 48.00 | ¤ 145.00 | ||||
| 5 | P | 3 | Atrix 4G | 1 | 2/5/12 | This dual-core phone is fast and boasts solid data speeds, but the Atrix-powered laptop accessory is a good idea poorly executed. | ¤ 26.00 | ¤ 55.00 | ¤ 43.00 | Ralph Borden | 5/7/12 | |
| 6 | P | 5 | Charge | 1 | 4/28/13 | The LTE speeds dazzle, the AMOLED display shines, and you get a free mobile hotspot at least for a little while. What’s not to like? Well, the battery life disappoints, but that may not be enough to spoil the fun. | ¤ 15.00 | ¤ 35.00 | ||||
| 7 | P | 6 | myTouch 4G Slide | 2 | 10/31/11 | The myTouch 4G Slide has one of the best cameras we've ever tested--and the rest of the phone is pretty amazing as well. | ¤ 55.00 | ¤ 125.00 | ||||
| 8 | P | 5 | Epic 4G | 1 | 11/25/11 | The standout of the Galaxy S phones, the Epic 4G offers some enticing features like a physical keyboard, front-facing camera and 4G network support. | ¤ 20.00 | ¤ 25.00 | ¤ 25.00 | Alicia Myers | 11/26/11 | |
| 9 | P | 6 | myTouch 4G | 1 | 2/14/12 | The powerful myTouch 4G delivers when it comes to multimedia and performance, but make sure you live in an HSPA+-supported area before purchasing it. | ¤ 10.00 | ¤ 22.00 | ¤ 19.00 | Miguel Angeles | 3/18/12 | |
| 10 | P | 1 | 16GB iPhone 4 | 1 | 3/3/13 | The Verizon iPhone 4 is a major upgrade from its predecessor, the iPhone 3GS, in everything from the camera quality to data speeds. | ¤ 120.00 | ¤ 250.00 | ||||
| 11 | M | 1 | iPod | 2 | 6/13/10 | 4GB memory; headphones; good condition. | ¤ 12.00 | ¤ 49.00 | ||||
| 12 | A | 4 | Aviator | 1 | 11/12/11 | The remote and mic are supported only by iPod nano (4th generation and later), iPod classic (120GB, 160GB), iPod touch (2nd generation and later), iPhone 3GS, iPhone 4, iPad and iPad 2. | ¤ 47.00 | ¤ 112.00 | ||||
| 13 | P | 5 | Glyde U940 | 1 | 6/29/12 | Good camera. | ¤ 26.00 | ¤ 45.00 | ||||
| 14 | A | 1 | Head Phones | 5 | 7/19/12 | Basic head phones that come with iPod. | ¤ 5.00 | ¤ 10.00 | ||||
| 15 | P | 1 | iPhone 3 | 3 | 8/15/12 | No scratches. | ¤ 23.00 | ¤ 88.00 | ||||
| 16 | P | 1 | iPhone 4 | 2 | 9/2/12 | Comes with case and 2 charges. | ¤ 31.00 | ¤ 125.00 | ||||
| 17 | P | 3 | Motorola i576 | 1 | 9/15/11 | No scratches. | ¤ 42.99 | ¤ 75.00 | ||||
| 18 | P | 7 | Nextel i930 | 4 | 9/15/11 | No scratches. | ¤ 54.99 | ¤ 75.00 | ||||
| 19 | P | 3 | Motorola i890 | 1 | 9/15/11 | No scratches. | ¤ 109.99 | ¤ 125.00 | ||||
| 20 | P | 7 | Nextel Brute i680 | 1 | 9/15/11 | No scratches. | ¤ 109.99 | ¤ 125.00 | ||||
| 21 | P | 7 | Nextel i776 | 1 | 9/15/11 | No scratches. | ¤ 49.99 | ¤ 75.00 |
| ID | LastName | FirstName | Address | City | State | Zip |
|---|---|---|---|---|---|---|
| 1 | Clark | Charles | 1106 Belsey Street | Alpine | NJ | 07620 |
| 2 | Cruz | Adolfo | 182 Huffman Road | National Park | NJ | 08063 |
| 3 | Kato | Tadashi | 397 Babs Court | Belvidere | NJ | 07823 |
| 4 | Rangan | Abhinav | 12 Sue Tawn Drive | Camden | NJ | 08104 |
| 5 | Suzuki | Hiroshi | 436 James Way | Browns Mills | NJ | 08015 |
| 6 | Yamamoto | Akira | 415 Brandywine Avenue | Richwood | NJ | 08074 |
| 7 | Mehta | Ashwin | 191 Stamps Circle | Newark | NJ | 07108 |
| 8 | Abdoo | Nabila | 179 Icefall Drive | New Lisbon | NJ | 08064 |
| 9 | Mitchell | Betty | 913 Pinebrook Circle | Neptune | NJ | 07754 |
| 10 | Haddad | Rabab | 1025 Cache Drive | Newark | NJ | 07112 |
| 11 | Lee | Yon | 924 Sundi Drive | Greenwich | NJ | 08323 |
| 12 | Ortiz | Alfonso | 995 Lander Place | Chester | NJ | 07930 |
| 13 | Hannah | Casilda | 75 Eris Drive | Audubon | NJ | 08106 |
| 14 | Han | Min | 373 Lobdell Street | Newark | NJ | 07199 |
| 15 | Chen | Jie | 527 Chester Court | Allamuchy | NJ | 07820 |
| 16 | Hwang | Kyu | 1062 Loren Circle | Chatham | NJ | 07928 |
| 17 | Lin | Jiao | 543 Brittany Place | Green Creek | NJ | 08219 |
| 18 | Daher | Cala | 44 Chad Street | Lincroft | NJ | 07738 |
| 19 | Hassan | Elmira | 1101 Brien Street | Bradley Beach | NJ | 07720 |
| 20 | Kwon | Min | 495 Trisha Avenue | Cape May Court House | NJ | 08210 |
| 21 | Song | Shik | 875 Mego Street | Cape May Court House | NJ | 08210 |
| 22 | Chen | Gang | 724 Howard Circle | Camden | NJ | 08102 |
| 23 | Choi | Shin | 801 Lafayette Circle | Asbury Park | NJ | 07712 |
| 24 | Hajjar | Rabiah | 1180 Madelynne Way | Browns Mills | NJ | 08015 |
| 25 | Evans | Donald | 427 Nautilus Court | Lyndhurst | NJ | 07071 |
| 26 | Rangarajan | Arun | 865 Avion Street | Woodbine | NJ | 08270 |
| 27 | Hamieh | Candy | 974 Peters Creek Road | Mountainside | NJ | 07092 |
| 28 | Flores | Reina | 433 Cange Street | Cresskill | NJ | 07626 |
| 29 | Pillai | Pavithra | 768 Denali Street | Newark | NJ | 07192 |
| 30 | Rangan | Gayatri | 734 Kissee Court | Villas | NJ | 08251 |
| 31 | Sasaki | Takashi | 83 Serenity Circle | Hackettstown | NJ | 07840 |
| 32 | Zhou | Dai | 292 Charlotte Circle | Summit | NJ | 07902 |
| 33 | Rodriguez | Carol | 568 Duncanshire Place | Manahawkin | NJ | 08050 |
| 34 | Rodriguez | Betty | 897 Core Court | Pompton Plains | NJ | 07444 |
| 35 | Mitchell | Anthony | 47 Rangeview Avenue | Little Ferry | NJ | 07643 |
| 36 | Hu | Gang | 849 Brittany Rock Way | Norwood | NJ | 07648 |
| 37 | Cruz | Rodrigo | 805 Concrete Street | North Bergen | NJ | 07047 |
| 38 | Choi | Kyong | 1127 Telephone Avenue | Demarest | NJ | 07627 |
| 39 | Hassan | Candy | 661 Concourse Street | Avon By The Sea | NJ | 07717 |
| 40 | Kimura | Yukio | 441 Toadstool Turnpike | Verona | NJ | 07044 |
| 41 | Sun | Huan | 1067 Hillhaven Circle | Riverdale | NJ | 07457 |
| 42 | Hong | Jung | 498 Greenland Drive | Leesburg | NJ | 08327 |
| 43 | Martin | James | 440 Glenn Circle | Columbus | NJ | 08022 |
| 44 | Watanabe | Hideo | 630 Sparkle Drive | Elmwood Park | NJ | 07407 |
| 45 | Azzi | Loelia | 150 Jayme Court | Long Valley | NJ | 07853 |
| 46 | Ma | Lian | 980 Byrd Lane | Jersey City | NJ | 07307 |
| 47 | Hu | Chan | 1119 Rosemont Drive | Oaklyn | NJ | 08107 |
| 48 | Zhou | Cai | 1108 Compassion Circle | Lumberton | NJ | 08048 |
| 49 | Yoshida | Akira | 121 Seacloud Circle | Dorchester | NJ | 08316 |
| 50 | Inoue | Koichi | 708 Penland Parkway | Grenloch | NJ | 08032 |
| 51 | Kim | Ryung | 223 Ferndale Street | West Orange | NJ | 07052 |
| 52 | Suzuki | Kiyoshi | 996 Quiet Way | Clayton | NJ | 08312 |
| 53 | Bishara | Lila | 562 Gardenia Court | Millington | NJ | 07946 |
| 54 | Shimizu | Akira | 1002 Redpole Circle | Saddle Brook | NJ | 07663 |
| 55 | Patil | Priyanka | 322 Lakeridge Circle | Morristown | NJ | 07960 |
| 56 | Rivera | Alvaro | 452 Contrary Court | Englewood | NJ | 07631 |
| 57 | Ma | Liang | 609 Lyvona Lane | Gibbstown | NJ | 08027 |
| 58 | Kimura | Akira | 990 Kerry Circle | Dover | NJ | 07802 |
| 59 | Garcia | Rodrigo | 612 Fulton Drive | Haddon Heights | NJ | 08035 |
| 60 | Ito | Minoru | 144 Omega Mine Circle | Winslow | NJ | 08095 |
| 61 | Sun | Kang | 1011 Hamann Road | Green Village | NJ | 07935 |
| 62 | Thomas | Helen | 263 Bear View Place | Browns Mills | NJ | 08015 |
| ManufacturerID | Manufacturer |
|---|---|
| 1 | Apple |
| 2 | HTC |
| 3 | Motorola |
| 4 | Rocnation |
| 5 | Samsung |
| 6 | T-Mobile |
| 7 | Nextel |
