Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
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.
