base class: str_databasename, int_databaseid, lst_tablenames and int_count. str_databasename will store the name of the database, int_databaseid will store the identification number of the database and each identifier number is a unique number. lst_tablena
Q: 8. In the following code below, the code selects an Employee object by primary key. However you…
A: The answer for the above given question is given below:
Q: create database GA2 go use GA2 go create table salesman( salesman_id int primary key, name…
A: In the given Customer table creation query, salesman_id is a foreign key. But the given syntax of…
Q: Which of the following statements is false? O Because a struct has a finite number of components,…
A: Given:
Q: The Data class contains: • a static array called courses. The array should be initialized by 4…
A: Note :- You have not mention the language ,So i am doing your question in Java language . Textual…
Q: Assume that a database has a table named Stock, with the following columns:Column Name…
A: SELECT statement: The SELECT statement is the most commonly used statement to retrieve (or fetch)…
Q: Develop a two small PL/SQL programs. 1. Enter students ID from the keyboard. The program then…
A: here i mentioned PL/SQL small two programs for given problem. also handled NO_DATA_FOUND and…
Q: Write the Java code to calculate your 'CGPA'. The grades history is recorded in a database. Consider…
A: import java.util.Scanner; class CGPACalculation { double sum=0; CGPACalculation(double…
Q: Below is the code for a procedure that will accept a Customer ID as an input parameter and display…
A: Q 1 % type attribute is used to create an attribute with the same size and data type as defined in a…
Q: Prompt the user for 10 data entries as Names, another 10 as weights corresponding to the names,…
A: Code: (change 3 in for loop to 10 to take 10 values) def bmr(h,w): return((int((h/w)*100))/100)…
Q: Company X is a new business entity in town and wants to ensure data Integrity in their database, as…
A: “Dаtа integrity” refers tо the ассurасy аnd соnsistenсy оf dаtа stоred in а dаtаbаse,…
Q: write a c++ program. Problem Statement: Developed as a console application without GUI, this…
A: #include <bits/stdc++.h>#include<conio.h>using namespace std;int main() { FILE *fp,…
Q: Design a windows (WPF) application which will display contents from your local movie Db. Demonstrate…
A: Design a windows (WPF) application which will display contents from your local movie Db. Demonstrate…
Q: _________________ allows you to write code to query databases in a language specific manner 1.…
A: Answer- 3. LINQ
Q: a. Load a database application…
A: Answer : given data, MovieID Movie Name Date Released Movie Category Quantity Delivered…
Q: write the steps to design new database file as (subjtable1.dbf) that consists .(of (2) fields:…
A: Steps to design the database named subjtable1.dbf in MySQL database: Use create table command to…
Q: Follow the lecture note in Week 4, create a new Java class (right click to app -> New ->Java class)…
A: CREATE TABLE [IF NOT EXISTS] DataBaseManager.StudentInfo(StudentID INTEGER PRIMARY KEY, FirstName…
Q: Write a PHP application that creates a class that allows connection to a specific MySQL database,…
A: Here we have given code for php application that creates a class that allows connection to a…
Q: Here you will be writing a program to maintain the student database. Your program will maintain the…
A: #Menu Structure Program for a Student database #Five arrays to store name, ID, Score1, Score2 and…
Q: Create a database class in python. Create four variables for the database class:…
A: The class is made in python language as asked in the question in the next step:
Q: Suppose we have the following student table in database. You have to write: Form load event…
A: load event to show all records in grid view…
Q: Write queries that provide the information asked by each question. Your queries should extract the…
A: SELECT Visit.VisitReason, COUNT(Visit.VisitReason) AS popular20sERFROM Visit FULL OUTER JOIN Patient…
Q: Below is part of a student database for your reference. The primary keys are highlighted in bold.…
A: 10) FROM student s, enrollment r, course c 12) AND r.courseno=c.courseno 22) FETCH course_list into…
Q: When SQL statements are embedded inside 3GL, we call such a program as a. Nested query b. Nested…
A: This mcq is based on SQL language.
Q: Build an application for a car rental company. It should offer the following features: • Maintain a…
A: please check the step 2 for code
Q: A .NET application requires a set of special components that let it connect to a database. A __ gets…
A: GIVEN: A .NET application requires a set of special components that let it connect to a database. A…
Q: create a program in C# to run stored procedure called GetCustomer that is stored in MS Sql server,…
A: I attached your answer below. Give connection properly you can get data from the SQL server. server…
Q: Make the functions below according to the attached class diagram and GUI program mockup. No The…
A: Actually, java is a object oriented programming language. It is a platform independent.
Q: create database GA2 go use GA2 go create table salesman( salesman_id int primary key, name…
A: Please refer to the following step for the complete solution of the problem above.
Q: Example: Parameter style JAVA procedure with XML parameters This example shows the following: •…
A: Code to create a parameter style JAVA procedure with XML parameters CREATE PROCEDURE xmlProc1 ( IN…
Q: create database GA2 go use GA2 go create table salesman( salesman_id int primary key, name…
A: As per the given data, while creating salesman table, you have declared commission with datatype…
Q: 4.1 Create a database called checkersproducts using MySQL or any relational database management…
A: In below we make a program to fulfill all the question: 1.create database and table products: CREATE…
Q: Use Visual Studio to create a database named Personnel.mdf. The database should have a table named…
A: Open MS Visual Studio. Go to File ->New->Project. New Project dialog box opens. In…
Q: b) Write code segment with SQL statements that will: -Insert these details into the table at the…
A: Assume you have successfully connected your application, developed in Visual Net using ADO to MySQL…
Q: Assume that a database has a table named Stock, with the following columns:Column Name…
A: SELECT: The "SELECT" statement is been used for selecting data from a database. The result table is…
Q: Which statement is used to create a user-defined data type?a. Declareb. Define c. Structured.…
A: User-defined data type: The data types such as Integer, Double and Decimal are in-built data types…
Q: DECLARE v_emp_id vr emp employees.employee_idXTYPE : :Enter Employee Id; employeesXROWTYPE; BEGIN…
A: Below i have answered:
Q: Take the supplied cars_db.sql and create your Cars database (you will have to create the Cars…
A: Actually, Java is a programming language originally developed by James Gosling at Sun Microsystems…
Q: create database GA2 go use GA2 go create table salesman( salesman_id int primary key, name…
A: In SQL table is created by creating command and values are inserted by insert command. Syntax for…
Q: Build an application for a car rental company. It should offer the following features: • Maintain a…
A: Build an application for a car rental company. It should offer the following features:• Maintain a…
Q: Given the following data structures definitions: istruct Record { string word; int occurrenceCount;…
A: C-structure: A structure is a user-defined data type that can hold the data members of the different…
Q: Mr. Alice is trying to modify the Created Date Field in Salesforce. but he is getting null pointer…
A: Given: -
Q: Consider the following struCtu Orade database. selneman eutomer MUMERIO ($) VARCHAR 30) ARCHAR (161…
A: Where clause is used to put condition check.
Q: Which of the following is VALID for dynamic objects? Select one: a.Dynamic objects are created by…
A: Dynamic memory allocation technique is used for allocation of memory at run time.
Q: I am having an issue creating this function with a trigger using postgreSQL (plpgsql). Could someone…
A: Below is the required answer with explanation:
Q: Customers are charged a simple interest per annum on any approved loan. Assuming every loan applied…
A: The complete code is given below . Please like , thank you
Q: For this week's assignment you will allow the user to add employee, view all employees, search…
A: Search employee by ssn, and edit employee information. Below this is what its supposed to look like…
Q: Questions Begin Here 1. Write a FUNCTION that will take price as a parameter and give the following…
A: if the price is greater than or equal 1000 and below 2000, set discount to 10 percentage if the…
Q: The Marketing team of InstantStay wants to create mailing lists for the users. However, they need a…
A: Users Table Info:
Q: O CREATE TABIE Deparimant ( Depart ment. id VAREHAR (10) PRMARY EY, Depariment name VARCHAR (20);…
A: ER Diagram: ER Diagram is a diagram which shows relationships of entities that are stored in a…
Q: Write the code you would place in the AverageButton click event on your form to call the Average…
A: Program
using python
Create four variables for the
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- 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…Population Database You will find a program named CreateCityDB.java in Starting Out with Java: Early Objects (6th Edition) Chapter 15 Source Code. Compile and run the program (SEE BELOW). The program will create a Java DB database named CityDB. The CityDB database will have a table named City, with the following columns: Column Name Data Type CityName CHAR (50) Primary Key Population DOUBLE The CityName column stores the name of a city, and the Population column stores the population of that city. After you run the CreateCityDB.java program, the City table will contain 20 rows with various cities and their populations. Next, write a JavaFX application called PopulationDemo that connects to the CityDB database and allows the user to click any of the following operations: Sort the list of cities by population, in ascending order. Sort the list of cities by population, in descending order. Sort the list of cities by name. Get the total population of all the cities. Get the…Create a database class in python. Create four variables for the database class: str_databasename, int_databaseid, lst_tablenames and int_count. str_databasename will store the name of the database, int_databaseid will store the identification number of the database and each identifier number is a unique number. lst_tablenames will store the list of tables for one particular database object. Int_count will store the number of tables for this database object.
- 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;…A computer store uses a database to track inventory. The database has a table named Inventory , with the following columns: ProductID INTEGER PRIMARY KEY NOT NULL ProductName TEXT QtyOnHand INTEGER Cost REAL Also assume that the cur variable references a Cursor object for the database. Write Python code that uses the Cursor object to execute an SQL statement that deletes the row in the Inventory table in which ProductID is equal to 12.The Save Transaction button depicted in the screen attached is used to save relevant data to the sales table and the salesdetails tables from the depicted schema. When this button is clicked it calls the saveTransaction() function that is within the PosDAO class, it passes to this function an ArrayList of salesdetails object, this list contains the data entered into the jTable which is the products and qty being sold.Write the saveTransaction function. You are to loop through the items and get the total sales, next you are to insert the current date and the total sales into the sales table. Reminder that the sales table SalesNumber field is set to AUTO-INCREMENT, hence the reason for only entering the total sales and current date in sales table.
- a. Load a database application Create a database labelled asMOVIE_LIBRARY in the created folder with the following fields: MovieID, Movie Name, Date Released, Movie Category, Quantity Delivered. MovieID Movie Name Date Released Movie Category Quantity Delivered MV01 Girl Next Door 05/05/2020 Action 88 MV02 Transformer 4 25/06/2010 Horror 110 MV03 Fast and Furious 7 20/07/2018 Comedy 10 MV04 Blended 26/10/2019 Action 150 MV05 Noah Reloaded 07/08/2019 Adventure 99 MV06 Gifted Hands 30/09/2009 Drama 190 MV07 The Legend of Hercules 25/03/2017 Action 120 MV08 RoboCop 14/12/2019 Action 50 MV09 Son of Batman 17/02/2018 Adventure 100 MV10 Frankenstein 08/01/2020 Horror 120 Save the table as tblMovies.…Make use of Windows Presentation Foundation (WPF) to develop a Stock Management System thatwill manage the items being stocked in a warehouse. The application has 3 modules named: Addproduct, List Product, and Print Bar Code.Add Product:This module is used for adding new products to the system. It will require some basic details likeProduct category, Product Name, cost price, selling price, quantity and bar code. The details willbe saved into a SQL database named StockSystemdb. One other interesting feature of this systemis the alert system.You can set a particular quantity for each item. Now a notification or alert will be given to the userif a particular item’s quantity gets below the set quantity. This will help the user in gettingnotifications of the items getting low in stock.List Product:This module lists all the items present in the database of the Stock Management System. It will haveoptions to edit the details of each item or delete a particular item from the list.Print Bar…Create a function in your own database that takes two parameters: A year parameter A month parameter The function then calculates and returns the total sales of the requested period for each territory. Include the territory id, territory name, and total sales dollar amount in the returned data. Format the total sales as an integer. Hints: a) Use the TotalDue column of the Sales.SalesOrderHeader table in an AdventureWorks database for calculating the total sale. b) The year and month parameters should have the SMALLINT data type.
- The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule. Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDsThe database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule.Assume that a database has a table named Stock, with the following columns:Column Name TypeTrading_Symbol nchar(10)Company_Name nchar(25)Num_Shares intPurchase_Price moneySelling_Price money Write a Select statement that returns the Trading_Symbol column and the Num_Shares column only from the rows where Selling_Price is greater than Purchase_Price and Num_Shares is greater than 100. The results should be sorted by the Num_Shares column in ascending order.