Question: IMDB database that match those search criteria. Your program must include the following requirements: Connect to the same database server, using the same account as

IMDB database that match those search criteria.

Your program must include the following requirements:

Connect to the same database server, using the same account as in the IMDB browser (the server is cisdbss.pcc.edu, and the username and password are 275student).

Write a program that fetches data about a particular name from the NAMES database.

Use the NAMES database on that server instead of the IMDB database, and modify your query. Here's an example query that should produce reasonable results:

SELECT Name, Year, Gender, NameCount, Total

FROM all_data

WHERE Name = 'Marc'

AND Gender = 'M'

ORDER BY Year;

Running the query should fetch the following data - only the first five rows are shown:

Name

Year

Gender

NameCount

Total

1

Marc

1915

M

13

848603

2

Marc

1916

M

14

890099

3

Marc

1917

M

9

925511

4

Marc

1918

M

18

1013537

5

Marc

1919

M

17

980149

The user should be able to enter a name and a gender, and be able to view yearly data on how popular that name was on a year-by-year basis in a scrollable table (using a tkinter treeview.

Radio buttons might be a good choice for allowing the user to choose gender.

You may follow the structure of the IMDB Browser program, but all of your functions and variable names should be named descriptively and appropriately for a name popularity browser. For example, it would be inappropriate to have an entry named "min_votes" when the actual value that the user is entering in that box is a person's name.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!