\n Programming Assignment 1: CS5200 Database Theory and Applications\n <\/p>\n
\n Retrieve the information from csv file.\n <\/p>\n
\n 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.\n <\/p>\n
\n The questions include with:\n <\/p>\n
\n 1.\u00a0\u00a0\u00a0\u00a0 How many employees for each gender?\n <\/p>\n
\n 2.\u00a0\u00a0\u00a0\u00a0 How many employees group by state?\n <\/p>\n
\n 3.\u00a0\u00a0\u00a0\u00a0 How many employees group by year of DOB?\n <\/p>\n
\n 4.\u00a0\u00a0\u00a0\u00a0 List the employee records using date of birth (DOB)?\n <\/p>\n
\n 5.\u00a0\u00a0\u00a0\u00a0 Search the employee record:\n <\/p>\n
\n 5.1\u00a0\u00a0 using first name\n <\/p>\n
\n 5.2\u00a0\u00a0 using state\n <\/p>\n<\/div>\n
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
\nProgramming 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 \u201cPROG_ASSIGN1_XXXXX_YYYYYY\u201d 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 \u2026. _______________________________________________________ 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 \u2026. _______________________________________________________ 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.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/254670"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=254670"}],"version-history":[{"count":3,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/254670\/revisions"}],"predecessor-version":[{"id":256421,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/254670\/revisions\/256421"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=254670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=254670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=254670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}