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 given integer variable numberOfPackages is: greater than 12, output "Needs more than one box". between 5 inclusive and 12 inclusive, output "Large box". between 0 exclusive and 4 inclusive, output "Small box". less than or equal to 0, output "Invalid input". End with a newline.

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 given integer variable numberOfPackages is: greater than 12, output "Needs more than one box". between 5 inclusive and 12 inclusive, output "Large box". between 0 exclusive and 4 inclusive, output "Small box". less than or equal to 0, output "Invalid input". End with a newline.

summarize in a short paragraph how to Advance Incident Response and Automation in ML home based security systems

1.[30 pts] Computers generate color pictures on a video screen or liquid crystal display by mixing three different colors of light: red, green, and blue. Imagine a simple scheme, with three different lights, each of which can be turned on or off, projecting onto a glass screen: We can create eight different colors based on the absence (0) or presence (1) of light sources R,G and B: R G B Color 0 0 0 Black 0 0 1 Blue 0 1 0 Green 0 1 1 Cyan 1 0 0 Red 1 0 1 Magenta 1 1 1 0 Yellow 1 White 1 Each of these colors can be represented as a bit vector of length 3, and we can apply Boolean operations to them. a. The complement of a color is formed by turning off the lights that are on and turning on the lights that are off. What would be the complement of each of the eight colors listed above? b. Describe the effect of applying Boolean operations on the following colors: Λ 1. Red(100) ^ Magenta(101)= Blue(001) 2. Bue(001) | Green(010)= 3. Yellow(100) & Cyan(011)= 2.[30 pts] Perform the following…

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