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