Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 Database 19c DBA By Examples Installation And Administration

Authors: Ravinder Gupta

1st Edition

B09FC7TQJ6, 979-8469226970

More Books

Students also viewed these Databases questions

Question

question Factor fully: 64x2 49 (8x + (8 + 7x) (8 7x)

Answered: 1 week ago