Chapter 6, Problem 7HOA

//Need typed version please in text not image You are working with a database that stores information about suppliers, parts and projects. The Supply relation records instances of a Supplier supplying a Part for a Project. The schema for the database used in this question is as follows: ( primary keys are shown underlined, foreign keys in bold). SUPPLIER (SNo, SupplierName, City) PART (PNo, PartName, Weight) PROJECT (JobNo, JobName, StartYear, Country) SUPPLY (SNo, PNo, JobNo, Quantity) Provide relational algebra (NOT SQL) queries to find the following information. NOTE: You can use the symbols s, P, etc or the words ‘PROJECT’, ‘RESTRICT’ etc .  do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition.   List the name of any part that was not used on a project that commenced in 2020. List the name of any part that has been supplied to all projects that commenced in 2020.

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…

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. 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.…

Create an application that connects to the Personnel.mdf database that you created in Programming Problem 1. The application’s form should display the Employee table in a DataGridView control. The form should also have the following controls: • A button that, when clicked, sorts the data in ascending order by hourly pay rate. • A button that, when clicked, sorts the data in descending order by hourly pay rate.

using 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.

Is it possible to control the integrity of a field by selecting a certain data type?

{              String str = tf5.getInt("ID");              Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");              Connection con = DriverManager.getConnection("jdbc:sqlserver://NOMBUSO1806:1433;databaseName= Employee ATM", "NOMBUSO1806", "mysql1234");      // write your database username and password            PreparedStatement st = con.prepareStatement("select * from Employees where ID=?");  // Search with ATM ID            st.setString(1, str);                           ResultSet rs = st.executeQuery();   // Excuting Query             if (rs.next()) {                  String s = rs.getString(1);                  String s1 = rs.getString(2);                  String s2 = rs.getString(3);                           // Sets Records in TextFields.                  tf1.setText(s);                  tf2.setText(s1);                  tf3.setText(s2);     my getInt() is throwing an error that the method is not found. what should i do?

Parent row is a row where there is a ?     Primary key     Foreign key     non-null field     null field