Question: Complete this Python program that accomplishes the following 1. imports race_horse module 2. Defines create_database function. This function takes no parameters. The function

Complete this Python program that accomplishes the following
1.   imports race_horse module

2.   Defines create_database function. This function takes no parameters. The function does the following:
a.   Creates a database, horses
b.   Returns a list containing the database connection object and the cursor object

3.   Defines _table function. This function takes two parameters; the connection and cursor objects returned from the _database function. This function does not return data. The function accomplishes the following:
a.   Creates a race_horse table in the horses database
i.   Uses the cursor object to create the race_horse table with the following fields/columns
1.   horse_name (varchar(25))
2.   horse_color (varchar(15))
3.   horse_b_year (varchar(4))
4.   horse_races (varchar(4))
b.   This function does not return data

4.   Defines add_horses function. This function adds the RaceHorse objects to the race_horse table. This function takes three parameters: the database connection object, the cursor object, and a list containing RaceHorses as parameters. The function accomplishes the following:
a.   Loop through the list of RaceHorses and add each object to the race_horse table. To add an object to race_horse table, create and execute a query that uses the properties (horse_name,horse_color,horse_b_year, and horse_races) of the Object to set the column values in the race_horse table.
b.   This function does not return data


5.   Defines a display_data function. This function takes one parameter; the cursor object returned by the create_database function. This function does not return data. The function accomplishes the following:
a.   Execute query on the race_horse table for all rows
b.   Loops through the result of the query and displays each row of the table

6.   Defines a search_horse function. This function takes the cursor object returned by the create_database function as parameter and the name of a horse to be searched. This function does not return data. The function accomplishes the following:
a.   Executes a query that searches the race_horse table for a horse with horse_name equal to the name passed to the function
b.   Loops through the result of the query and displays each row in the query

Main Program

7.   Calls the create_database function
a.   Store the return data of the function
i.   Store the database connection object into a variable
ii.   Store the cursor object into a variable

Note: This function returns a list containing two items: the database connection object and the cursor object. Each item in the returned list will be stored in a separate variable

8.   Calls create_table function
a.   Pass the database connection object as argument
b.   Pass the cursor connection object as argument

9.   Creates a list of 5 RaceHorses
a.   Create an empty list, horses_list
b.   Use a while loop to prompt for the details of each RaceHorse
i.    a RaceHorse object
ii.   Add/Append the RaceHorse object to horses_list
iii.   Exit the loop once 5 objects are added to the list

10.   Calls the add_horses function
a.   Pass the horses_list as an argument
b.   Pass the database connection object as argument
c.   Pass the cursor object as argument


11.   Calls the display_data function
a.   Pass the cursor object as argument

12.   Prompt the user to enter the name of a RaceHorse (At the prompt, enter the name of one of the RaceHorses added to the database by the add_horses function)

13.   Calls the search_horse function
a.   Pass the name entered in the previous step, as a parameter
b.   Pass the cursor object as parameter

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!