Employee Database
Name Position Office Age Start date Salary
Tiger Nixon System Architect Edinburgh 61 2011/04/25 $320,800
Garrett Winters Accountant Tokyo 63 2011/07/25 $170,750
Ashton Cox Junior Technical Author San Francisco 66 2009/01/12 $86,000
Cedric Kelly Senior Javascript Developer Edinburgh 22 2012/03/29 $433,060
Airi Satou Accountant Tokyo 33 2008/11/28 $162,700
Brielle Williamson Integration Specialist New York 61 2012/12/02 $372,000
Herrod Chandler Sales Assistant San Francisco 59 2012/08/06 $137,500
Rhona Davidson Integration Specialist Tokyo 55 2010/10/14 $327,900
Colleen Hurst Javascript Developer San Francisco 39 2009/09/15 $205,500
Sonya Frost Software Engineer Edinburgh 23 2008/12/13 $103,600
Jena Gaines Office Manager London 30 2008/12/19 $90,560
Quinn Flynn Support Lead Edinburgh 22 2013/03/03 $342,000
Charde Marshall Regional Director San Francisco 36 2008/10/16 $470,600
Haley Kennedy Senior Marketing Designer London 43 2012/12/18 $313,500
Tatyana Fitzpatrick Regional Director London 19 2010/03/17 $385,750
Michael Silva Marketing Designer London 66 2012/11/27 $198,500
Paul Byrd Chief Financial Officer (CFO) New York 64 2010/06/09 $725,000
Gloria Little Systems Administrator New York 59 2009/04/10 $237,500
Bradley Greer Software Engineer London 41 2012/10/13 $132,000
Dai Rios Personnel Lead Edinburgh 35 2012/09/26 $217,500
Jenette Caldwell Development Lead New York 30 2011/09/03 $345,000
Yuri Berry Chief Marketing Officer (CMO) New York 40 2009/06/25 $675,000
Caesar Vance Pre-Sales Support New York 21 2011/12/12 $106,450
Doris Wilder Sales Assistant Sydney 23 2010/09/20 $85,600
Angelica Ramos Chief Executive Officer (CEO) London 47 2009/10/09 $1,200,000
Gavin Joyce Developer Edinburgh 42 2010/12/22 $92,575
Jennifer Chang Regional Director Singapore 28 2010/11/14 $357,650
Brenden Wagner Software Engineer San Francisco 28 2011/06/07 $206,850
Fiona Green Chief Operating Officer (COO) San Francisco 48 2010/03/11 $850,000
Shou Itou Regional Marketing Tokyo 20 2011/08/14 $163,000
Product Inventory with Export Options
Product ID Product Name Category Price Stock Status Last Updated
PRD001 iPhone 15 Pro Max Electronics $1,199.00 45 In Stock 2025/01/15
PRD002 Samsung Galaxy S24 Ultra Electronics $1,299.99 32 In Stock 2025/01/14
PRD003 MacBook Pro 16" Computers $2,499.00 12 Low Stock 2025/01/13
PRD004 Dell XPS 15 Computers $1,799.00 8 Low Stock 2025/01/12
PRD005 Sony WH-1000XM5 Audio $399.99 67 In Stock 2025/01/11
PRD006 AirPods Pro 2 Audio $249.00 0 Out of Stock 2025/01/10
PRD007 iPad Pro 12.9" Tablets $1,099.00 23 In Stock 2025/01/09
PRD008 Samsung Tab S9 Ultra Tablets $1,199.99 15 In Stock 2025/01/08
PRD009 LG OLED 65" TV TVs $1,896.99 5 Low Stock 2025/01/07
PRD010 Sony A7 IV Camera Cameras $2,498.00 18 In Stock 2025/01/06
Customer Orders - Responsive Table
Order ID Customer Email Phone Product Quantity Total Status Date
#ORD-001 John Smith [email protected] +1 234-567-8900 iPhone 15 Pro 1 $999.00 Delivered 2025/01/10
#ORD-002 Jane Doe [email protected] +1 234-567-8901 MacBook Pro 1 $2,499.00 Processing 2025/01/11
#ORD-003 Mike Johnson [email protected] +1 234-567-8902 AirPods Pro 2 $498.00 Pending 2025/01/12
#ORD-004 Sarah Williams [email protected] +1 234-567-8903 iPad Pro 1 $1,099.00 Delivered 2025/01/09
#ORD-005 Robert Brown [email protected] +1 234-567-8904 Sony WH-1000XM5 1 $399.99 Cancelled 2025/01/08
#ORD-006 Emily Davis [email protected] +1 234-567-8905 Samsung Galaxy S24 1 $1,199.99 Processing 2025/01/13
#ORD-007 David Wilson [email protected] +1 234-567-8906 Dell XPS 15 1 $1,799.00 Delivered 2025/01/07
#ORD-008 Lisa Anderson [email protected] +1 234-567-8907 LG OLED TV 1 $1,896.99 Pending 2025/01/14