I have to create a database using python to show geographical points. Create a program the will create your database and insert at least five points. Use your own data, something like: 100, 200, 123, Main Campus 120, 133, 142, Montoya 153, 123, 322, Rio Rancho 133, 123, 143, STEMULUS Center 153, 142, 122, ATC   Run your initialization code to create the database.

Complete the Python program to create a Horse table, insert one row, and display the row. The main program calls four functions: create_connection() creates a connection to the database. create_table() creates the Horse table. insert_horse() inserts one row into Horse. select_all_horses() outputs all Horse rows. Complete all four functions. Function parameters are described in the template. Do not modify the main program. The Horse table should have five columns, with the following names, data types, constraints, and values: Name Data type Constraints Value Id integer primary key, not null 1 Name text   'Babe' Breed text   'Quarter horse' Height double   15.3 BirthDate text   '2015-02-10' The program output should be: All horses: (1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10')

Using the data file below design a hierarchical struct to organize the data. Then declare an array of structs for the reservations.  The data file contains ten reservations. There are 8 columns of data: party name, size, date and time for the reservation, phone number, email address, credit card number and expiration date for the credit card. The data can be read from the file below so you will not need to type it in repeatedly.  Once you have populated the array with data perform the following tasks: Write a function that will print out to the screen the information for one reservation.In the main program write code that prompts the user to enter a date in the form MM DD YYYYCall the function to print out all reservations on that date. You can make a loop that calls the print function repeatedly or you can put that code inside the print function.TEST CASES:  April 30, 2023 and May 12, 2023. In this example you need to carefully consider what data types to use. For example, the credit…

The file london_weather.csv  contains weather data for the years 1979 to 2020. The first five lines of this file are: date,cloud_cover,sunshine,global_radiation,max_temp,mean_temp,min_temp,precipitation,pressure,snow_depth19790101,2,7,52,2.3,-4.1,-7.5,0.4,101900,919790102,6,1.7,27,1.6,-2.6,-7.5,0,102530,819790103,5,0,13,1.3,-2.8,-7.2,0,102050,419790104,8,0,13,-0.3,-2.6,-6.5,0,100840,2 Note, in particular, that the dates are given as eight-digit integers in the format YYYYMMDD. There appears to be some inconsistencies in this data, as there are rows for which the column max_temp contains an entry that is smaller than the corresponding entry in min_temp. Write a Python function wrong_temperature(year) that returns the number of days in a given year for which the column max_temp contains an entry that is smaller than the corresponding entry in the column min_temp.

Using the data file below design a hierarchical struct to organize the data. Then declare an array of structs for the reservations.  The data file contains ten reservations. There are 8 columns of data: party name, size, date and time for the reservation, phone number, email address, credit card number and expiration date for the credit card. The data can be read from the file below so you will not need to type it in repeatedly.  Once you have populated the array with data perform the following tasks: Write a function that will print out to the screen the information for one reservation.In the main program write code that prompts the user to enter a date in the form MM DD YYYYCall the function to print out all reservations on that date. You can make a loop that calls the print function repeatedly or you can put that code inside the print function.TEST CASES:  April 30, 2023 and May 12, 2023. In this example you need to carefully consider what data types to use. For example, the credit…

Hive table’s column, PERSON has an array value, [“jihee”, “jong”,“hemo”]. What function generate three records from the array value,[“jihee”, “jong”, “hemo”]?a. RECORDS(PERSON)b. EXPLODE(PERSON)c. LINES(PERSON)d. ROWS(PERSON)

For this week's assignment you will allow the user to add employee, view all employees, search employee by ssn, and edit employee information. Below this is what its supposed to look like when completed. I have also included what I started to do but I can't figure out how to add the search by SSN option or the edit employee option. If you can give me a step by step on how to do this in python I would greatly appreciate it.

When the Search button is pressed in the screen depicted, the getSales() function from the PosDAO.java class is called, the parameters of this function are the from date and to date.The getSales () function should return a list of Pos objects that matches the criteria specified, Note this function has to perform two INNER JOINs in to combine all three tables in order to get all the needed data to fill the Pos object. The database schema is also depicted. The PosDAO, Product, SalesDetails and Pos classes are shown BELOW Write the getSales() function public class PosDAO {     private Connection conn;    PreparedStatement stmt = null;    public boolean openConnection(){     try {         // db parameters         String url = "jdbc:mysql://localhost:4306/swen2005";         String user = "root";         String password = "";         // create a connection to the database         conn = DriverManager.getConnection(url, user, password);         if (conn!= null){             return true;…

The symbol table stores the memory address associated with each variable. What is the memory address of the start_time variable in main()? You only need to fill in the last 2 digits of the address. 0x7ffd949d30__ What symbol was added after the data type of MoveSchedule's start_time and end_time parameters? Place a check (​​✓)​​ beside your answer. int * & start_time What is the memory address of the start_time variable in MoveSchedule()? You only need to fill in the last 2 digits of the address. 0x7ffd949d30__ What happens to the value of the start_time variable in main() when the start_time variable in MoveSchedule is updated?  Place a check (​​✓)​​ beside your answer. start_time in main remains the same start_time in main gets the value assigned to start_time in MoveSchedule start_time in main changes to 0.

You have a table that contains the following fields: Last Name, First Name, Street, City, State, and Postal Code. There are 50,000 records in the table. What indexes would you create for the table?   You have a table that contains the following fields: Book ISBN Number, Book Title, Author Last Name, Author First Name, Publication Year, and Publisher Name. There are 75,000 records in the table. What indexes would you create for the table?