Instructions are on the image. UsingANDROID STUDIOplease provide the java code screenshot and5 output of the application. Thank you 74.5-75.9974.4 and below3Fail InstructionsCreate an application that will calculate for theFinal Grade of the Student for the Inputtedsubject, the program should do the following:• It should be able to ask for the name of thestudent, Name of Subject, input grades forthe (prelim, midterm, prefinal, finals).The database should be named"academe_db" and a table named"student_grade_list".The table should contain: ID,student_name, subject_name, GWA• Be guided by for the corresponding GWAbelow and use the equation for final grade(prelim*0.2+midterm*0.2+prelim*0.2+final*GRADES10097-99.9993-96.9989-92.9985-88.9980-84.9976-79.9974.5-75.99=GWA1.001.251.501.752.002.252.753

Answered: 74.5-75.99 74.4 and below 3 Fail

Engineering

Computer Science

74.5-75.99 74.4 and below 3 Fail

EBK JAVA PROGRAMMING

9th Edition

ISBN:9781337671385

Author:FARRELL

Publisher:FARRELL

Chapter13: File Input And Output

Section: Chapter Questions

Problem 8PE

See similar textbooks

Similar questions

The above screen is used to browse the products table it uses the ProductDAO.java file, it calls the getProductByCriteria() function which should accept a parameter, this parameter should be the criteria that would be built from the two combo boxes and the text box, and queries the products table.The getProductByCriteria() function should return a list of Product objects that matches the criteria specified. Modify the function so that it accepts a string paramater consisting of the fields from the combo boxes and a price number from the text box separated by commas and use this string to modify the query in the function to return the desired result set. public List<Product> getProductByCriteria() //MAKE MODIFICATIONS TO THIS FUNCTION SO IT CAN TAKE PARAMETER(S) { if (openConnection()) { try{ List<Product> items = new ArrayList <> (); Product temp = null; String…
5.9 LAB - Database programming with Java (SQLite) Complete the Java program to create a Horse table, insert one row, and display the row. The main program calls four methods: createConnection() creates a connection to the database. createTable() creates the Horse table. insertHorse() inserts one row into Horse. selectAllHorses() outputs all Horse rows. Complete all four methods. Method parameters are described in the template. Do not modify the main program. The Horse table should have five columns, with the following names, data types, constraints, and values: Name Data type Constraints Value Id integer primary key, not null 1 Name text 'Babe' Breed text 'Quarter horse' Height double 15.3 BirthDate text '2015-02-10' The program output should be: All horses: (1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10') This lab uses the SQLite database rather than MySQL. Both SQLite and MySQL Connector/J implement the JDBC API. Consequently, the API is as…
5.9 LAB - Database programming with Java (SQLite) Complete the Java program to create a Horse table, insert one row, and display the row. The main program calls four methods: createConnection() creates a connection to the database. createTable() creates the Horse table. insertHorse() inserts one row into Horse. selectAllHorses() outputs all Horse rows. Complete all four methods. Method parameters are described in the template. Do not modify the main program. The Horse table should have five columns, with the following names, data types, constraints, and values: Name Data type Constraints Value Id integer primary key, not null 1 Name text 'Babe' Breed text 'Quarter horse' Height double 15.3 BirthDate text '2015-02-10' The program output should be: All horses: (1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10') This lab uses the SQLite database rather than MySQL. Both SQLite and MySQL Connector/J implement the JDBC API. Consequently, the API is as…
A python dictionary, Bank, is created to keep track of the Current Account and the Savings Account for each client in a bank. While the first item in the list is for the current account, the second item is for the savings account. The client’s name acts as the key for this dictionary.Bank = {"Apple":[100.0, 1500.0],"Bobby":[200.0, 4000.0],"Cathy":[150.0, 3500.0],"David":[300.0, 2500.0]}Write the following functions for the dictionary Bank to maintain the clients’ current and savings accounts.1. Function printBank( ): print out the contents of the dictionary Bank2. Function deposit(Name, account_type, amount): deposit the amount of money to the account specified by the account_type under the client’s name.3. Function withdraw(Name, account_type, amount): withdraw the amount of moneyfrom the account specified by the account_type under the client’s name.4. Function creatAccount(Name): create a new entry in the dictionary and initialize both the current and savings accounts to 0.0 under…
IN java YOUR TASK IS TO IMPLEMENT A JAVA APPLICATION WHICH WILL FUNCTION AS A TYPE OF STUDENT REGISTRATION DATABASE WHICH WILL ENABLE AN ADMINISTRATIVE USER TO EITHER CREATE OR DELETE A STUDENT ACCOUNT IN THE DATABASE IN ORDER TO STORE THE FOLLOWING DETAILS:- (1)THE STUDENT’S NAME, (4) THE STUDENT’S ID NUMBER, (3) A LIST OF THE COURSES WHICH THE STUDENT HAS TAKEN ALONG WITH THE CORRESPONDING GRADES FOR THESE COURSES. NOTE: WHEN THE VALUE -1 IS ENTERED, THE APPLICATION WILL TERMINATE. please check the attached image
1) Take the supplied cars_db.sql and create your Cars database (you will have to create the Cars database first, then execute the .sql file from within Netbeans). 2) Implement a program that has the same general user interface as the SimpleSchoolData presented in class. 3) Implement two classes, CarsDisplay which displays the above application, and implement a class named CarQueries that contains the prepared statements to execute the queries. (Java) This is the cars_db.sql DROP TABLE Cars; CREATE TABLE Cars ( CarID INT NOT NULL GENERATED ALWAYS AS IDENTITY, CarMake VARCHAR (10) NOT NULL, CarModel VARCHAR (15) NOT NULL, CarYear VARCHAR (4) NOT NULL, CarMileage DECIMAL (6) NOT NULL ); INSERT INTO Cars (CarMake,CarModel,CarYear,CarMileage) VALUES ('Honda','Civic','1998',135647), ('Honda','Accord','2009',46877), ('Nissan','Pickup','1997',235444);
LabProgram.java:8: error: class HorseDatabase is public, should be declared in a file named HorseDatabase.java public class HorseDatabase { ^ 1 error Complete the Java program to create a Horse table, insert one row, and display the row. The main program calls four methods: createConnection() creates a connection to the database.createTable() creates the Horse table.insertHorse() inserts one row into Horse.selectAllHorses() outputs all Horse rows.Complete all four methods. Method parameters are described in the template. Do not modify the main program. The Horse table should have five columns, with the following names, data types, constraints, and values: Name Data type Constraints ValueId integer primary key, not null 1Name text 'Babe'Breed text 'Quarter horse'Height double 15.3BirthDate text '2015-02-10'The program output should be: All horses:(1, 'Babe', 'Quarter Horse', 15.3, '2015-02-10')This lab uses the SQLite database…
Quiz 14.6: Question 2 Unlimited tries 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 does the following: Executes a SELECT statement to return all the columns from the rows where QtyOnHand is less than 10 and Cost is less than 900.00. Assigns all the results of the SELECT statement to a variable named results .
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 does the following: For every row in the Inventory table in which Cost is equal to 1599.99, set the QtyOnHand column to 22.
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 does the following: Executes a SELECT statement to return all the columns from the rows where Cost is less than 999.99. Assigns all the results of the SELECT statement to a variable named results.
Computer Science Create a simple application for an Admin in a University to manually choose courses for students. The solution would include both Frontend and a minimal Backend. You have to use react node js and mongodb Here, some of the use cases include - Return the list of students, optionally with pagination Display the list of students Upon click on the list item, display the selected courses for that specific student Also, add the option to choose some courses for that student You are free to choose the appropriate UI elements. The result should be runnable ideally via command-line.
in C# Visual Studios Windows Form App (.Net Framework) Population Database In the Chap12 folder of the Student Sample Programs, you will find a database file named PopulationDB.mdf. The database has a table named City. The City table has the following columns: (see image) The City column stores the name of a city and the Population column stores the population of that city. The database has 20 rows already entered. Create an application that connects to the PopulationDB.mdf database and allows the user to perform the following: Use data-bound controls to add new rows to the database, change existing rows, and delete rows. 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 average population of all the cities. Get the highest population. Get the lowest population.