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:
How many employees for each gender?
How many employees group by state?
How many employees group by year of DOB?
List the employee records using date of birth (DOB)?
Search the employee record:
using first name
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
_______________________________________________________
How many employees group by gender?
How many employees group by state?
How many employees group by year of DOB?
List the employee records using date of birth (DOB)?
Search the employee record using first name
List the employees record using state
Exit
_______________________________________________________
Select : 1
How many employees group by gender?
Male = 99
Female = 99
_______________________________________________________
CS 5200: Programming Assignment 1
_______________________________________________________
How many employees group by gender?
How many employees group by state?
How many employees group by year of DOB?
List the employee records using date of birth (DOB)?
Search the employee record using first name
List the employees record using state
Exit
_______________________________________________________
Select : 2
How many employees group by state?
AL = 99
AR = 99
….
_______________________________________________________
CS 5200: Programming Assignment 1
_______________________________________________________
How many employees group by gender?
How many employees group by state?
How many employees group by year of DOB?
List the employee records using date of birth (DOB)?
Search the employee record using first name
List the employees record using state
Exit
_______________________________________________________
Select : 3
How many employees group by year of DOB?
1958 = 99
1959 = 99
….
_______________________________________________________
CS 5200: Programming Assignment 1
_______________________________________________________
How many employees group by gender?
How many employees group by state?
How many employees group by year of DOB?
List the employee records using date of birth (DOB)?
Search the employee record using first name
List the employees record using state
Exit
_______________________________________________________
890290 | Julia | Scott | 7/15/1959 | 56 | 141518 | 251-99-1941 | TN | Primm Springs | |
525955 | Judy | Gonzales | 6/17/1959 | 51 | 149575 | 029-92-2155 | NJ | Eatontown | |
477616 | Frances | Young | 6/9/1959 | 42 | 121587 | 028-92-8912 | TX | Delmita | |
528673 | Paul | Watson | 3/9/1959 | 60 | 145235 | 286-15-9671 | KY | Blue River | |
380086 | Carol | Murphy | 6/30/1958 | 40 | 60918 | 423-67-7023 | OH | Blanchester | |
515103 | Anne | Perez | 5/5/1958 | 48 | 114426 | 594-99-9091 | TN | Cookeville | |
560455 | Carolyn | Hayes | 3/10/1958 | 53 | 42005 | 730-28-1350 | FL | Saint Cloud | |
441771 | Cheryl | Scott | 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
_______________________________________________________
How many employees group by gender?
How many employees group by state?
How many employees group by year of DOB?
List the employee records using date of birth (DOB)?
Search the employee record using first name
List the employees record using state
Exit
_______________________________________________________
Select : 5
Enter first name: Joyce
766610 | Joyce | Jenkins | 8/22/1961 | 44 | 119321 | 695-16-6506 | WI | Ellsworth |
_______________________________________________________
CS 5200: Programming Assignment 1
_______________________________________________________
How many employees group by gender?
How many employees group by state?
How many employees group by year of DOB?
List the employee records using date of birth (DOB)?
Search the employee record using first name
List the employees record using state
Exit
_______________________________________________________
Select : 6
Enter first name: FL
806955 | William | Hernandez | 7/22/1967 | 50 | 73734 | 629-31-9010 | FL | Mary Esther | |
212893 | Janet | Henderson | 12/24/1979 | 60 | 114481 | 018-94-7340 | FL | Miami | |
329752 | Lillian | Brown | 5/12/1981 | 49 | 67251 | 249-99-8821 | FL | Panacea | |
560455 | Carolyn | Hayes | 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.