Programming Assignment 1: CS5200 Database Theory and Applications Retrieve the information from csv file. In the assignment, you will learn about how to retrieve or query the information from csv file

Programming Assignment 1: CS5200 Database Theory and Applications

Retrieve the information from csv file.

In the assignment, you will learn about how to retrieve or query the information from csv file. You need to use the csv file (employee.csv) that is provided in this assignment. You will create program to answer the following questions using any programming languages such as C, C#, Java, Python , .. ,etc.

The questions include with:

1.     How many employees for each gender?

2.     How many employees group by state?

3.     How many employees group by year of DOB?

4.     List the employee records using date of birth (DOB)?

5.     Search the employee record:

5.1   using first name

5.2   using state

Submission:

Turn in your codes and csv file in folder name “PROG_ASSIGN1_XXXXX_YYYYYY” where XXXXX is course number (CRN) and YYYYYY is 700# student id and zip the folder before submitting your assignment.

Sample:

_______________________________________________________

CS 5200: Programming Assignment 1

_______________________________________________________

1.     How many employees group by gender?

2.     How many employees group by state?

3.     How many employees group by year of DOB?

4.     List the employee records using date of birth (DOB)?

5.     Search the employee record using first name

6.     List the employees record using state

7.     Exit

_______________________________________________________

Select :  1

How many employees group by gender?

Male              =         99

Female          =         99

_______________________________________________________

CS 5200: Programming Assignment 1

_______________________________________________________

1.     How many employees group by gender?

2.     How many employees group by state?

3.     How many employees group by year of DOB?

4.     List the employee records using date of birth (DOB)?

5.     Search the employee record using first name

6.     List the employees record using state

7.     Exit

_______________________________________________________

Select :  2

How many employees group by state?

AL       =         99

AR      =         99

….

_______________________________________________________

CS 5200: Programming Assignment 1

_______________________________________________________

1.     How many employees group by gender?

2.     How many employees group by state?

3.     How many employees group by year of DOB?

4.     List the employee records using date of birth (DOB)?

5.     Search the employee record using first name

6.     List the employees record using state

7.     Exit

_______________________________________________________

Select :  3

How many employees group by year of DOB?

1958             =         99

1959             =         99

….

_______________________________________________________

CS 5200: Programming Assignment 1

_______________________________________________________

1.     How many employees group by gender?

2.     How many employees group by state?

3.     How many employees group by year of DOB?

4.     List the employee records using date of birth (DOB)?

5.     Search the employee record using first name

6.     List the employees record using state

7.     Exit

_______________________________________________________

890290

Julia

Scott

F

7/15/1959

56

141518

251-99-1941

TN

Primm Springs

525955

Judy

Gonzales

F

6/17/1959

51

149575

029-92-2155

NJ

Eatontown

477616

Frances

Young

F

6/9/1959

42

121587

028-92-8912

TX

Delmita

528673

Paul

Watson

M

3/9/1959

60

145235

286-15-9671

KY

Blue River

380086

Carol

Murphy

F

6/30/1958

40

60918

423-67-7023

OH

Blanchester

515103

Anne

Perez

F

5/5/1958

48

114426

594-99-9091

TN

Cookeville

560455

Carolyn

Hayes

F

3/10/1958

53

42005

730-28-1350

FL

Saint Cloud

441771

Cheryl

Scott

F

2/23/1958

47

92220

596-94-2279

PA

Quecreek

Select :  4

From : 1/1/1958  to  10/10/1959

_______________________________________________________

CS 5200: Programming Assignment 1

_______________________________________________________

1.     How many employees group by gender?

2.     How many employees group by state?

3.     How many employees group by year of DOB?

4.     List the employee records using date of birth (DOB)?

5.     Search the employee record using first name

6.     List the employees record using state

7.     Exit

_______________________________________________________

Select :  5

Enter first name: Joyce

766610

Joyce

Jenkins

F

8/22/1961

44

119321

695-16-6506

WI

Ellsworth

_______________________________________________________

CS 5200: Programming Assignment 1

_______________________________________________________

1.     How many employees group by gender?

2.     How many employees group by state?

3.     How many employees group by year of DOB?

4.     List the employee records using date of birth (DOB)?

5.     Search the employee record using first name

6.     List the employees record using state

7.     Exit

_______________________________________________________

Select :  6

Enter first name: FL

806955

William

Hernandez

M

7/22/1967

50

73734

629-31-9010

FL

Mary Esther

212893

Janet

Henderson

F

12/24/1979

60

114481

018-94-7340

FL

Miami

329752

Lillian

Brown

F

5/12/1981

49

67251

249-99-8821

FL

Panacea

560455

Carolyn

Hayes

F

3/10/1958

53

42005

730-28-1350

FL

Saint Cloud

Note: You can design GUIs as you prefer to answer the questions. The program can execute on command line, windows application, or web-based application.