Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The three text files contain data like they use in the IMDb (internet movie database). I posted this question several days ago and got a

The three text files contain data like they use in the IMDb (internet movie database). I posted this question several days ago and got a needs more info response. I dont know what other info you would need. We can use pseudocode, python or simply describe the process we would use in detail to read in these text files and create a list of the principals and their titles like the example of:
Carrie Fisher Star Wars 1977
We are to include the persons name (actor or actress), one of the titles associated with them, and the titles start year. (Only one entry per line.) It would be like pulling data out of a relational database and we would simply write this list to a separate text file. image text in transcribed
This is a database class
3, You are given three tab-delimited text files formatted as follows: title.basics 3. tconst (string) - alphanumeric unique identifier of the title . title (string) - the popular title at the point of release . startYear (Y) - represents the release year of a title. In the case of TV Series, it is the series start year . endYear (w)- TV Series end year. 'W' for all other title types name.basics nconst (string) - alphanumeric unique identifier of the name/person primaryName (string)- name by which the person is most often credited knownForTitles (array of tconsts) - titles the person is known for title.principals tconst (string) - alphanumeric unique identifier of the title principalCast (array of nconsts) - title's top-billed cast/crew . Your goal is to create a list of the principals and their titles. Each entry (line) will include the person's name, one of the titles associated with them, and the title's start year. Example: Carrie Fisher Star Wars 1977 Describe the process you would use to create this list. Be specific. You may assum enough memory to hold all data in program memory. (You may substitute a pseudocode implementation if you would prefer.)

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

Advanced MySQL 8 Discover The Full Potential Of MySQL And Ensure High Performance Of Your Database

Authors: Eric Vanier ,Birju Shah ,Tejaswi Malepati

1st Edition

1788834445, 978-1788834445

More Books

Students also viewed these Databases questions

Question

Relational Contexts in Organizations

Answered: 1 week ago