Homework Answers
1. SELECT Book_Code, Title FROM Book WHERE Type = 'HOR'
2. SELECT Book_Code, Title FROM Book WHERE Type = 'HOR' OR
Publisher_code = 'SC'
3. SELECT Book_Code, Title FROM Book WHERE Type = 'MYS' AND Price
< 20
4. SELECT Book_Code, Title, Price, (price + (price * .2)) AS
Incresed_Price FROM Book
5a. SELECT Book_Code FROM Book WHERE Type IN ('FIC', 'SFI',
'HOR')
5b. SELECT Book_Code FROM Book WHERE Type = 'FIC' OR Type = 'SFI'
OR Type = 'HOR'
6. SELECT Book_Code FROM Book WHERE NOT Publisher_Code = 'JP'
7a.SELECT Book_Code FROM Book WHERE Price BETWEEN 10 AND 20
7b.SELECT Book_Code FROM Book WHERE Price >=10 AND Price <=
20
8. SELECT Book_Code FROM Book WHERE Title LIKE %and%
9. SELECT Publisher_Code, Publisher_Name, City FROM Book ORDER BY
Publisher_Code ASC, City DESC (Given Picture of the table
does not have Publisher Name and City Column shown, I assume that
this two fields are present in the table)
10. SELECT Title, Publisher_Code, Type FROM Book WHERE Paperback =
'Y' ORDER BY Publisher_Code ASC
Add Answer to:
are Each question is worth 10 points. apply 1. List the book code and book title...
are Each question is worth 10 points. apply 1. List the book code and book title...
are Each question is worth 10 points. apply 1. List the book code and book title of each book that has the type HOR 2. List the book code and book title of each book that has the type HOR or is published by the publisher with the publisher code SC 3. List the book code and book title of each book that has the type MYS and a price of less than $20 4. List the book code, book...
Given the attached data file, write a payload class Book that represents a book. The fields...
Given the attached data file, write a payload class Book that represents a book. The fields are id, title, publisher, type, price and paperback. Most should be String fields, but price should be a double and paperback should be a boolean. The one constructor should take a Scanner parameter opened to the file. It should input each of the fields using the Scanner. Note that for the paperback field, you should input a String, and set the field to true...
How would you use this stored procedure to change the price of any copy of book 0180 whose format...
How would you use this stored procedure to change the price of any copy of book 0180 whose format is paperback to $10.95? using MYSQL 8.0 Command line Client This is the database script for the homework above CREATE DATABASE HENRY; USE HENRY; CREATE TABLE AUTHOR (AUTHOR_NUM DECIMAL(2,0) PRIMARY KEY, AUTHOR_LAST CHAR(12), AUTHOR_FIRST CHAR(10) ); CREATE TABLE BOOK (BOOK_CODE CHAR(4) PRIMARY KEY, TITLE CHAR(40), PUBLISHER_CODE CHAR(3), TYPE CHAR(3), PRICE DECIMAL(4,2), PAPERBACK CHAR(1) ); CREATE TABLE BRANCH (BRANCH_NUM DECIMAL(2,0) PRIMARY KEY,...
MYSQL: Question: 1.Using a function, what are the lowest price books found in paperback? Only return...
MYSQL: Question: 1.Using a function, what are the lowest price books found in paperback? Only return the lowest price books. Display the book code as ‘Book Code’, the book title as ‘Title’, author name concatenated (first last) as ‘Author Name’ and price as ‘Price’. Insert your snip of the query and resultset together here. 2. Display the number of publishers by city. Display the city as ‘City’ and the number of publishers in that city as ‘Number of Publishers’. Insert...
MYSQL Questions: 1.For every author, display the number of books written by that author that is...
MYSQL Questions: 1.For every author, display the number of books written by that author that is carried by Henry Books. Display the author number as ‘Author Number’, author name concatenated (first last) as ‘Author Name’, and the total number of books written by the author as ‘Number of Titles by Author’. List in descending order by author number. Limit the output to 10 rows. Insert your snip of the query and resultset together here. 2.Using a function, what are the...
Consider the following relation for published books: BOOK(Book title, Author_name, Book type, List price, Author affil,...
Consider the following relation for published books: BOOK(Book title, Author_name, Book type, List price, Author affil, Publisher) Author_affil refers to the affiliation of author. Suppose the following dependencies exist: Book title Publisher, Book type Book type List price Author_name > Author affil (a) What normal form is the Book relation in? Why? (b) Decompose Book into 2NF relations. . (c) Decompose Book into 3NF relations.
Problem 4 (DOM operations - 30 points): Consider the Python code snippet bookstore.py for DOM operation,...
Problem 4 (DOM operations - 30 points): Consider the Python code snippet bookstore.py for DOM operation, some basic methods and properties and an xml file on bookstore which we discussed this week. Wite two func- tions; First, write a recursive Python function get_text(elm) to extract all the text of a dom tree pointed by elm. For example, get_text(elm), where elm=<bookstore>, will return [[u'Emacs User Manual', u'Richard Stallman', u'1980', u'12.00'], [u'Timeline', u'Michael Chricton', u'1999', u'15.00'], [u'Catch 22', u'Joseph Heller', u'1961', u'20.00'],...
This assignment consists of a series of SQL questions. For each question, you will need to...
This assignment consists of a series of SQL questions. For each
question, you will need to include:
• SQL query.
• An explanation of the query. Please include explanations as a
comment AFTER your query, e.g., enclosed within a /* comments block
*/ ). See the first example in the SQL tutorial for a comment. You
don’t need to explain straightforward code in comments. Only the
parts that are interesting or different, so that we understand what
you did.
Question-1...
are Each question is worth 10 points. apply 1. List the book code and book title of each book that has the type HOR 2. List the book code and book title of each book that has the type HOR or is published by the publisher with the publisher code SC 3. List the book code and book title of each book that has the type MYS and a price of less than $20 4. List the book code, book...
Consider the following relation for published books: BOOK(Book title, Author_name, Book type, List price, Author affil, Publisher) Author_affil refers to the affiliation of author. Suppose the following dependencies exist: Book title Publisher, Book type Book type List price Author_name > Author affil (a) What normal form is the Book relation in? Why? (b) Decompose Book into 2NF relations. . (c) Decompose Book into 3NF relations.
Problem 4 (DOM operations - 30 points): Consider the Python code snippet bookstore.py for DOM operation, some basic methods and properties and an xml file on bookstore which we discussed this week. Wite two func- tions; First, write a recursive Python function get_text(elm) to extract all the text of a dom tree pointed by elm. For example, get_text(elm), where elm=<bookstore>, will return [[u'Emacs User Manual', u'Richard Stallman', u'1980', u'12.00'], [u'Timeline', u'Michael Chricton', u'1999', u'15.00'], [u'Catch 22', u'Joseph Heller', u'1961', u'20.00'],...
This assignment consists of a series of SQL questions. For each
question, you will need to include:
• SQL query.
• An explanation of the query. Please include explanations as a
comment AFTER your query, e.g., enclosed within a /* comments block
*/ ). See the first example in the SQL tutorial for a comment. You
don’t need to explain straightforward code in comments. Only the
parts that are interesting or different, so that we understand what
you did.
Question-1...
Most questions answered within 3 hours.
-
A 13-year bond with a face value of 1500 dollars is redeemable
at twice par, and...
asked 7 minutes ago -
Topdog is a toy company, whose profits/sales percentage is 13%
in 2015, 16% in 2016 and...
asked 6 minutes ago -
A sag curve and crest curve connect a –3.5% tangent section of
highway (to the west)...
asked 4 minutes ago -
What is the Nernst (equilibrium) potential of a monovalent
cation (+ valence) at 37oC given the...
asked 14 minutes ago -
Ryan wants to accumulate at least $55,000 by depositing $1,800
at the end of every month...
asked 18 minutes ago -
Compressed air can be pumped underground into huge caverns as a
form of energy storage. The...
asked 26 minutes ago -
Scores on the first half of a 60-item
test are correlated with scores on the second...
asked 48 minutes ago -
Find the quantile function F^(-1)(p) (if one exists) of F(x) =
{0 for x<= 0, (1/9)x^2...
asked 50 minutes ago -
Why do practitioners continue to prefer unstructured and
intuition based approaches to employee selection?
asked 50 minutes ago -
1.
a.) What is the molar solublitlity of PbBr2 in pure water? Ksp
of PbBr2=4.67*10^-6
b.)...
asked 1 hour ago -
A NaCl crystal has a mass of 0.15mg. how many moles of
Na^+ are present in...
asked 1 hour ago -
What is the final volume in milliliters when 0.854 L of a 37.6 %
(m/v) solution...
asked 1 hour ago