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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started