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.
IMDB
Your
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.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps