Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The first line in the input file will always be the header line containing the column headers (i.e., it will not have data for a

The first line in the input file will always be the header line containing the column headers (i.e., it will not have data for a movie).

All the other lines will have the data for a movie in valid format and no columns will be missing.

The file will not have any empty lines.

The file will contain data for at least one movie.

Don't assume a maximum number of movies in the file.

Commas appear as delimiters between columns, but will not appear in the values of any columns.

The name of the input file will be less than 50 characters and will not contain any spaces.

Don't assume that the input file name will have a particular extension.

This file has the following columns:

Title

This is a string with the movie title.

e.g., Iron Man 2

You cannot assume a maximum length of the movie title.

Year

This is a 4 digit integer value for the year the movie was released

It's value will be between 1900 and 2021 (inclusive of these years).

e.g., 2010

Languages

The language or languages in which the movie was released.

One or more string values that are always enclosed within []

Multiple values are separated by semi-colons.

e.g.,

[English;Portuguese;Spanish]

[English;French]

[English]

You can assume that the maximum number of languages any movie can be released in is 5.

You can assume that the maximum length of a language string is 20 characters.

You cannot assume any particular case for the letters in the language.

e.g., don't assume that the first letter is upper case, or that all letters are lowercase.

Rating Value

A number between 1 and 10 (inclusive of both 1 and 10)

It can be an integer or a double with one digit after the decimal point

e.g.,

5

8.7

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle 12c SQL

Authors: Joan Casteel

3rd edition

1305251032, 978-1305251038

More Books

Students also viewed these Databases questions