Programming Assignment

Programming Assignment (50 Points): 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 (Netflix.csv) that is provided in this assignment. There are 10 columns in the csv file including:

id

title

type

description

release_year

age_certification

runtime (mins.)

genres

production_countries

imdb_score

You will create program to answer the following questions using any host programming languages such as C, C#, Java, Python , .. ,etc.

The questions include with:

  1. How many movies and tv shows for each genres?
  2. How many movies and tv shows group by age_certification?
  3. How many movies and tv shows that produced by country? (Using country code: US, GB, IN,…, etc.)
  4. List the movie and tv show’s titles that released in year? (Using year)
  5. Search the movie and tv show’s detail using title.

 

 

 

 

Submission:

Turn in your codes and db file(.csv) in folder name “PROG_ASSIGN_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 movies and tv shows for each genres?
  2. How many movies and tv shows group by age_certification?
  3. How many movies and tv shows that produced by country? (Using country code: US, GB, IN,…, etc.)
  4. List the movie and tv show’s titles that released in year? (Using year)
  5. Search the movie and tv show’s detail using title.
  6. Exit

_______________________________________________________

Select :  1

 

Crime             =          999

Comedy         =          999

….

 

 

 

 

 

__________________________________________________

CS 5200: Programming Assignment

_______________________________________________________

  1. How many movies and tv shows for each genres?
  2. How many movies and tv shows group by age_certification?
  3. How many movies and tv shows that produced by country? (Using country code: US, GB, IN,…, etc.)
  4. List the movie and tv show’s titles that released in year? (Using year)
  5. Search the movie and tv show’s detail using title.
  6. Exit

_______________________________________________________

Select :  2

PG                   =          999

PG-13            =          999

R                      =          999

 

_______________________________________________________

CS 5200: Programming Assignment

_______________________________________________________

  1. How many movies and tv shows for each genres?
  2. How many movies and tv shows group by age_certification?
  3. How many movies and tv shows that produced by country? (Using country code: US, GB, IN,…, etc.)
  4. List the movie and tv show’s titles that released in year? (Using year)
  5. Search the movie and tv show’s detail using title.
  6. Exit

_______________________________________________________

Select :  3

Enter Country Code: IN

There are 999 movie and tv shows produced in IN including:

Amrapali

Dostana

 

 

_______________________________________________________

CS 5200: Programming Assignment

_______________________________________________________

  1. How many movies and tv shows for each genres?
  2. How many movies and tv shows group by age_certification?
  3. How many movies and tv shows that produced by country? (Using country code: US, GB, IN,…, etc.)
  4. List the movie and tv show’s titles that released in year? (Using year)
  5. Search the movie and tv show’s detail using title.
  6. Exit

_______________________________________________________

Select :  4

Enter Year: 1980

There are 999 movie and tv shows released in 1980 including:

The Long Riders

Whispers

….

 

_______________________________________________________

CS 5200: Programming Assignment

_______________________________________________________

  1. How many movies and tv shows for each genres?
  2. How many movies and tv shows group by age_certification?
  3. How many movies and tv shows that produced by country? (Using country code: US, GB, IN,…, etc.)
  4. List the movie and tv show’s titles that released in year? (Using year)
  5. Search the movie and tv show’s detail using title.
  6. Exit

_______________________________________________________

Select :  5

Enter Title: Annie

 

Id: XXX

Title : XXX

Type: XXX

Description: XXX

release_year: 9999

age_certification: XXX

runtime (mins.): 999

genres: XXX

production_countries: XXX

imdb_score: 99.99

 

 

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.