USE COMP_your firstname_your last name;
SELECT current_user( ), now( ), database( );
Department Admin and Records Admin and Records Admin and Records Headquarters Production Production Production Production Employee Hyder Amin Marcia Markis Suzanne Joyner Bijoy Bordoloi Dinesh Joshi Sherri Prescott Waiman Zhu Douglas Bock # of Dependents 0 0 1 4 0 0 3 5
Project 20 - Personnel 2-Payroll 1-Order Entry Total Hours 27 43 52 3-Receivables 53 10-Inventory 55 30-Pay Benefits 55
Department Headquarters 1 1 Headquarters 3 Admin and Records 3 Admin and Records 7 Production 7 Production 7 Production Manager Bijoy Bordoloi Bijoy Bordoloi Suzanne Joyner Suzanne Joyner Waiman Zhu Waiman Zhu Waiman Zhu Employee Supervised Waiman Zhu Suzanne Joyner Hyder Amin Marcia Markis Douglas Bock Dinesh Joshi Sherri Prescott
Employee SSN Department Name 999-11-1111 Michelle 999-11-1111 Deanna 999-11-1111 Jeffery 999-11-1111 Rachael 999-44-4444 Andrew Jo Ellen 999-44-4444 999-66-6666 Rita 999-66-6666 Monica 999-66-6666 Anita Birth Date March 17, 1984 May 03, 1981 December 31, 1978 October 04, 1975 October 25, 1998 05, 1996 April May 11, 1994 December 30, 1988 July 06, 1984 Relationship DAUGHTER DAUGHTER SON DAUGHTER SON DAUGHTER DAUGHTER DAUGHTER DAUGHTER
USE COMP_your first name_your last name; SELECT current_user( ), now( ), database( );
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am