BCIS 3610

nathanqiu
Assignment1_tables.xlsx

Department

Department
DNO Dname Address City State Zip
1 Accounting 762 Destiny way Westlake TX 76062
2 Finance 762 Destiny way Westlake TX 76062
3 Sales 850 Cambell Rd Richardson TX 75080
4 I.T. 2210 Main St Dallas TX 75023
5 Marketing 850 Cambell Rd Richardson TX 75080
6 HR 762 Destiny way Westlake TX 76062
7 Legal 2210 Main St Dallas TX 75023
8 Facility Mgmt 762 Destiny way Westlake TX 76062

Employee

Emp ID Name Prefix First Name Middle Initial Last Name Gender EMail DOB HireDate Salary SSN PhoneNo UserName Title DNO
677509 Drs. Lois H Walker F lois.walker@hotmail.com 3/29/81 11/24/03 168251 467-99-4677 303-572-8492 lhwalker Sr. Director 5
940761 Ms. Brenda S Robinson F brenda.robinson@gmail.com 7/31/70 7/27/08 51063 537-71-4566 225-945-4954 bsrobinson Accountant 1
428945 Dr. Joe W Robinson M joe.robinson@gmail.com 6/16/63 8/3/16 50155 025-92-3584 219-904-2161 jwrobinson Accountant 1
408351 Drs. Diane I Evans F diane.evans@yahoo.com 12/4/77 4/16/99 180294 314-35-9851 215-793-6791 dievans SVP Marketing 5
193819 Mr. Benjamin R Russell M benjamin.russell@charter.net 4/17/77 7/25/13 117642 121-98-7248 262-404-2252 brrussell Sr. Manager 4
499687 Mr. Patrick F Bailey M patrick.bailey@aol.com 9/27/82 7/22/05 72305 439-99-7721 319-812-6957 pfbailey Programmer 4
539712 Ms. Nancy T Baker F nancy.baker@bp.com 6/13/95 9/14/16 98189 641-29-2071 229-336-5117 ntbaker Project Manager 4
380086 Mrs. Carol V Murphy F carol.murphy@gmail.com 6/30/58 1/28/83 60918 423-67-7023 216-336-0009 cvmurphy Marketing Analyst 5
477616 Hon. Frances B Young F frances.young@gmail.com 6/9/59 4/27/94 121587 028-92-8912 210-819-9765 fbyoung Sr. Attornet 7
162402 Hon. Diana T Peterson F diana.peterson@hotmail.co.uk 11/13/87 2/17/14 43010 512-33-6767 479-783-5656 dtpeterson Recruiter 6
231469 Mr. Ralph L Flores M ralph.flores@yahoo.com 2/5/75 4/14/09 118457 302-15-0130 316-280-2864 rlflores Sr. Attorney 7
153989 Prof. Jack C Alexander M jack.alexander@gmail.com 5/19/95 1/5/17 82965 428-99-9413 702-603-3769 jcalexander HR Manager 6
386158 Mrs. Melissa Q King F melissa.king@comcast.net 2/24/72 11/24/15 166892 277-17-9106 216-605-3731 mqking SVP HR 6
301576 Hon. Wayne G Watson M wayne.watson@gmail.com 6/26/96 7/19/17 92758 011-94-6649 701-231-9370 wgwatson Sr. Recruiter 6
441771 Mrs. Cheryl O Scott F cheryl.scott@gmail.com 2/23/58 11/26/90 92220 596-94-2279 215-288-9345 coscott Manager Funds 2
528509 Hon. Paula G Diaz F paula.diaz@gmail.com 8/22/66 8/22/94 152654 234-57-7671 252-531-7641 pgdiaz Fund Director 2
912990 Mr. Joshua T Stewart M joshua.stewart@yahoo.ca 5/18/70 9/2/02 184896 755-07-3676 217-279-9342 jtstewart Finance Chair 2
214352 Ms. Theresa G Lee F theresa.lee@gmail.com 12/5/92 1/19/15 197537 055-02-9969 319-553-8919 tglee CFO 2
890290 Hon. Julia S Scott F julia.scott@apple.com 7/15/59 2/23/05 141518 251-99-1941 423-939-1010 jsscott Director Audit 1
622406 Mr. Thomas Q Lewis M thomas.lewis@gmail.com 10/4/67 6/7/98 73862 467-99-2604 314-679-3697 tqlewis Audit Analyst 1
979607 Ms. Carol J Edwards F carol.edwards@msn.com 12/14/94 4/25/16 93967 316-35-9870 225-283-4295 cjedwards Fraud Analyst 2
969580 Prof. Matthew L Turner M matthew.turner@gmail.com 10/26/93 2/7/16 52237 598-92-1988 236-972-7624 mlturner Auditor I 1
426038 Hon. Joan C Stewart F joan.stewart@yahoo.com 11/20/72 12/30/09 111673 429-99-6443 216-637-6800 jcstewart Investment Advisor 2
388642 Mrs. Ruby R Rogers F ruby.rogers@gmail.com 5/1/80 8/30/13 160623 236-55-0172 423-231-6507 rrrogers Fund Rel. Mgr. 2
560455 Ms. Carolyn V Hayes F carolyn.hayes@hotmail.co.uk 3/10/58 7/3/01 42005 730-28-1350 239-882-8784 cvhayes Admin Assistant 1
477253 Mrs. Anne L Russell F anne.russell@ibm.com 7/29/89 11/24/13 103160 456-99-5619 605-635-1306 alrussell Real Estate Fund Mgr. 2
263480 Hon. Daniel K Cooper M daniel.cooper@yahoo.com 1/1/90 3/6/14 153790 181-86-2024 701-510-8162 dkcooper BioTech Fund Mgr. 2
683826 Mr. Roger L Roberts M roger.roberts@gmail.com 7/7/69 1/29/09 129625 120-98-6493 206-497-3141 rlroberts Tech Fund Mgr. 2
474599 Drs. Maria W Walker F maria.walker@microsoft.com 3/19/75 10/1/98 48944 447-27-3175 423-668-5506 mwwalker Mainframe Programmer 4
335732 Ms. Brenda M Butler F brenda.butler@gmail.com 12/6/63 8/20/87 60508 282-15-6434 480-814-8284 bmbutler Programmer Analyst I 4
329752 Hon. Lillian X Brown F lillian.brown@aol.com 5/12/81 4/13/15 67251 249-99-8821 239-812-9041 lxbrown Sales Associate 3
893212 Ms. Amy B Howard F amy.howard@aol.com 6/16/81 6/1/03 112715 686-24-2843 803-613-3168 abhoward Manager Portfolio Sales 3
621833 Mr. Gregory X Edwards M gregory.edwards@outlook.com 8/31/93 9/30/15 169245 010-94-6817 503-256-9654 gxedwards Director IRA Sales 3
456747 Mr. Roy Z Griffin M roy.griffin@yahoo.com 5/8/91 8/23/12 170895 358-08-7660 219-506-9378 rzgriffin Director Portfolio Sales 3
278556 Prof. Richard Y Mitchell M richard.mitchell@verizon.net 7/28/93 8/18/16 122226 013-94-5886 205-621-5884 rymitchell Manager IRA Sales 3
333476 Hon. Mary P Wilson F mary.wilson@sbcglobal.net 12/1/67 12/22/91 109394 198-84-0652 423-937-8660 mpwilson Sr. Sales Associate 3
218791 Mr. Aaron N Price M aaron.price@bp.com 2/10/69 7/3/97 54402 491-29-5152 219-287-8926 anprice Marketing Analyst 5
134841 Ms. Donna R Brown F donna.brown@aol.com 9/14/83 7/17/13 129836 544-81-5182 212-434-7910 drbrown Sr. Sales Associate 3
726264 Hon. Carl N Collins M carl.collins@yahoo.com 12/22/73 6/9/07 162159 544-81-6171 479-740-7633 cncollins Director Brokerage Sales 3
766610 Ms. Joyce E Jenkins F joyce.jenkins@aol.com 8/22/61 5/14/10 119321 695-16-6506 262-455-4187 jejenkins Sr. Sales Associate 3
923947 Ms. Mary G Bryant F mary.bryant@verizon.net 6/21/62 5/20/04 155442 491-29-7461 319-827-3516 mgbryant VP Budgets 2
227922 Hon. Amanda M Hughes F amanda.hughes@rediffmail.com 7/29/82 4/19/07 114257 311-35-2540 225-544-9700 amhughes Manager Budgets and Fin 2
265813 Hon. Jack E Campbell M jack.campbell@gmail.com 1/4/85 7/29/07 186280 047-15-1537 316-499-5737 jecampbell SVP Infrastructure 4
247137 Mr. Alan E Rivera M alan.rivera@apple.com 12/11/78 6/7/06 154810 399-31-7149 423-277-6819 aerivera VP Storage and Computing 4
407061 Ms. Elizabeth Q Jackson F elizabeth.jackson@aol.com 8/15/64 1/19/05 85420 660-24-4434 603-568-6118 eqjackson Sales Associate 3
226714 Drs. Nancy L Davis F nancy.davis@ibm.com 11/14/83 8/25/12 94986 224-99-5928 219-610-3067 nldavis HR Compliance Manager 6
702813 Mr. Ernest D Martinez M ernest.martinez@gmail.com 11/9/89 1/24/16 172098 672-48-7749 479-951-4138 edmartinez Patent Attorney 7
524896 Ms. Judy Y Hernandez F judy.hernandez@gmail.com 3/25/61 12/27/11 133332 534-71-4481 316-736-6126 jyhernandez Director Insights 4
363065 Drs. Nancy L Jones F nancy.jones@gmail.com 11/10/93 10/16/15 61924 681-24-3165 212-825-1930 nljones Accountant 1
704709 Dr. Harold Z Nelson M harold.nelson@gmail.com 12/24/84 8/23/11 156194 456-99-2066 217-555-9216 hznelson Board Advisor
461593 Ms. Nicole O Ward F nicole.ward@yahoo.com 12/12/64 1/23/89 95673 196-84-2551 231-761-7861 noward Board Advisor
392491 Mrs. Theresa R Murphy F theresa.murphy@gmail.com 12/30/87 8/3/10 51015 249-99-8801 907-356-1555 trmurphy Admin Assistant BOD
495141 Drs. Tammy B Young F tammy.young@comcast.net 3/22/79 4/25/15 93650 771-02-7046 231-290-3075 tbyoung Board Advisor