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.

Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter6: Additional Database Objects
Section: Chapter Questions
Problem 1HOA
icon
Related questions
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 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.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Procedures in SQL
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L