Primary Key: A Primary Key in a database table is a field in the table that uniquely identifies every row or record present in the database table. Example: Students in Universities are assigned a unique registration number. Therefore, in a STUDENT database table, the attribute “reg_no” acts as primary key. Foreign Key: Foreign Key is a column in a relational database table which provides a relation between two tables. It provides a cross reference between tables by pointing to primary key of another table. Example: In STUDENT database table, the attribute “reg_no” acts as primary key and in COURSE database table in which the student selects his or her course, the same “reg_no” acts as foreign key for the STUDENT table. Given database tables: Table Name: EMPLOYEE EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE 1 Mr. Williamson John W 21-May-84 3 2 Ms. Ratula Nancy 09-Feb-89 2 3 Ms. Greenboro Lottie R 02-Oct-81 4 4 Mrs. Rumpersfro Jennie S 01-Jun-71 5 5 Mr. Smith Robert L 23-Nov-59 3 6 Mr. Renselear Cary A 25-Dec-85 1 7 Mr. Ogallo Roberto S 31-Jul-82 3 8 Ms. Johnson Elizabeth I 10-Sep-88 1 9 Mr. Eindsmar Jack W 19-Apr-55 2 10 Mrs. Jones Rose R 06-Mar-66 4 11 Mr. Broderick Tom 21-Oct-72 3 12 Mr. Washington Alan Y 08-Sept-74 2 13 Mr. Smith Peter N 25-Aug-64 3 14 Ms. Smith Sherry H 25-May-66 4 15 Mr. Olenko Howard U 24-May-64 5 16 Mr. Archialo Barry V 03-Sep-60 5 17 Ms. Grimaldo Jeanine K 12-Nov-70 4 18 Mr. Rosenburg Andrew D 24-Jan-71 4 19 Mr. Rosten Peter F 03-Oct-68 4 20 Mr. Mckee Robert S 06-Mar-70 1 21 Ms. Baumann Jennifer A 11-Dec-74 3 Table Name: STORE STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE 1 Access Junction 1003455.76 2 8 2 Database Corner 1421987.39 2 12 3 Tuple Charge 986783.22 1 7 4 Attribute Alley 944568.56 2 3 5 Primary Key Point 2930098.45 1 15 Table Name: REGION REGION_CODE REGION_DESCRIPT 1 EAST 2 WEST

Question

When the FCC added Color Television to the Industry Standards, they went with the system developed in the 1940s by Peter Goldman for CBS. Question 15 options: True False Part of the reason that many critics disliked 1950s gameshows was the fact that gameshows offered one of the few opportunities to see unscripted interactions with "real" (average/non-famous) people on television. Question 16 options: True False The Andy Griffith Show is an example of the "rural revival" shows that become enormously popular on 1960s American television. Question 19 options: True False During the Network Era, the hours before primetime each day were exclusively devoted to locally-produced programming, not programming dictated by an affiliate station's parent network. Question 20 options: True False

Answer 1

Question

Chapter 3, Problem 1P

Program Plan Intro

Primary Key:

A Primary Key in a database table is a field in the table that uniquely identifies every row or record present in the database table.

Example:

Students in Universities are assigned a unique registration number. Therefore, in a STUDENT database table, the attribute “reg_no” acts as primary key.

Foreign Key:

Foreign Key is a column in a relational database table which provides a relation between two tables. It provides a cross reference between tables by pointing to primary key of another table.

Example:

In STUDENT database table, the attribute “reg_no” acts as primary key and in COURSE database table in which the student selects his or her course, the same “reg_no” acts as foreign key for the STUDENT table.

Given database tables:

Table Name: EMPLOYEE

EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE

1 Mr. Williamson John W 21-May-84 3

2 Ms. Ratula Nancy 09-Feb-89 2

3 Ms. Greenboro Lottie R 02-Oct-81 4

4 Mrs. Rumpersfro Jennie S 01-Jun-71 5

5 Mr. Smith Robert L 23-Nov-59 3

6 Mr. Renselear Cary A 25-Dec-85 1

7 Mr. Ogallo Roberto S 31-Jul-82 3

8 Ms. Johnson Elizabeth I 10-Sep-88 1

9 Mr. Eindsmar Jack W 19-Apr-55 2

10 Mrs. Jones Rose R 06-Mar-66 4

11 Mr. Broderick Tom 21-Oct-72 3

12 Mr. Washington Alan Y 08-Sept-74 2

13 Mr. Smith Peter N 25-Aug-64 3

14 Ms. Smith Sherry H 25-May-66 4

15 Mr. Olenko Howard U 24-May-64 5

16 Mr. Archialo Barry V 03-Sep-60 5

17 Ms. Grimaldo Jeanine K 12-Nov-70 4

18 Mr. Rosenburg Andrew D 24-Jan-71 4

19 Mr. Rosten Peter F 03-Oct-68 4

20 Mr. Mckee Robert S 06-Mar-70 1

21 Ms. Baumann Jennifer A 11-Dec-74 3

Table Name: STORE

STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE

1 Access Junction 1003455.76 2 8

2 Database Corner 1421987.39 2 12

3 Tuple Charge 986783.22 1 7

4 Attribute Alley 944568.56 2 3

5 Primary Key Point 2930098.45 1 15

Table Name: REGION

REGION_CODE REGION_DESCRIPT

1 EAST

2 WEST

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

When the FCC added Color Television to the Industry Standards, they went with the system developed in the 1940s by Peter Goldman for CBS. Question 15 options: True False Part of the reason that many critics disliked 1950s gameshows was the fact that gameshows offered one of the few opportunities to see unscripted interactions with "real" (average/non-famous) people on television. Question 16 options: True False The Andy Griffith Show is an example of the "rural revival" shows that become enormously popular on 1960s American television. Question 19 options: True False During the Network Era, the hours before primetime each day were exclusively devoted to locally-produced programming, not programming dictated by an affiliate station's parent network. Question 20 options: True False

Although color television was not added to the industry standard until 1956, CBS had been broadcasting selected special events in color as early as 1950. Question 1 options: True False Two key factors in creating the Network Era of American television were the FCC licensing freeze and ______________. Question 4 options: The Quiz Show Scandals Habitual Viewing Operation Frontal Lobes Drop-In Viewing Least Objectionable Programming was designed to embrace the public service-oriented vision of using television to elevate mass culture and enrich viewers. Question 6 options: True False By the end of the 1950s, all three remaining networks (NBC, CBS, & ABC) were broadcasting their entire nightly programming schedule in full color. Question 9 options: True False

7. See the code below and solve the following. public class Test { public static void main(String[] args) { int result = 0; } result = fn(2,3); System.out.println("The result is: + result); // fn(x, 1) = x // fn(x, y) = fn(x, y-1) + 2, when y>1 public static int fn(int x, int y) { if (x <= 1) return x; else return fn(x, y-1) + 2; } } 7-1. This program has a bug that leads to infinite recursion. Modify fn(int x, int y) method to fix the problem. (2 point) 7-2. Manually trace the recursive call, fn(2,3) and show the output (step by step). (2 point) 7-3. Can you identify the Base Case in recursive method fn(int x, int y)? (1 point)

Answer 2

Question

Chapter 3, Problem 1P

Program Plan Intro

Primary Key:

A Primary Key in a database table is a field in the table that uniquely identifies every row or record present in the database table.

Example:

Students in Universities are assigned a unique registration number. Therefore, in a STUDENT database table, the attribute “reg_no” acts as primary key.

Foreign Key:

Foreign Key is a column in a relational database table which provides a relation between two tables. It provides a cross reference between tables by pointing to primary key of another table.

Example:

In STUDENT database table, the attribute “reg_no” acts as primary key and in COURSE database table in which the student selects his or her course, the same “reg_no” acts as foreign key for the STUDENT table.

Given database tables:

Table Name: EMPLOYEE

EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE

1 Mr. Williamson John W 21-May-84 3

2 Ms. Ratula Nancy 09-Feb-89 2

3 Ms. Greenboro Lottie R 02-Oct-81 4

4 Mrs. Rumpersfro Jennie S 01-Jun-71 5

5 Mr. Smith Robert L 23-Nov-59 3

6 Mr. Renselear Cary A 25-Dec-85 1

7 Mr. Ogallo Roberto S 31-Jul-82 3

8 Ms. Johnson Elizabeth I 10-Sep-88 1

9 Mr. Eindsmar Jack W 19-Apr-55 2

10 Mrs. Jones Rose R 06-Mar-66 4

11 Mr. Broderick Tom 21-Oct-72 3

12 Mr. Washington Alan Y 08-Sept-74 2

13 Mr. Smith Peter N 25-Aug-64 3

14 Ms. Smith Sherry H 25-May-66 4

15 Mr. Olenko Howard U 24-May-64 5

16 Mr. Archialo Barry V 03-Sep-60 5

17 Ms. Grimaldo Jeanine K 12-Nov-70 4

18 Mr. Rosenburg Andrew D 24-Jan-71 4

19 Mr. Rosten Peter F 03-Oct-68 4

20 Mr. Mckee Robert S 06-Mar-70 1

21 Ms. Baumann Jennifer A 11-Dec-74 3

Table Name: STORE

STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE

1 Access Junction 1003455.76 2 8

2 Database Corner 1421987.39 2 12

3 Tuple Charge 986783.22 1 7

4 Attribute Alley 944568.56 2 3

5 Primary Key Point 2930098.45 1 15

Table Name: REGION

REGION_CODE REGION_DESCRIPT

1 EAST

2 WEST

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 3

Question

Chapter 3, Problem 1P

Program Plan Intro

Primary Key:

A Primary Key in a database table is a field in the table that uniquely identifies every row or record present in the database table.

Example:

Students in Universities are assigned a unique registration number. Therefore, in a STUDENT database table, the attribute “reg_no” acts as primary key.

Foreign Key:

Foreign Key is a column in a relational database table which provides a relation between two tables. It provides a cross reference between tables by pointing to primary key of another table.

Example:

In STUDENT database table, the attribute “reg_no” acts as primary key and in COURSE database table in which the student selects his or her course, the same “reg_no” acts as foreign key for the STUDENT table.

Given database tables:

Table Name: EMPLOYEE

EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE

1 Mr. Williamson John W 21-May-84 3

2 Ms. Ratula Nancy 09-Feb-89 2

3 Ms. Greenboro Lottie R 02-Oct-81 4

4 Mrs. Rumpersfro Jennie S 01-Jun-71 5

5 Mr. Smith Robert L 23-Nov-59 3

6 Mr. Renselear Cary A 25-Dec-85 1

7 Mr. Ogallo Roberto S 31-Jul-82 3

8 Ms. Johnson Elizabeth I 10-Sep-88 1

9 Mr. Eindsmar Jack W 19-Apr-55 2

10 Mrs. Jones Rose R 06-Mar-66 4

11 Mr. Broderick Tom 21-Oct-72 3

12 Mr. Washington Alan Y 08-Sept-74 2

13 Mr. Smith Peter N 25-Aug-64 3

14 Ms. Smith Sherry H 25-May-66 4

15 Mr. Olenko Howard U 24-May-64 5

16 Mr. Archialo Barry V 03-Sep-60 5

17 Ms. Grimaldo Jeanine K 12-Nov-70 4

18 Mr. Rosenburg Andrew D 24-Jan-71 4

19 Mr. Rosten Peter F 03-Oct-68 4

20 Mr. Mckee Robert S 06-Mar-70 1

21 Ms. Baumann Jennifer A 11-Dec-74 3

Table Name: STORE

STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE

1 Access Junction 1003455.76 2 8

2 Database Corner 1421987.39 2 12

3 Tuple Charge 986783.22 1 7

4 Attribute Alley 944568.56 2 3

5 Primary Key Point 2930098.45 1 15

Table Name: REGION

REGION_CODE REGION_DESCRIPT

1 EAST

2 WEST

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 4

Question

Chapter 3, Problem 1P

Program Plan Intro

Primary Key:

A Primary Key in a database table is a field in the table that uniquely identifies every row or record present in the database table.

Example:

Students in Universities are assigned a unique registration number. Therefore, in a STUDENT database table, the attribute “reg_no” acts as primary key.

Foreign Key:

Foreign Key is a column in a relational database table which provides a relation between two tables. It provides a cross reference between tables by pointing to primary key of another table.

Example:

In STUDENT database table, the attribute “reg_no” acts as primary key and in COURSE database table in which the student selects his or her course, the same “reg_no” acts as foreign key for the STUDENT table.

Given database tables:

Table Name: EMPLOYEE

EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE

1 Mr. Williamson John W 21-May-84 3

2 Ms. Ratula Nancy 09-Feb-89 2

3 Ms. Greenboro Lottie R 02-Oct-81 4

4 Mrs. Rumpersfro Jennie S 01-Jun-71 5

5 Mr. Smith Robert L 23-Nov-59 3

6 Mr. Renselear Cary A 25-Dec-85 1

7 Mr. Ogallo Roberto S 31-Jul-82 3

8 Ms. Johnson Elizabeth I 10-Sep-88 1

9 Mr. Eindsmar Jack W 19-Apr-55 2

10 Mrs. Jones Rose R 06-Mar-66 4

11 Mr. Broderick Tom 21-Oct-72 3

12 Mr. Washington Alan Y 08-Sept-74 2

13 Mr. Smith Peter N 25-Aug-64 3

14 Ms. Smith Sherry H 25-May-66 4

15 Mr. Olenko Howard U 24-May-64 5

16 Mr. Archialo Barry V 03-Sep-60 5

17 Ms. Grimaldo Jeanine K 12-Nov-70 4

18 Mr. Rosenburg Andrew D 24-Jan-71 4

19 Mr. Rosten Peter F 03-Oct-68 4

20 Mr. Mckee Robert S 06-Mar-70 1

21 Ms. Baumann Jennifer A 11-Dec-74 3

Table Name: STORE

STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE

1 Access Junction 1003455.76 2 8

2 Database Corner 1421987.39 2 12

3 Tuple Charge 986783.22 1 7

4 Attribute Alley 944568.56 2 3

5 Primary Key Point 2930098.45 1 15

Table Name: REGION

REGION_CODE REGION_DESCRIPT

1 EAST

2 WEST

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 5

Chapter 3, Problem 1P

Program Plan Intro

Primary Key:

A Primary Key in a database table is a field in the table that uniquely identifies every row or record present in the database table.

Example:

Students in Universities are assigned a unique registration number. Therefore, in a STUDENT database table, the attribute “reg_no” acts as primary key.

Foreign Key:

Foreign Key is a column in a relational database table which provides a relation between two tables. It provides a cross reference between tables by pointing to primary key of another table.

Example:

In STUDENT database table, the attribute “reg_no” acts as primary key and in COURSE database table in which the student selects his or her course, the same “reg_no” acts as foreign key for the STUDENT table.

Given database tables:

Table Name: EMPLOYEE

EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE

1 Mr. Williamson John W 21-May-84 3

2 Ms. Ratula Nancy 09-Feb-89 2

3 Ms. Greenboro Lottie R 02-Oct-81 4

4 Mrs. Rumpersfro Jennie S 01-Jun-71 5

5 Mr. Smith Robert L 23-Nov-59 3

6 Mr. Renselear Cary A 25-Dec-85 1

7 Mr. Ogallo Roberto S 31-Jul-82 3

8 Ms. Johnson Elizabeth I 10-Sep-88 1

9 Mr. Eindsmar Jack W 19-Apr-55 2

10 Mrs. Jones Rose R 06-Mar-66 4

11 Mr. Broderick Tom 21-Oct-72 3

12 Mr. Washington Alan Y 08-Sept-74 2

13 Mr. Smith Peter N 25-Aug-64 3

14 Ms. Smith Sherry H 25-May-66 4

15 Mr. Olenko Howard U 24-May-64 5

16 Mr. Archialo Barry V 03-Sep-60 5

17 Ms. Grimaldo Jeanine K 12-Nov-70 4

18 Mr. Rosenburg Andrew D 24-Jan-71 4

19 Mr. Rosten Peter F 03-Oct-68 4

20 Mr. Mckee Robert S 06-Mar-70 1

21 Ms. Baumann Jennifer A 11-Dec-74 3

Table Name: STORE

STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE

1 Access Junction 1003455.76 2 8

2 Database Corner 1421987.39 2 12

3 Tuple Charge 986783.22 1 7

4 Attribute Alley 944568.56 2 3

5 Primary Key Point 2930098.45 1 15

Table Name: REGION

REGION_CODE REGION_DESCRIPT

1 EAST

2 WEST

Answer 6

Chapter 3, Problem 1P

Program Plan Intro

Primary Key:

A Primary Key in a database table is a field in the table that uniquely identifies every row or record present in the database table.

Example:

Students in Universities are assigned a unique registration number. Therefore, in a STUDENT database table, the attribute “reg_no” acts as primary key.

Foreign Key:

Foreign Key is a column in a relational database table which provides a relation between two tables. It provides a cross reference between tables by pointing to primary key of another table.

Example:

In STUDENT database table, the attribute “reg_no” acts as primary key and in COURSE database table in which the student selects his or her course, the same “reg_no” acts as foreign key for the STUDENT table.

Given database tables:

Table Name: EMPLOYEE

EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE

1 Mr. Williamson John W 21-May-84 3

2 Ms. Ratula Nancy 09-Feb-89 2

3 Ms. Greenboro Lottie R 02-Oct-81 4

4 Mrs. Rumpersfro Jennie S 01-Jun-71 5

5 Mr. Smith Robert L 23-Nov-59 3

6 Mr. Renselear Cary A 25-Dec-85 1

7 Mr. Ogallo Roberto S 31-Jul-82 3

8 Ms. Johnson Elizabeth I 10-Sep-88 1

9 Mr. Eindsmar Jack W 19-Apr-55 2

10 Mrs. Jones Rose R 06-Mar-66 4

11 Mr. Broderick Tom 21-Oct-72 3

12 Mr. Washington Alan Y 08-Sept-74 2

13 Mr. Smith Peter N 25-Aug-64 3

14 Ms. Smith Sherry H 25-May-66 4

15 Mr. Olenko Howard U 24-May-64 5

16 Mr. Archialo Barry V 03-Sep-60 5

17 Ms. Grimaldo Jeanine K 12-Nov-70 4

18 Mr. Rosenburg Andrew D 24-Jan-71 4

19 Mr. Rosten Peter F 03-Oct-68 4

20 Mr. Mckee Robert S 06-Mar-70 1

21 Ms. Baumann Jennifer A 11-Dec-74 3

Table Name: STORE

STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE

1 Access Junction 1003455.76 2 8

2 Database Corner 1421987.39 2 12

3 Tuple Charge 986783.22 1 7

4 Attribute Alley 944568.56 2 3

5 Primary Key Point 2930098.45 1 15

Table Name: REGION

REGION_CODE REGION_DESCRIPT

1 EAST

2 WEST

Answer 7

Chapter 3, Problem 1P

Program Plan Intro

Primary Key:

A Primary Key in a database table is a field in the table that uniquely identifies every row or record present in the database table.

Example:

Students in Universities are assigned a unique registration number. Therefore, in a STUDENT database table, the attribute “reg_no” acts as primary key.

Foreign Key:

Foreign Key is a column in a relational database table which provides a relation between two tables. It provides a cross reference between tables by pointing to primary key of another table.

Example:

In STUDENT database table, the attribute “reg_no” acts as primary key and in COURSE database table in which the student selects his or her course, the same “reg_no” acts as foreign key for the STUDENT table.

Given database tables:

Table Name: EMPLOYEE

EMP_CODE EMP_TITLE EMP_LNAME EMP_FNAME EMP_INITIAL EMP_DOB STORE_CODE

1 Mr. Williamson John W 21-May-84 3

2 Ms. Ratula Nancy 09-Feb-89 2

3 Ms. Greenboro Lottie R 02-Oct-81 4

4 Mrs. Rumpersfro Jennie S 01-Jun-71 5

5 Mr. Smith Robert L 23-Nov-59 3

6 Mr. Renselear Cary A 25-Dec-85 1

7 Mr. Ogallo Roberto S 31-Jul-82 3

8 Ms. Johnson Elizabeth I 10-Sep-88 1

9 Mr. Eindsmar Jack W 19-Apr-55 2

10 Mrs. Jones Rose R 06-Mar-66 4

11 Mr. Broderick Tom 21-Oct-72 3

12 Mr. Washington Alan Y 08-Sept-74 2

13 Mr. Smith Peter N 25-Aug-64 3

14 Ms. Smith Sherry H 25-May-66 4

15 Mr. Olenko Howard U 24-May-64 5

16 Mr. Archialo Barry V 03-Sep-60 5

17 Ms. Grimaldo Jeanine K 12-Nov-70 4

18 Mr. Rosenburg Andrew D 24-Jan-71 4

19 Mr. Rosten Peter F 03-Oct-68 4

20 Mr. Mckee Robert S 06-Mar-70 1

21 Ms. Baumann Jennifer A 11-Dec-74 3

Table Name: STORE

STORE_CODE STORE_NAME STORE_YTD_SALES REGION_CODE EMP_CODE

1 Access Junction 1003455.76 2 8

2 Database Corner 1421987.39 2 12

3 Tuple Charge 986783.22 1 7

4 Attribute Alley 944568.56 2 3

5 Primary Key Point 2930098.45 1 15

Table Name: REGION

REGION_CODE REGION_DESCRIPT

1 EAST

2 WEST

Answer 8

Expert Solution & Answer

Answer 9

Expert Solution & Answer

Answer 10

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 11

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 12

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Answer 13

Trending nowThis is a popular solution!

Answer 14

Trending nowThis is a popular solution!

Answer 15

Trending nowThis is a popular solution!

Answer 16

Trending now

Answer 17

This is a popular solution!

Answer 18

See solution

Check out sample textbook solution

Answer 19

Ch. 3 - What is the difference between a database and a...Ch. 3 - Prob. 2RQ Ch. 3 - Prob. 3RQ Ch. 3 - What are the requirements that two relations must...Ch. 3 - Which relational algebra operators can be applied...Ch. 3 - Explain why the data dictionary is sometimes...Ch. 3 - A database user manually notes that The file...Ch. 3 - Prob. 8RQ Ch. 3 - Prob. 9RQ Ch. 3 - Prob. 10RQ

Concept explainers

Chapter 3 Solutions

EMP_CODE	EMP_TITLE	EMP_LNAME	EMP_FNAME	EMP_INITIAL	EMP_DOB	STORE_CODE
1	Mr.	Williamson	John	W	21-May-84	3
2	Ms.	Ratula	Nancy		09-Feb-89	2
3	Ms.	Greenboro	Lottie	R	02-Oct-81	4
4	Mrs.	Rumpersfro	Jennie	S	01-Jun-71	5
5	Mr.	Smith	Robert	L	23-Nov-59	3
6	Mr.	Renselear	Cary	A	25-Dec-85	1
7	Mr.	Ogallo	Roberto	S	31-Jul-82	3
8	Ms.	Johnson	Elizabeth	I	10-Sep-88	1
9	Mr.	Eindsmar	Jack	W	19-Apr-55	2
10	Mrs.	Jones	Rose	R	06-Mar-66	4
11	Mr.	Broderick	Tom		21-Oct-72	3
12	Mr.	Washington	Alan	Y	08-Sept-74	2
13	Mr.	Smith	Peter	N	25-Aug-64	3
14	Ms.	Smith	Sherry	H	25-May-66	4
15	Mr.	Olenko	Howard	U	24-May-64	5
16	Mr.	Archialo	Barry	V	03-Sep-60	5
17	Ms.	Grimaldo	Jeanine	K	12-Nov-70	4
18	Mr.	Rosenburg	Andrew	D	24-Jan-71	4
19	Mr.	Rosten	Peter	F	03-Oct-68	4
20	Mr.	Mckee	Robert	S	06-Mar-70	1
21	Ms.	Baumann	Jennifer	A	11-Dec-74	3

STORE_CODE	STORE_NAME	STORE_YTD_SALES	REGION_CODE	EMP_CODE
1	Access Junction	1003455.76	2	8
2	Database Corner	1421987.39	2	12
3	Tuple Charge	986783.22	1	7
4	Attribute Alley	944568.56	2	3
5	Primary Key Point	2930098.45	1	15