EmployeeID(PK) First Name Middle Initial Last Name Department Number(FK) Job Code(FK)
10015 Frank  P Furter PL L1M
10016 Scrappy Q  Doo PL L1C
10017 Daphne  A Blake PL SR
10018 Shaggy A  Rogers MKT MA
10019 Scooby  X Doo WH L2M
10020 Fred  M Flintstone CO L1C
10021 Wilma  Z Flintstone MKT L2M
10022 Barney C  Rubble PL L3M
10023 Betty L  Rubble PL L2C
10024 Geoge  L Jetson PL SR
10025 Judy  J Jetson WH MA
99999 Corporate Office CO CO