answer q

profilebasil101516
oracle_student_tables.xls
Home>Computer Science homework help>answer q

Employees, Departments, etc

employees
EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
100 Steven King SKING 515.123.4567 17-Jun-87 AD_PRES 24000 90
101 Neena Kochhar NKOCHHAR 515.123.4568 21-Sep-89 AD_VP 17000 100 90
102 Lex De Haan LDEHAAN 515.123.4569 13-Jan-93 AD_VP 17000 100 90
103 Alexander Hunold AHUNOLD 590.423.4567 3-Jan-90 IT_PROG 9000 102 60
104 Bruce Ernst BERNST 590.423.4568 21-May-91 IT_PROG 6000 103 60
107 Diana Lorentz DLORENTZ 590.423.5567 7-Feb-99 IT_PROG 4200 103 60
124 Kevin Mourgos KMOURGOS 650.123.5234 16-Nov-99 ST_MAN 5800 100 50
141 Trenna Rajs TRAJS 650.121.8009 17-Oct-95 ST_CLERK 3500 124 50
142 Curtis Davies CDAVIES 650.121.2994 29-Jan-97 ST_CLERK 3100 124 50
143 Randall Matos RMATOS 650.121.2874 15-Mar-98 ST_CLERK 2600 124 50
144 Peter Vargas PVARGAS 650.121.2004 9-Jul-98 ST_CLERK 2500 124 50
149 Eleni Zlotkey EZLOTKEY 011.44.1344.429018 29-Jan-00 SA_MAN 10500 0.2 100 80
174 Ellen Abel EABEL 011.44.1644.429267 11-May-96 SA_REP 11000 0.3 149 80
176 Jonathon Taylor JTAYLOR 011.44.1644.429265 24-Mar-98 SA_REP 8600 0.2 149 80
178 Kimberely Grant KGRANT 011.44.1644.429263 24-May-99 SA_REP 7000 0.15 149
200 Jennifer Whalen JWHALEN 515.123.4444 17-Sep-87 AD_ASST 4400 101 10
201 Michael Hartstein MHARTSTE 515.123.5555 17-Feb-96 MK_MAN 13000 100 20
202 Pat Fay PFAY 603.123.6666 17-Aug-97 MK_REP 6000 201 20
205 Shelley Higgins SHIGGINS 515.123.8080 7-Jun-94 AC_MGR 12000 101 110
206 William Gietz WGIETZ 515.123.8181 7-Jun-94 AC_ACCOUNT 8300 205 110
departments jobs
DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY
10 Administration 200 1700 AD_PRES President 20000 40000
20 Marketing 201 1800 AD_VP Administration Vice President 15000 30000
50 Shipping 124 1500 AD_ASST Administration Assistant 3000 6000
60 IT 103 1400 AC_MGR Accounting Manager 8200 16000
80 Sales 149 2500 AC_ACCOUNT Public Accountant 4200 9000
90 Executive 100 1700 SA_MAN Sales Manager 10000 20000
110 Accounting 205 1700 SA_REP Sales Representative 6000 12000
190 Contracting 1700 ST_MAN Stock Manager 5500 8500
ST_CLERK Stock Clerk 2000 5000
IT_PROG Programmer 4000 10000
MK_MAN Marketing Manager 9000 15000
MK_REP Marketing Representative 4000 9000
locations
LOCATION_ID STREET_ADDRESS POSTAL_CODE CITY STATE_PROVINCE COUNTRY_ID
1400 2014 Jabberwocky Rd 26192 Southlake Texas US
1500 2011 Interiors Blvd 99236 South San Francisco California US
1700 2004 Charade Rd 98199 Seattle Washington US
1800 460 Bloor St. W. ON M5S 1X8 Toronto Ontario CA
2500 Magdalen Centre, The Oxford Science Park OX9 9ZB Oxford Oxford UK
job_grades regions
GRADE_LEVEL LOWEST_SAL HIGHEST_SAL REGION_ID REGION_NAME
A 1000 2999 1 Europe
B 3000 5999 2 Americas
C 6000 9999 3 Asia
D 10000 14999 4 Middle East and Africa
E 15000 24999
F 25000 40000
countries job_history
COUNTRY_ID COUNTRY_NAME REGION_ID EMPLOYEE_ID START_DATE END_DATE JOB_ID DEPARTMENT_ID
CA Canada 2 102 13-Jan-93 24-Jul-98 IT_PROG 60
DE Germany 1 101 21-Sep-89 27-Oct-93 AC_ACCOUNT 110
UK United Kingdom 1 101 28-Oct-93 15-Mar-97 AC_MGR 110
US United States of America 2 201 17-Feb-96 19-Dec-99 MK_REP 20
114 24-Mar-98 31-Dec-99 ST_CLERK 50
122 1-Jan-99 31-Dec-99 ST_CLERK 50
200 17-Sep-87 17-Jun-93 AD_ASST 90
176 24-Mar-98 31-Dec-98 SA_REP 80
176 1-Jan-99 31-Dec-99 SA_MAN 80
200 1-Jul-94 31-Dec-98 AC_ACCOUNT 90

Global Fast Food (f_tables)

f_customers
ID FIRST_NAME LAST_NAME ADDRESS CITY STATE ZIP PHONE_NUMBER
123 Cole Bee 123 Main Street Orlando FL 32838 4075558234
456 Zoe Twee 1009 Oliver Avenue Boston MA 12889 7098675309
f_food_items
FOOD_ITEM_NUMBER DESCRIPTION PRICE REGULAR_CODE PROMO_CODE
90 Fries 1.09 20
93 Strawberry Shake 3.59 110
f_orders
ORDER_NUMBER ORDER_DATE ORDER_TOTAL CUST_ID STAFF_ID
5678 10-Dec-02 103.02 123 12
f_order_lines f_shifts
ORDER_NUMBER FOOD_ITEM_NUMBER QUANTITY CODE DESCRIPTION
5678 90 2 1 8am to 12pm
2 6pm to 10pm
f_promotional_menus
CODE NAME START_DATE END_DATE GIVE_AWAY
100 Back to School 1-Sep-04 30-Sep-04 ballpen and highlighter
110 Valentines Special 10-Feb-04 15-Feb-04 small box of chocolates
f_regular_menus f_shift_assignments
CODE TYPE HOURS_SERVED CODE ID SHIFT_ASSIGN_DATE
10 Breakfast 6-11am 1 12 6-May-04
20 Lunch/Dinner 11-9pm
f_staffs
ID FIRST_NAME LAST_NAME BIRTHDATE SALARY OVERTIME_RATE TRAINING
12 Sue Doe 1-Jul-80 6.75 10.25
9 Bob Miller 19-Mar-79 10 Grill
19 Monique Tuttle 30-Mar-69 60
f_staffs (cont.)
STAFF_TYPE MANAGER_ID MANAGER_BUDGET MANAGER_TARGET
Order Taker 19
Cook 19
Manager 50000 70000

DJs on Demand (d_tables)

d_cds d_job_assignments
CD_NUMBER TITLE PRODUCER YEAR PARTNER_ID EVENT_ID JOB_DATE STATUS
90 The Celebrants Live in Concert Old Town Records 1997 11 105 2-Feb-04 Visited
91 Party Music for All Occasions The Music Man 2000
92 Back to the Shire Middle Earth Records 2002 d_packages
93 Songs from My Childhood Old Town Records 1999 CODE LOW_RANGE HIGH_RANGE
94 Carpe Diem R&B Inc. 2000 79 500 2500
95 Here Comes the Bride The Music Man 2001 87 2501 5000
96 Graduation Songbook Tunes Are Us 1998 112 5001 10000
98 Whirled Peas Old Town Records 2004 200 10001 15000
d_clients
CLIENT_NUMBER FIRST_NAME LAST_NAME PHONE EMAIL
5922 Hiram Peters 3715832249 [email protected]
5857 Serena Jones 7035335900 [email protected]
6133 Lauren Vigil 4072220090 [email protected]
d_events
ID NAME EVENT_DATE DESCRIPTION COST VENUE_ID PACKAGE_CODE THEME_CODE CLIENT_NUMBER
100 Peters Graduation 14-May-04 Party for 200, red, white, blue motif 8000 100 112 200 5922
105 Vigil wedding 28-Apr-04 Black tie at Four Season hotel 10000 220 200 200 6133
d_partners
ID FIRST_NAME LAST_NAME EXPERTISE SPECIALTY AUTH_EXPENSE_AMT MANAGER_ID PARTNER_TYPE
11 Jennifer cho Weddings All Types 33 Wedding Coordinator
22 Jason Tsang Hip Hop 33 Disk Jockey
33 Allison Plumb Event Planning 300000 33 Manager
d_play_list_items d_songs
EVENT_ID SONG_ID COMMENTS ID TITLE DURATION ARTIST TYPE_CODE
100 45 Play late 45 Its Finally Over 5 min The Hobbits 12
100 46 46 Im Going to Miss My Teacher 2 min Jane Pop 12
100 47 Play early 47 Hurrah for Today 3 min The Jubilant Trio 77
105 48 Play after cake cutting 48 Meet Me At the Altar 6 min Bobby West 1
105 49 Play first 49 Lets Celebrate 8 min The Celebrants 77
105 47 Play for the father 50 All These Years 10 min Diana Crooner 88
d_venues
ID LOC_TYPE ADDRESS RENTAL_FEE COMMENTS
100 Private Home 52 West End Drive, Los Angeles, CA 90210 0 Large kitchen, spacious lawn
105 Private Home 123 Magnolia Road, Hudson, N.Y. 11220 0 3 level townhouse, speakers on all floors
101 Private Home 4 Primrose Lane, Chevy Chase, MD 22127 0 Gazebo, multi-level deck
95 School Hall 4 Mahogany Drive, Boston, MA 10010 75/hour School closes at 10pm
99 National Park 87 Park Avenue, San Diego, CA 28978 400/flat fee Bring generators
220 Hotel 200 Pennsylvania Ave, Washington D.C. 09002 300/per person Classy affair, tight security, private entrance for vendors
d_track_listings d_themes
SONG_ID CD_NUMBER TRACK CODE DESCRIPTION
45 92 1 200 Tropical
46 93 1 220 Carnival
47 91 2 240 Sixties
48 95 5 110 Classic
49 91 3 198 Mardi Gras
454 Eighties
d_types 340 Football
CODE DESCRIPTION 502 Fairy Tale
1 Jazz
12 Pop
40 Reggae
88 Country
77 New Age