Given the following schema books(id,title,pub_year,pages,isbn), what is the SQL statement needed to find all the books...
Given the following schema books(id,title,pub_year,pages,isbn), what is the SQL statement needed to find all the books published in the year 2002?
a)SELECT pub_year = 2002 in books;
b) SELECT ALL in books WHERE pub_year = 2002;
C) SELECT * FROM books WHERE (pub_year,2002);
D) SELECT * FROM books WHERE pub_year = 2002;
Homework Answers
Answer: -------- D) SELECT * FROM books WHERE pub_year = 2002; Explanation: ------------ SELECT * -> get all the information FROM books -> about books WHERE pub_year = 2002 -> which are published in 2002
Add Answer to:
Given the following schema books(id,title,pub_year,pages,isbn),
what is the SQL statement needed to find all the books...
Do these codes look right for the following 5 statements. This is using Oracle SQL: Write...
Do these codes look right for the following 5 statements. This is using Oracle SQL: Write a query that displays the title, ISBN, and wholesale cost of books whose wholesale cost is more than the average of all books. Format the retail price with dollars and cents. Write a query that displays the title and publication date of the oldest book in the BOOKS table. Format the date with the complete name of the month and a comma after the...
Consider the following relations for course-enrollment database in a university: STUDENT(S-ID,S-Name, Department, Birth-date) COURSE(C-ID, C-Name, Department)...
Consider the following relations for course-enrollment database in a university: STUDENT(S-ID,S-Name, Department, Birth-date) COURSE(C-ID, C-Name, Department) ENROLL(S-ID, C-ID, Grade) TEXTBOOK(B-ISBN, B-Title, Publisher, Author) BOOK-ADOPTION(C-ID, B-ISBN) (a) Draw the database relational schema and show the primary keys and referential integrity constraints on the schema. (b) How many superkeys does the relation TEXTBOOK have? List ALL of them. (c) Now assume each COURSE has distinct C-Name. (i) If C-ID is a primary key, what are the candidate keys and the unique keys...
what sql statements does the following from a table like this? ex 2.4 course Id Name...
what sql statements does the following from a table like this?
ex 2.4
course Id Name semester semester Grade 2.4 OL Jenent at creates the TRANSCRIPT table. Using the TRANSCRIPT table, write an SQL statement that a. Deregisters the student with Id - 123456789 from the course CS305 for the fall of 2001 b. Changes to an A the grade assigned to the student with Id - 123456789 for the course CS305 taken in the fall of 2000 C. Returns...
Given the following table structure, write the SQL code to display all the first and last...
Given the following table structure, write the SQL code to display all the first and last names of the individuals that have a last name that begins with the letter 'M! CREATE TABLE Persons Personi int LastName varchar(80). FirstName varchar(80). Address varchar(125). State char(2) Given the following table structure, write the SQL code to display all the first and last names of the individuals that have a last name that does not contain the letter 'S: CREATE TABLE Persons PersonlDint,...
For all problems, use the following schema: Musician(id, first_name, last_name, instrument, band_id) Band(id, name, years_together) Show(id,...
For all problems, use the following schema: Musician(id, first_name, last_name, instrument, band_id) Band(id, name, years_together) Show(id, venue_id, date) Played_in(band_id, show_id) Venue(id, name, address) Album(id, name, year, band_id, genre_id) Genre(id, name, description) Song(id, name, album_id) Primary keys are in bold, foreign keys are in italics. For each problem, write a query once using relational algebra, and again using SQL. 12. Find the names of all bands that have a member who plays "Guitar", OR have a member that plays "Keyboard". 13....
Database Management ID Price 1 Author Richie Karen 10 2 4 Year 1955 1958 1959 Title...
Database Management
ID Price 1 Author Richie Karen 10 2 4 Year 1955 1958 1959 Title с JAVA Script Java C++ prolog Perl 20 10 5 6 Schwartz Ross Maria 1959 1972 20 10 7 Wall 1987 20 The above relation has information about different books. The table information is already saved as txt format in Moodle under the name Quiz2Data.txt. Using MySql on your computer do: Create a database Create a table with name book, then load Quiz2Data.txt (check...
Please refer to the following business scenarios: (i) Using SELECT statements of SQL, find the employee...
Please refer to the following business scenarios:
(i) Using SELECT statements of SQL, find the employee id, first
name, last name, job title and email of all employees working in
Asia (i.e. all countries coming from the region
‘Asia’). This query must be implemented
as a nested query!
(ii) Using SELECT statements of SQL, find the employee id, first
name, last name, job title and supervisor id of employees who had
worked for more than 3 years and completed...
Specify relational calculus expression for the following descriptions on the Library database schema shown in Figure...
Specify relational calculus expression for the following
descriptions on the Library database schema shown in Figure
4.6.
a) Retrieve Publishers’ name and phone number whose books where
borrowed from Baltimore Branch.
b) List the book title, book id and branch name with less than
10 copies
c) List customer card number, customer name, branch name and
book title for books which are currently on loan.
BOOK Book id Title Publisher_name BOOK_AUTHORS Book idAuthor name PUBLISHER Name Address Phone BOOK COPIES...
Which of the following queries contains a non-equality join? a. SELECT title, authorid FROM books, bookauthor...
Which of the following queries contains a non-equality join? a. SELECT title, authorid FROM books, bookauthor WHERE books.isbn = bookauthor.isbn AND retail > 20; b. SELECT title, name FROM books JOIN publisher USING (pubid); c. SELECT title, gift FROM books, promotion WHERE retail >= minretail AND retail <= maxretail; d. none of the above
what sql statements does the following from a table like this?
ex 2.4
course Id Name semester semester Grade 2.4 OL Jenent at creates the TRANSCRIPT table. Using the TRANSCRIPT table, write an SQL statement that a. Deregisters the student with Id - 123456789 from the course CS305 for the fall of 2001 b. Changes to an A the grade assigned to the student with Id - 123456789 for the course CS305 taken in the fall of 2000 C. Returns...
Given the following table structure, write the SQL code to display all the first and last names of the individuals that have a last name that begins with the letter 'M! CREATE TABLE Persons Personi int LastName varchar(80). FirstName varchar(80). Address varchar(125). State char(2) Given the following table structure, write the SQL code to display all the first and last names of the individuals that have a last name that does not contain the letter 'S: CREATE TABLE Persons PersonlDint,...
Database Management
ID Price 1 Author Richie Karen 10 2 4 Year 1955 1958 1959 Title с JAVA Script Java C++ prolog Perl 20 10 5 6 Schwartz Ross Maria 1959 1972 20 10 7 Wall 1987 20 The above relation has information about different books. The table information is already saved as txt format in Moodle under the name Quiz2Data.txt. Using MySql on your computer do: Create a database Create a table with name book, then load Quiz2Data.txt (check...
Please refer to the following business scenarios:
(i) Using SELECT statements of SQL, find the employee id, first
name, last name, job title and email of all employees working in
Asia (i.e. all countries coming from the region
‘Asia’). This query must be implemented
as a nested query!
(ii) Using SELECT statements of SQL, find the employee id, first
name, last name, job title and supervisor id of employees who had
worked for more than 3 years and completed...
Specify relational calculus expression for the following
descriptions on the Library database schema shown in Figure
4.6.
a) Retrieve Publishers’ name and phone number whose books where
borrowed from Baltimore Branch.
b) List the book title, book id and branch name with less than
10 copies
c) List customer card number, customer name, branch name and
book title for books which are currently on loan.
BOOK Book id Title Publisher_name BOOK_AUTHORS Book idAuthor name PUBLISHER Name Address Phone BOOK COPIES...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago