Homework 10 For this assignment you are to read in the data from the 'menu.txt file and create an SQLite database from it, called 'menu.db'.

Using php and sql:  Create a PDO object to connect to your database for running select queries.Write a database query to output all the messages in the messages table.

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;…

Task 3: The Marketing team wants to collect emails of the users on InstantStay. However, the team needs a SQL statement to execute inside their programming environment. You need to create a statement that they can easily run the EXECUTE command to return a single column table containing the USER_EMAIL addresses. Task: Create a prepared statement for use with the EXECUTE command.