store_employees is defined as follows:
create table store_employees
(stor_id char(4) null
references stores(stor_id),
emp_id id not null,
mgr_id id null
references store_employees(emp_id),
emp_lname varchar(40) not null,
emp_fname varchar(20) not null,
phone char(12) null,
address varchar(40) null,
city varchar(20) null,
state char(2) null,
country varchar(12) null,
postalcode varchar(10) null,
unique nonclustered (emp_id))
Table B-8 lists the contents of store_employees:
stor- _id |
emp- _id |
mgr- _id |
emp_- lname |
emp_- fname |
phone |
address |
city |
state |
coun -try |
postal- code |
|---|---|---|---|---|---|---|---|---|---|---|
7066 |
415-92-7301 |
415-92-7301 |
Chichikov |
P. |
619 336-8978 |
20 Alfalfa Ave. |
Twenty- nine Palms |
CA |
USA |
92277 |
7066 |
202-93-0009 |
415-92-7301 |
Spindle- shanks |
Daisy |
619 336-8900 |
14 Wild Cat Way |
Twenty- nine Palms |
CA |
USA |
92277 |
7066 |
444-89-2342 |
415-92-7301 |
Ratsbane |
Ian |
619 344-92321 |
1827 Road- runner Dr. |
Twenty- nine Palms |
CA |
USA |
92278 |
7066 |
332-78-2382 |
415-92-7301 |
Bayless |
Chuck |
619 777-4356 |
7 Maynard Dr. |
Twenty- nine Palms |
CA |
USA |
92277 |
7066 |
898-00-2383 |
415-92-7301 |
Pumpion |
Tammy |
619 222-3434 |
10089 Lazy Joe Ave. |
Twenty- nine Palms |
CA |
USA |
92277 |
7066 |
222-90-3737 |
415-92-7301 |
Barnum |
Arthur |
619 333-3232 |
522 Lupine Ave. |
Twenty- nine Palms |
CA |
USA |
92277 |
7066 |
939-32-1212 |
415-92-7301 |
Ronald |
Bill |
619 333-4550 |
69 Coyote Ct. |
Twenty- nine Palms |
CA |
USA |
92277 |
7067 |
343-38-9494 |
343-38-9494 |
St. Augustine |
Fiona |
408 222-8383 |
17 Call of the Wild Rd. |
Los Gatos |
CA |
USA |
95030 |
7067 |
222-90-3483 |
343-38-9494 |
Sebastian |
Basil |
408 334-8928 |
29 Dharma Rd. |
Los Gatos |
CA |
USA |
95030 |
7067 |
121-00-3823 |
343-38-9494 |
March- main |
Albin |
408 343-8934 |
1001 Top of the Hill Ct. |
Los Gatos |
CA |
USA |
95030 |
7067 |
232-29-8938 |
343-38-9494 |
Barlow |
Hilary |
408 232-3332 |
2 Topping Way |
Los Gatos |
CA |
USA |
95032 |
7067 |
232-89-9393 |
343-38-9494 |
Dieuberi |
Gustav |
408 675-8938 |
30 Mount Madonna Rd. |
Los Gatos |
CA |
USA |
95030 |
7131 |
565-67-3920 |
565-67-3920 |
Lavator |
Marie |
206 328-2838 |
14 Peter Grubb Rd. SE |
Renton |
WA |
USA |
98058 |
7131 |
848-34-4838 |
565-67-3920 |
Sope |
Inez |
206 438-3434 |
1238 Index Ave. SE |
Renton |
WA |
USA |
98058 |
7131 |
232-38-2232 |
565-67-3920 |
Tubb |
Wally |
206 323-2828 |
180 Moses Lane S |
Renton |
WA |
USA |
98058 |
7131 |
111-90-3283 |
565-67-3920 |
Basin |
Chalker |
206 323-7777 |
192 Naches Ave. N |
Renton |
WA |
USA |
98055 |
7131 |
323-32-4444 |
565-67-3920 |
Waters |
Johnny |
206 323-9020 |
1 Pelly Ave. N |
Renton |
WA |
USA |
98055 |
7131 |
238-32-0079 |
238-32-0079 |
Scrubb |
Billy |
206 444-3232 |
90 Vashion St. NE |
Renton |
WA |
USA |
98059 |
7131 |
349-00-9393 |
565-67-3920 |
Tuwel |
Terry |
206 323-3233 |
66 Sunset Blvd. SW |
Renton |
WA |
USA |
98055 |
8042 |
723-99-9329 |
723-99-9329 |
Crook- shank |
Flannery |
503 323-9090 |
SW 222 Laber Ct. |
Port-land |
OR |
USA |
97236 |
8042 |
343-32-0034 |
723-99-9329 |
Sitwell |
Daven- port |
503 333-9494 |
14 SE Krause Lane |
Port-land |
OR |
USA |
97236 |
8042 |
877-12-9393 |
723-99-9329 |
Bartholo- mew |
Curan |
503 333-9332 |
18 SE Knee St. |
Port-land |
OR |
USA |
97266 |
8042 |
323-99-0009 |
723-99-9329 |
Yaddo |
Mary |
503 333-4844 |
NE Klickitat St. |
Port-land |
OR |
USA |
97212 |
8042 |
434-94-3203 |
723-99-9329 |
Peacock |
Mavis |
503 494-3413 |
4978 SW Huns Rd. |
Port-land |
OR |
USA |
97223 |
8042 |
232-94-5885 |
723-99-9329 |
Baldwin |
Dorothy |
503 333-9494 |
9 N. Image Canoe Ave. |
Port-land |
OR |
USA |
97217 |
8042 |
323-09-5872 |
723-99-9329 |
Corbit |
P. |
503 335-3491 |
89 NW Industry St. |
Port-land |
OR |
USA |
97210 |
8042 |
323-54-3434 |
723-99-9329 |
Pilkinton |
Faith |
503 333-4531 |
18 SW Inez St. |
Port-land |
OR |
USA |
97224 |
8042 |
331-90-8484 |
723-99-9329 |
Botteghe |
Obscura |
503 889-2832 |
555 SW Keerins Ct. |
Port-land |
OR |
USA |
97223 |
8042 |
884-32-8282 |
723-99-9329 |
Martineau |
Tristan |
503 323-5954 |
346 N. Leade Rd. |
Port-land |
OR |
USA |
97203 |
8042 |
112-90-3829 |
723-99-9329 |
Laughton |
Karla |
503 323-5929 |
900 N. Magpie St. |
Port-land |
OR |
USA |
97202 |
8042 |
434-23-9292 |
723-99-9329 |
MacLeish |
Cochran |
503 433-9493 |
1722 SE Ogden Ct. |
Port-land |
OR |
USA |
97202 |
6380 |
433-01-3922 |
433-01-3922 |
Horgran |
Eric |
206 323-4983 |
18 Thud Dr. S. |
Seattle |
WA |
USA |
98198 |
6380 |
232-30-9999 |
433-01-3922 |
Farnsdale |
Finwick |
206 434-4949 |
2 Bellevue Ave. |
Seattle |
WA |
USA |
98118 |
6380 |
333-90-3828 |
433-01-3922 |
Wolfe |
Wanda |
206 323-3333 |
2 S. Boze St. #15 |
Seattle |
WA |
USA |
98108 |
6380 |
322-09-2122 |
433-01-3922 |
Begude |
Nina |
206 333-9023 |
1297 W. Cay Way |
Seattle |
WA |
USA |
98108 |
6380 |
342-78-2832 |
433-01-3922 |
Howe |
Saphron |
206 323-4933 |
9827 Des Moines Dr. |
Seattle |
WA |
USA |
98108 |
6380 |
882-00-3234 |
433-01-3922 |
Salidin |
Uma |
206 390-8328 |
13 Echo Lake Place |
Seattle |
WA |
USA |
98126 |
6380 |
321-89-8832 |
433-01-3922 |
Marsicano |
Evan |
206 322-9392 |
7 Dancer Ave. SW’ |
Seattle |
WA |
USA |
98126 |
6380 |
762-32-5555 |
433-01-3922 |
Boulignini |
Gus |
206 323-9396 |
308 S. Fidalgo St. |
Seattle |
WA |
USA |
98108 |
7896 |
433-01-3921 |
433-01-3921 |
Malraison |
Marcel |
206 889-9983 |
2298 Berry Dr. |
Fremont |
CA |
USA |
94555 |
7896 |
322-32-8382 |
433-01-3921 |
West |
Diana |
206 898-3233 |
20-B Knute St. |
Fremont |
CA |
USA |
94536 |
7896 |
328-74-8748 |
433-01-3921 |
Cazalis |
Mari |
206 326-6785 |
18 May Dr. #7 |
Fremont |
CA |
USA |
94555 |
7896 |
325-87-6766 |
433-01-3921 |
Zorronius |
Gaius |
206 363-8988 |
1967 Claude Dr. |
Fremont |
CA |
USA |
94555 |
7896 |
323-67-5646 |
433-01-3921 |
Podding |
Marvin |
206 438-7858 |
242 Ram Ct. #123 |
Fremont |
CA |
USA |
94539 |
7896 |
673-03-6728 |
433-01-3921 |
Phelan |
Micky |
206 323-7676 |
1212 Spinn Ct. |
Fremont |
CA |
USA |
94539 |
7896 |
326-77-6482 |
433-01-3921 |
Bokanow- ski |
Peter |
206 432-4832 |
13 Sparto Dr. |
Fremont |
CA |
USA |
94539 |
7896 |
653-48-2975 |
433-01-3921 |
Poodals |
F.W. |
206 387-6863 |
739 Sendak Dr. |
Fremont |
CA |
USA |
94538 |
7896 |
320-37-4682 |
433-01-3921 |
Scrubbs |
Randy |
206 323-3874 |
18 Washo Dr. #A |
Fremont |
CA |
USA |
94539 |
7896 |
323-67-4762 |
433-01-3921 |
Mullins |
M. |
206 382-7862 |
1717 Zircon Ter. |
Fremont |
CA |
USA |
94555 |
7896 |
326-76-3863 |
433-01-3921 |
Clarac |
Sebastian |
206 387-6732 |
5622 Zin St. #78 |
Fremont |
CA |
USA |
94539 |
5023 |
534-92-2910 |
534-92-2910 |
Armand |
Mary |
510 323-5478 |
1912 Badger Ln. |
Con-cord |
CA |
USA |
94521 |
5023 |
342-38-2782 |
534-92-2910 |
Blanzat |
Gomez |
510 382-3828 |
4229 Tiffany Pl. |
Con-cord |
CA |
USA |
94518 |
5023 |
322-39-3222 |
534-92-2910 |
Winate |
Patrick |
510 322-5873 |
16 Mahoo Ln. |
Con-cord |
CA |
USA |
94521 |
5023 |
932-20-4389 |
534-92-2910 |
Burke |
Aldous |
510 433-4829 |
12 Ponder Dr. #4 |
Con-cord |
CA |
USA |
94521 |
5023 |
322-43-2828 |
534-92-2910 |
Rough- head |
Jonathan |
510 323-4782 |
2 Athos Ct. |
Con-cord |
CA |
USA |
94521 |
5023 |
832-32-3289 |
534-92-2910 |
Johnson |
Alexis |
510 323-3824 |
927 Aramis Ct. |
Con-cord |
CA |
USA |
94520 |
5023 |
432-32-4444 |
534-92-2910 |
Blitzstein |
Jack |
510 323-3874 |
2 Porthos Ct. |
Con-cord |
CA |
USA |
94519 |
5023 |
543-43-8438 |
534-92-2910 |
Darby |
Andy |
510 422-3232 |
222 Juniper Ct. |
Con-cord |
CA |
USA |
94519 |
5023 |
423-42-9933 |
534-92-2910 |
Askanzi |
Robert |
510 422-3232 |
222 Juniper Ct. |
Con-cord |
CA |
USA |
94519 |
5023 |
838-28-1982 |
534-92-2910 |
Zavatta |
Virginia |
510 423-4932 |
629 Wind Way |
Con-cord |
CA |
USA |
94521 |
5023 |
433-43-3838 |
534-92-2910 |
Fife |
Ben |
510 322-8427 |
782 Sapling Ct. |
Con-cord |
CA |
USA |
94519 |
