Midterm - 2 Questions (1)

In java create an application to manage your data base information the database is already created in mysql tables, the tables are fill, So the user can use your database application user friendly Retrieve all data: Given a table name, retrieve all data from the table and present it to the user. Average: Given a table name and a column name, return the average of the column. Here the assumption is that the column type will be numeric (e.g., cost column). Insert: Given a table name, your program should show the column names of that table and ask the users to input new data to the table. In case of errors, your program should directly show the MySQL errors to the users. Assumption 1: Users will enter data according to the database constraints. Assumption 2: Users will input one record at a time. Delete: Given a table name, your program should show the column names of that table and ask the users to input data that they want to delete. Assumption 1: Users will enter data according to the…

The code shown below is designed to increment through each row in a database table. Correct the error in the code.For intRecordCount = 0 To datPeople.Rows.Count' Processing statementsNext

Develop a C++ program to connect to a MS Access database (“Student.accdb” – attached to this assignment) and use SQL commands to manipulate its records. You may use MS Access, SQLite or another DB engine and drivers.  Scope The user will be given a menu to choose from the following options:   Press (S) to select and display all students records Press (D) to delete a student by ID# Press (U) to update a student’s graduation year Press (I) to insert a new student Press (Q) to quit   For user option# 1, first display the header and then display every record on a separate line. See example below Student ID First Name Last Name Major Graduation Year 1 Joe Doe Computer Science 2018 2 Emma Smith Electrical Engineering 2019 3 Juan Perez Marketing 2019 For user option#2, confirm back to the user whether the deletion was successful or the ID provided was not found in the students records. For user option#3, prompt the user to enter a student ID, validate if the student ID exists…

I have been trying to get this program to work but every time I fix one area it throws 2 more codes, please show me what I am doing wrong, it is supposed to create a Database, with options to view all, add to, take away, update row, and view individual rows with a loop to repeat. _________ import sqlite3   #Define functions def CreateMemberDB(): conn=sqlite3.connect('Members.db') curs=conn.cursor() #create a table cmd_str=''' CREATE TABLE Member_Info( Name TEXT, Number INT, Phone NUMERIC )''' #send string to DB curs.execute(cmd_str)   starting_data = ( ('Anna', 2435, 2345678910), ('Bryan', 2436, 3456789101), ('Claudia', 2437, 4567891012), ('Tom', 2438, 5678911234), ('Dusty', 2439, 6789112345) ) for row in starting_data: cmd_str= ''' INSERT INTO Member_Info(Name, Number, Phone) VALUES(?,?,?) ''' curs.execute(cmd_str, row)   conn.commit() conn.close()   def GetallMemberInfo(): conn=sqlite3.connect('Members.db') curs=conn.cursor() sql_cmd = 'SELECT ROWID, Name from Member_Info'…

class Database:def __init__(self, db_name):self.db = sqlite3.connect(db_name)self.cursor = self.db.cursor()def create_table(self, table_schema):self.cursor.execute(table_schema)self.db.commit()def insert_data(self, table_name, data):for i in range(len(data)):keys = ", ".join(data.columns)values = ", ".join([f"'{value}'" if pd.isna(value) else str(value) for value in data.iloc[i]])self.cursor.execute(f"INSERT INTO {table_name} ({keys}) VALUES ({values})")self.db.commit()def search_data(self, table_name, year):self.cursor.execute(f"SELECT * FROM {table_name} WHERE year={year}")result = self.cursor.fetchone()if result is not None:return resultelse:return Nonedef delete_data(self, table_name, year):self.cursor.execute(f"DELETE FROM {table_name} WHERE year={year}")self.db.commit()return self.cursor.rowcount > 0   Please rewrite (or convert) the code above with format: def QueryBuilder( Data_Base, Query_Type, Query_Tuple):'''''' Build Query_String'''''' return Query_String

In this database we have users that can be two types students or instructors. They have groups and memberships. Any user can post and the post type can be video, photo or text.  Here is the table structure: CREATE TABLE USER_ (   USER_ID INT NOT NULL AUTO_INCREMENT, CREATE_DATE DATE NOT NULL, PROF_DESC VARCHAR (100), PROF_PIC VARCHAR(40), LOCATION VARCHAR (40) NOT NULL,       PRIMARY KEY (USER_ID) );  CREATE TABLE USER_INFO( USER_ID INT NOT NULL, SU_EMAIL CHAR(18), USER_FNAME VARCHAR(15), USER_LNAME VARCHAR (15), USER_DOB DATE, USER_GENDER CHAR(1), PRIMARY KEY (USER_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE STUDENT (   SU_ID INT NOT NULL, USER_ID INT NOT NULL, YEAR_ VARCHAR (10), MAJOR VARCHAR (20), LOCATION VARCHAR (40) NOT NULL,      PRIMARY KEY (SU_ID), FOREIGN KEY (USER_ID) REFERENCES USER_(USER_ID) ON UPDATE CASCADE ); CREATE TABLE INSTRUCTOR (   SU_ID INT NOT NULL, USER_ID INT NOT NULL, DEPARTMENT VARCHAR (40), INSTR_TYPE VARCHAR (40),…

Task 6: The StayWell Property Management team considers creating a discount scheme for the property owners with more than one property in the system. You will need to provide all the owner IDs (OWNER_NUM) and the count of properties of the owners with more than one active property in the database. The output columns should be OWNER_NUM and COUNT(*) respectively.

oracle PL/SQL Create an anonymous block that prints all instructors First Name, Last name, and a phone. Hint: Use cursor and coursor FOR loop.  desc instructor----------------------------------------- -------- ----------------------------INSTRUCTOR_ID     NOT NULL NUMBER(8)SALUTATION   VARCHAR2(5)FIRST_NAME    VARCHAR2(25)LAST_NAME    VARCHAR2(25)STREET_ADDRESS   VARCHAR2(50)ZIP   VARCHAR2(5)PHONE   VARCHAR2(15)

SQL A programmer wrote code with the underlying SQL to check if a user can access / log into a system. SELECT * FROM users WHERE login = ‘ replaced by the input login ‘ AND password = ‘ replaced by the input password ‘ What is the query if login is ‘OR true -- and password is Hello? Write the query.         What does the query above return?         What is the name of this security issue?

Database Access Code Write the codethe best that you can to execute the following SQLstatement against a database. Your code should read thedata from the DB and print out all of the data. Thedatabase is an Access database, setup with an ODBCname of "AccountingDB'. Do the best you can, partialcredit will be given. Put your code in the main methodgiven below. [Hint: SQL will return all accounts from thedatabase.]SOL = "Select AcctNo, Owner, Balance fromAccounts"public static void main (String args[])

SQL Queries Specify the following SQLite queries on the chinook database.  A schema for the database is in the picture. You can access the database online through your web browser at the SQLite Tutorial, or you can download the chinook.db database from the tutorial site and run it on a labnet machine or your own machine.  SQLite is already installed on labnet machines. You must submit typed queries, not handwritten ones, and save them in a .pdf document.  There is no need to submit the output (results). Each query is worth 1 mark, but some are more difficult than others.   Queries to Specify 5. List the customer id, last name and email address of all customers with a Yahoo or Hotmail email address. 6. List the album id and number of tracks for all albums with 15, 16 or 17 tracks, in descending order of the number of tracks. 7. Find the maximum track length in milliseconds. 8. List the last name, first name and hire date of all employees born in 1961 to 1969 inclusive 9. List the…

SQL Queries Specify the following SQLite queries on the chinook database.  A schema for the database is in the picture. You can access the database online through your web browser at the SQLite Tutorial, or you can download the chinook.db database from the tutorial site and run it on a labnet machine or your own machine.  SQLite is already installed on labnet machines. You must submit typed queries, not handwritten ones, and save them in a .pdf document.  There is no need to submit the output (results). Each query is worth 1 mark, but some are more difficult than others.   Queries to Specify 1. List the last name, postal code and country for all customers from Germany. 2. List the city and number of customers from each city. 3. List the customer id, last name and city for the first 20 customers, when they are ordered by last name ascending. 4. List the customer id, last name and company for all customers who have any company details recorded (the company attribute is not "null").…

Solve all parts with explanation and Don't use ai to answer

Which of the following is the correct definition of alias in SQL statement? a. It specifies the table containing the columns listed in the SELECT clause b. It retrieves information from the database c. It is a way of renaming a column heading in the output d. It is a value that is unavailable, unassigned, unknown, or inapplicable

awk is similar to the SQL language in that you can query certain records. What command below will search the the file /etc/passwd file by locating all users that have a default shell '/bin/bash' and print the first column (which is the user name). awk -D: '$7 == "/bin/bash" {print $3}' /etc/passwd Give this to your new intern to figure out. awk -F: '$4 == "/bin/bash" {print $10}' /etc/passwd awk -F: '$7 == "/bin/bash" {print $1}' /etc/passwd awk -F: '$1 == "/bin/bash" {print $7}' /etc/passwd.

SQL A table Products have: a name (TEXT) a description (TEXT) a unit cost stored in cents (INTEGER) and of course we also add an id column to identify them. Separately, we'd like to track the number of items in stock for each product. To do so we'll have a store and an inventory table. Stores have just an id and a name. Then, our inventory table should combine stores and products, listing how much of each product each store has in stock. a product_id (INTEGER) a store_id (INTEGER) a quantity (INTEGER) in stock Now we can insert some stores, products and inventory into our database. There are 2 stores -- one called NY and one called NJ. There are 2 products we are concerned with. Their names are sneakers, costing $220 (remember this is dollars!) and boots costing $350. Use any description for each that you'd like. NY has 4 sneakers in stock and 3 boots. NJ has 5 sneakers in stock and no boots. Insert the above data into the tables you have created.

Solve B I. This Project asks you to submit a SQL text file (e.g. project2.sql) with all your answers to all the questions listed in this assignment. Your answers will be written in SQL format. All SQL statements will be tested in a MySQL database including: CREATE TABLE, ALTER TABLE, INSERT and SELECT. You must use the following table structures for your MySQL DDL and DML commands: STUDENT(StudentID, LastName, FirstName, Address, City, State, Zip, Phone) StudentID will be automatically increased integer identifier Choose VARCHAR or CHAR based on your personal understanding of the fields for the rest part of the relation/table STUDENT_TEXTBOOK(StudentID, TextbookID, Class, Semester, Year) Semester would be CHAR Year would be integer TEXTBOOK(TextbookID, Description, Price, Location, BookstoreID) TextbookID will be automatically increased integer identifier Price is a decimal with 2 decimal places after zero Description and Location can be VARCHAR or CHAR based on your personal…

The SQLiteOpenHelper and SQLiteCursor classes are described, with a focus on how they may be used to perform create, read, update, and delete (CRUD) actions on a SQLite database.

q4)   Which of the following is the correct definition of alias in SQL statement? a. It is a way of renaming a column heading in the output b. It specifies the table containing the columns listed in the SELECT clause c. It is a value that is unavailable, unassigned, unknown, or inapplicable d. It retrieves information from the database

Use the DDL SQL command “CREATE” to define each of your entities in the following E-R diagram

In Java Java Language

QUESTION 7 The -------- section in PL/SQL block addresses two situations: either an oracle error is raised or a user-defined error is raised. O A. Declare B. Exception С. Вegin D. End QuE CTIONL

q6- Choose ALL that apply.

Write in SQL a command that creates the table Customers according to the above description.  Write in SQL a statement that adds a new column named accountID of type Char(8). This column should be defined as a foreign key that relates the table Customers to the table Account .  Write in SQL a command that deletes the customers whose date of birth is after 22-Dec-1990 .

Oracle Database 18c XE comes with a sample database user named HR. This user owns several database tables in a sample schema for a fictional Human Resources department. However, for security reasons, this user's account is locked. You need to unlock this account before you can view the HR objects or build any applications that use these objects. Assume that you are logged in as Systems Administrator, provide the SQL*plus commands for unlocking the HR account, making sure that the password reuse and life time is unlimited.

In derby database and java language

In python code: Using the dataframe produced in question#2 and your Database class from Lab1, Byte Stream your dataframe into your Database object. Also, use your Query Builder to build the Insert Query for your byte stream insertion.    class GreenhouseGas(NamedTuple):    Gas: str    Pre_1750: float    Recent: float    Absolute_increase_since_1750: float    Percentage_increase_since_1750: float     def __repr__(self):        return f"Gas: {self.Gas}, Pre-1750: {self.Pre_1750}, Recent: {self.Recent}, Absolute increase since 1750: {self.Absolute_increase_since_1750}, Percentage increase since 1750: {self.Percentage_increase_since_1750}"     def __lt__(self, other):        return self.Recent < other.Recent        def __eq__(self, other):        return self.Gas == other.Gas        @classmethod    def from_list(cls, data):        gas, pre_1750, recent, absolute_increase, percentage_increase = data        return cls(gas, pre_1750, recent, absolute_increase, percentage_increase) def…