please make this on access step by step

. Add a customer: Given all necessary information add a customer to the DB can you use an exception too Feature 17: Add a customer. Input: Create a procedure with Cust_ID, Cust_name, Cust_email, Cust_street_address, Cust_city, Cust_state, Cust_Zip, Cust_Credit_Card and a cursor to store the select statement output into the cursor. Output: Creates a new row in the Customer table and displays the values with the cursor. Example of calling the feature: Exec add_customer(23, ‘James Miller’, ‘jamesmiller@gmail.com’, ‘221 Main Street’, ‘Ocean City’, ‘MD’, 28392, ‘2234 1276 2773 1728’);

Please list the three exception processes.

Create an application which can access a database. Create a database with an application user, user specific for your application to use, and 1 table of a couple of fields properly indexed. Grant permissions for the user to access the table. (submit .SQL file) Create a simple application, language of your choice, (BE languages only, no JS or Node) which can do the following operations: (submit source code file): Connect using the application user created above. Insert into the table, and select from the table using a WHERE clause, where all fields are parameterized. Display results of the select. Use a simple web server API interface for data input and output, which can be accessed via local browser or curl.

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…

1) Create a folder (directory) called "sqlite" (without the quotes) in your base drive (eg. C:\sqlite) 2) Create a Database called "test.db" (without the quotes) in C:\sqlite using Sqlite DBBrowser (Make sure the extension is .db – not .sqlite) 3) In test.db create a table called book. The table should have the following columns: Id – Integer, Not Null, Unique, Primary Key, Auto Increment Author – Text, Not Null Title - Text Not Null Year - Integer, Not Null Price - Real, Not Null - Add some rows with data for the above table. Create the user interface shown below in WindowBuilder. Write a WindowBuilder Java program to do the following: (Everything should be in a SINGLE Java program). To make connection to the Database, use the SqliteConnection.java and sqlite-jdbc.jar file provided in Canvas under Modules->Chapter Code (Do not use your own files for these two). Display Records Author: Title: Year: Price: Find Update