In this Assignment, you will build a supermarket product management app that persists da offline. You will use IndexedDB and Localbase library to read, add, update, and delete produc in the database. The Product Management App should have the following CRUD features: 1. Create Product: when the user clicks on the create new product button in figure 1, you should open the add product page in figure 2 that allows the user to add a new product. Once they click on the save button, you should navigate them to the product page and show the newly added Product, as shown in figur Doha - Supermarket Read Products Figure 1: Product Page - Before adding any product Doha - Supermarket

Create a new user account with readWrite permission for your database using MongoDB

The Developers team also wants you to ensure that emails are converted to lowercase after an update operation. Currently, new insertions are guaranteed to have lowercase emails, but there is no such guarantee for legacy emails. Therefore, the team wants to ensure that emails are being retained in a lowercase irrespective of any changes in the database. Create a new TRIGGER called email_update for the USERS table that runs before an UPDATE operation. Task Create a TRIGGER to run on the USERS table before any UPDATE operation.

Question number 6

import sqlite3 from sqlite3 import Error # Creates connection to sqlite in-memory database def create_connection():     """     Create a connection to in-memory database     :return: Connection object     """     try:         conn = sqlite3.connect(":memory:")         return conn     except Error as e:         print(e)     # YOUR CODE HERE     # Use sqlite3.connect(":memory:") to create connection object     return conn # query to create the table table_sql = """ CREATE TABLE Horses (     id integer PRIMARY KEY NOT NULL,     name text,     breed text,     height real,     birthday text ); """ # query to insert data into the table ins_sql = """INSERT INTO Horses VALUES(1,'Babe','Quarter Horse',15.3,'2015-02-10'); """ # query to fetch all data from the table fetch_sql = """SELECT * FROM Horses;""" # creating db connection conn = create_connection() # fetching a cursor from the connection c = conn.cursor() # executing statement to create table c.execute(table_sql) # executing statement to…

How can you create a form that shows the columns of only a single row of a database in an application?

Scenario and Database Model: InstantRide InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the InstantRide mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. In the USERS table, information for the users are stored with their first name, last name and email:   In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving license number and check and rating information:   In the CARS table, all the cars in the InstantRide system are kept with the license plate, model and year:   Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and…

Computer Science Your task is to build an AJAX search form for this dataset that queries the City of Winnipeg Open Data API and displays search results below the form. Your form should include one or more inputs that correspond to fields within your selected JSON dataset. When the form is submitted you should use the form data to query the Open Data API. Your search should allow users to find a subset of records from a specific dataset. To do this you will be using the WHERE, ORDER and LIMIT capabilities of the Open Data API explained below. Your search form should return anywhere from 0 to a maximum of 100 results. If zero results are found, display a message letting the user know that nothing was found. Only HTML, CSS and Javascript should be used for this portion of the assignment. No PHP code should be used. (Your form will request JSON data from the open data API.)