4. Write two queries to list the ID of all the authors that do not haveanybooks.a) Using a join:b) Using a subquery: mysql> DESC bookauthor;mysql> DESC author;mysql> DESC book;| Field| Туре| Field| Туре| FieldТур| int(11| varchaiauthor_order | int(11royaltyshare | decima:author_idisbn| author_id | int(1:| ssnlastname| firstname | varch:| phone| address| city| state| zip| varch:| varch:isbnvarI name| typepub_idI price| advanceI ytd_salesI pubdatevarvar| varch:| varch:| varch:| varch:| varch:| intdec| decintmysql> DESC bookeditor;| dat| Field| Туреmysql> DESC editor;mysql> DESC publisher;editor_id | int(11)| varchar(1| Fieldisbn| Field| Туреeditor_idssnpub_id | int(11)| varchar(40)varchar(40)varchar(20)varchar(2)lastnamenamefirstnameaddress| phoneeditor_positionsalary| citystate

The requirement is to fetch the author_id from author table for the records where there is no…

Answered: 4. Write two queries to list the ID of…

4. Write two queries to list the ID of all the authors that do not have any books. a) Using a join: b) Using a subquery:

EBK JAVA PROGRAMMING

9th Edition

ISBN:9781337671385

Author:FARRELL

Publisher:FARRELL

Chapter8: Arrays

Section: Chapter Questions

Problem 7PE

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…
Simple Student Management System Build the following app using Python Tkinter library. Using this app, user can • add student information • view all students • search student(s) by name • remove student by id Add • First name, last name, date of birth cannot be blank while adding a specific student information. • However major can be blank, which gets set to "Undefined" if left out blank. • Student Id is automatically generated by the program (ex: 1001, 1002, 1003, 1004 ….) If the user keeps a mandatory field blank (ex: First name) and presses "Add Student" button, it displays the following message box: first name is required If the user successfully enters all the necessary information and presses the "Add Student" button, it displays the following confirmation message box: student added View All When the user presses the "View All" button, it displays all the student’s information (Id, First name, Last name, Date of birth, and Major) in a nice formatted way. Example below: • Must…
create a program called automobile loan this program stores a loan number, make and model of automobiles, and the loan balance. include the methods to set values for each data field and a methods that display all the loan information create two automobileloan objects and sets and display their values. create another two automobileloan objects and ask the user for the values, then display those values. you should have four objects in total created.
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);
Student – with no parameters, initialize all the data members to 0 or null. Data Members studentNo – int fname – String lname – String course – String Method Members setStudentNo – to set the student number of the student setFname – to set the firstname of the student setLname – to set the lastname of the student setCourse – to set the course of the student getStudentNo – to get the student number of the student getFname – to get the firstname of the student getLname – to get the lastname of the student getCourse – to get the course of the student
Create an application to keep track of a list of students and their grades in a data structures course using a linked list. You should use the C++ STL library. You need to create a class called student that contains 2 data members: name and grade and then create a linked list of objects of this class. The application should allow the user to add a student, remove a student, update the grade for a student, and search for a student. The class should have a constructor with two parameters with only the grade as optional. Remember, a user must provide the student's name in order to create an object of that class. Add validation code for the grade to make sure the grade is only A-F or '?' (grade is unknown or course is still in progress). Put all validation code in one function. Avoid redundancy. Overload the equality operator (==) -- use the string class member function compare to compare strings. Two objects of the student class are equal if the students' names are equal. Make…
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…
Build a list of contacts for New Jersey manufacturers as follows: ContactFirstName, ContactLastName, Phone. HINT: To do this you will need to split the contact name into two columns. You will need to embed string functions within string functions. It may be helpful to use Substring and Charindex. For last name, you can use a literal of 20 characters as the length to ensure you pick up all the characters to the end of the field.)
inal Project In this project, you will be asked to implement a simple Java program that will maintain its data using a specific NoSQL database called MongoDB. In this program you will be asked to maintain an object called Product, each product will have the following attributes: + Product ID. + Product Name. + Product Description. + Product Price. You will be asked to implement two types of products. « Dimensional Products. * Weighted Products. For the products of type Dimensional, they will have two extra values that express the width and the length of the product stored. For the products of type Weighted, they will have one extra value that express the weight of the product stored. When the program runs, the following choices appear. 1- Show all Products. 2- Add Product. 3- Delete Product. 4- Update Product. 5- Replace Product. 6- Search Product. 7-Bxit. Enter your choice: Notes: 1- When the program starts, it should connect automatically to a Database that is called “DBCourse” and a…
(Querying an Array of Invoice Objects) Use the class Invoice provided in the lab assignment to create an array of Invoice objects.Class Invoice includes four properties—a PartNumber (type int), a PartDescription (type string), a Quantity of the item being purchased (type int) and a Price (type decimal).Write a console application that performs the following queries on the array of Invoice objects and displays the results:a) Use LINQ to sort the Invoice objects by PartDescription.b) Use LINQ to sort the Invoice objects by Price.c) Use LINQ to select the PartDescription and Quantity and sort the results by Quantity.d) Use LINQ to select from each Invoice the PartDescription and the value of the Invoice(i.e., Quantity * Price). Name the calculated column InvoiceTotal. Order the results by Invoice value. [Hint: Use let to store the result of Quantity * Price in a new range variable total.]e) Using the results of the LINQ query in Part d, select the InvoiceTotals in the range$200 to…
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
Which type of relationship is depicted in the following code? class Student { public: string name; int age; int grade;};class Teacher { public: string name; int experience; string forGrades;};class School { vector<Student> students; vector<Teacher> teachers;}; 1)Of-a 2)Has-a 3)Is-a 4)Kind-of