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