3.7 LAB - Create Horse table with constraints Create a Horse table with the following columns, data types, and constraints. NULL is allowed unless 'not NULL' is explicitly stated. • ID - integer with range 0 to 65 thousand, auto increment, primary key • RegisteredName - variable-length string with max 15 chars, not NULL • Breed - variable-length string with max 20 chars, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred • Height - number with 3 significant digits and 1 decimal place, must be ≥ 10.0 and ≤ 20.0 • BirthDate - date, must be ≥ Jan 1, 2015 Note: Not all constraints can be tested due to current limitations of MySQL.

LAB ASSIGNMENT, CONT. 2) author_book.py Use the previous project as a model. This time, use a variable called readings, of the dictionary data type (instead of users). It stores your favorite authors and book titles, as key-value pairs. Initialize the dictionary with 3 authors and book titles. Like the previous program, this one should display a command menu and let the user view, add, edit and delete dictionary entries. With the new program, you need to adapt the variable names, user-facing messages and capitalization strategies to fit the new content. NOTE: test data needs to use the same capitalization strategy as the program. COMMAND MENU view - View readings add Add a reading edit del exit Edit a reading Delete a reading Exit program Command: edit Enter author's name: G.W. Bush Current book title is 41: Portrait of My Father. Enter new title for G.W. Bush: Decision Points G.W. Bush title was edited to Decision Points. Command:

*Data Structures and Algorithm

hi I really need help with this assignment problem flip_matrix(mat:list)->list You will be given a single parameter a 2D list (A list with lists within it) this will look like a 2D matrix when printed out, see examples below. Your job is to flip the matrix on its horizontal axis. In other words, flip the matrix horizontally so that the bottom is at top and the top is at the bottom. Return the flipped matrix. To print the matrix to the console:  print('\n'.join([''.join(['{:4}'.format(item) for item in row]) for row in mat])) Example: Matrix:W R I T XH D R L GL K F M VG I S T CW N M N FExpected:W N M N FG I S T CL K F M VH D R L GW R I T X Matrix:L CS PExpected:S PL C Matrix:A D JA Q HJ C IExpected:J C IA Q HA D J

def sw_vehicle_search(cargo_capacity: int, max_speed: int, cost: int) -> list: This function will use the https://swapi.dev/ API to collect its information. This function is meant to be used to search for vehicles in Star Wars that meet the specified criteria. The function should return a list of names of the vehicles that have cargo capacities and a max speed greater than or equal to the value specified but also cost less than or equal to the cost given. Vehicles with "unknown" or "none" for any of the mentioned categories should not be regarded.

Keep in mind that not all of the vehicles in star wars are returned in one request to https://swapi.dev/api/vehicles/. The JSON object returned by this request has a next attribute that represents the next page of information. You must make multiple requests for each page to collect all vehicle information. You might find it helpful to use the following API handle(s): https://swapi.dev/api/vehicles/ - to retrieve all vehicles in Star Wars…

individual characters using their 0-based index. Hint: You will need to do this for checking all the rules. However, when you access a character .

Python question please include all steps and screenshot of code. Also please provide a docstring, and comments throughout the code, and test the given examples below. Thanks. Write function week() that takes no arguments. It will repeatedly ask the user to enter anabbreviation for a day of the week (Mo, Tu, We, Th, Fr, Sa, or Su) and then print thecorresponding day. Use a dictionary to implement this result.>>> week() Enter day abbreviation: TuTuesdayEnter day abbreviation: SuSundayEnter day abbreviation: SaSaturdayEnter day abbreviation

Overview This is a review assignment where you will use multiple tools you have picked up so far throughout the course. If you're confused about how to do something make sure you look back at earlier assignments. In this program you will start by declaring an empty dictionary named population_dict. Then you will use a while-loop to prompt a user for a series of cities and their populations, storing the input in population_dict). After this you will prompt the user to decide what is the maximum population for a city to be considers a small down. Finally, you will open a file called populationdata.txt where you will write the results. Expected Output Example of standard out (the console): What is next city? (enter q to quit) Long Beach What is the population of Long Beach? 362000 What is next city? (enter q to quit) Los Angeles What is the population of Los Angeles? 382000000 What is next city? (enter q to quit) San Diego What is the population of San Diego? 136000000 What is next city?…