Homework Answers
`Hey,
Note: If you have any queries related to the answer please do comment. I would be very happy to resolve all your queries.
19) OPTION B IS CORRECT
20) OPTION D IS CORRECT
Kindly revert for any queries
Thanks.
Add Answer to:
Question 19 (1 point) 19. Which statement can help us to find out which phone has...
Question 18 (1 point) Use the following information to answer question 18 to 20. Suppose there...
Question 18 (1 point) Use the following information to answer question 18 to 20. Suppose there are two tables in a database for an e-commerce website. One table is called Products. The other one is called Orders. Their structures and data records are showed below: Products Table Orders Table ProdID Ordid ProdID Quantity 1 ProdName iPhone Android 1 1 2 2 1 1 3 Windows 3 2 2 4 4 1 18. If we have the following statement: select Products....
Below is the database schema for a company. Primary keys are underlined. Customers (CustomerID, CompanyName, Phone,...
Below is the database schema for a company. Primary keys are underlined. Customers (CustomerID, CompanyName, Phone, BalanceDue) Oders (Orderid, orderdate, customerid, freightamount) Orderdetails (oderid, productid, qtyordered, price) Products (productid, productname, qtyinstock, suggestedprice, minstocklevel) Given this SQL statement: Select * From Customers Inner Join Orders on Orders.CustomerID=Customers.CustomerID Where Orders.CustomerID is Null; Which of the following statement is correct? It is a SQL select statement that will list the ProductName for all products where the Qtyinstock is less than the total QtyOrdered...
Question 11 (1 point) 11. Which of the following is a request that can be answered...
Question 11 (1 point) 11. Which of the following is a request that can be answered using an OUTER JOIN? a. Show me customers and employees who have the same name. b. Find the bowlers who live in the same ZIP code c. What products have never been ordered? d. Show me the students and their teachers who have the same first name. Question 12 (1 point) 12. What keyword is used to provide a name for an expression in...
#6 Write a SELECT statement that returns these columns: The count of the number of orders...
#6 Write a SELECT statement that returns these columns: The count of the number of orders in the Orders table The sum of the tax_amount columns in the Orders table Write a SELECT statement that returns one row for each category that has products with these columns: The category_name column from the Categories table The count of the products in the Products table The list price of the most expensive product in the Products table Sort the result set so...
You will develop an E-Commerce database used to maintain customers, products and sales information. You are...
You will develop an E-Commerce database used to maintain
customers, products and sales information. You are required to 1)
gather and analyze requirements 2) design logical structure of the
database 3) create stored procedures to develop the tables and
insert the data 4) write SQL statements for data extraction and
reporting.
Throughout the course of this semester you have analyzed the
requirements for an eCommerce database, designed and developed your
database. As a class we have gone through the process...
Question 19 Not yet answered Points out of 7.00 p Flag question A hollow cylindrical conductor...
Question 19 Not yet answered Points out of 7.00 p Flag question A hollow cylindrical conductor of inner radius a = 9 cm, and outer radius b = 22.5 has a non- uniform current density J = r2 in units of A/m². a . . (a) Calculate the magnetic field at distance r = 13.5 cm from the center of the conductor. Select one: • a. 501.03 E-ZT . b. 219.45 E-ZT . c. 13640.60 E-7 T Question 20 Not...
Question 18 (1 point) Use the Staff table, as shown below, to answer question 18 to...
Question 18 (1 point) Use the Staff table, as shown below, to answer question 18 to 20. StfID StfFName StfLName 1011 Eric Smith 65000 1012 Ann Jordan 70000 1013 Linda Greenberg 63000 1014 Jose Hernandez 56000 1015 Lee Jones 77000 18. Which statement regarding the SQL query below is correct? (Reminder: The table name is Staff) select StfFName, Salary, (0.05* Salary) as HolidayBonus from Staff where StID=1012; A) The report will have a column named StfID, and 1012 will be...
Question 1 (5 marks) Consider two relations called Item and Orderltem. Imagine that relation Item has 160,000 tuples and Orderltem has 200,000 tuples. Both relations store 100 tuples per a page....
Question 1 (5 marks) Consider two relations called Item and Orderltem. Imagine that relation Item has 160,000 tuples and Orderltem has 200,000 tuples. Both relations store 100 tuples per a page. Consider the following SQL statement SELECT * FROM Item INNER JOIN OrderItem ON Item.ItemID-OrderItem. ItemID; We wish to evaluate an equijoin between Orderltem and Item, with an equality condition Item.ltemID Orderltem.ItemID. There are 802 buffer pages available in memory for this operation. Both relations are stored as (unsorted) heap...
Please help me on the SQL queries, thank you so much. Write a query to display the title and publisher as well as the p...
Please help me on the SQL
queries, thank you so much.
Write a query to display the
title and publisher as well as the publisher contact for each book
using JOIN...USING clause.
Write a query to show the
first and last names of customers who have ordered cooking books.
Use the WHERE clause to join the tables.
Write a query to show the
title, cost and ISBN of each book in the books table. If the book
has been ordered,...
Question 9 (1 point) Which choice below describes the function of the following SQL statement? SELECT...
Question 9 (1 point) Which choice below describes the function of the following SQL statement? SELECT ID, Last Name, First Name, Address FROM Members WHERE Last Name Last Name a simple query a parameterized query a compound query a wildcard query Question 10 (1 point) The correct SQL syntax to sort a table by Last Name in order of A-Z is SORT BY Last Name ASCENDING ORDER BY Last Name Down ORDER BY Last Name ASC ORDER BY Last Name...
Question 18 (1 point) Use the following information to answer question 18 to 20. Suppose there are two tables in a database for an e-commerce website. One table is called Products. The other one is called Orders. Their structures and data records are showed below: Products Table Orders Table ProdID Ordid ProdID Quantity 1 ProdName iPhone Android 1 1 2 2 1 1 3 Windows 3 2 2 4 4 1 18. If we have the following statement: select Products....
Question 11 (1 point) 11. Which of the following is a request that can be answered using an OUTER JOIN? a. Show me customers and employees who have the same name. b. Find the bowlers who live in the same ZIP code c. What products have never been ordered? d. Show me the students and their teachers who have the same first name. Question 12 (1 point) 12. What keyword is used to provide a name for an expression in...
You will develop an E-Commerce database used to maintain
customers, products and sales information. You are required to 1)
gather and analyze requirements 2) design logical structure of the
database 3) create stored procedures to develop the tables and
insert the data 4) write SQL statements for data extraction and
reporting.
Throughout the course of this semester you have analyzed the
requirements for an eCommerce database, designed and developed your
database. As a class we have gone through the process...
Question 19 Not yet answered Points out of 7.00 p Flag question A hollow cylindrical conductor of inner radius a = 9 cm, and outer radius b = 22.5 has a non- uniform current density J = r2 in units of A/m². a . . (a) Calculate the magnetic field at distance r = 13.5 cm from the center of the conductor. Select one: • a. 501.03 E-ZT . b. 219.45 E-ZT . c. 13640.60 E-7 T Question 20 Not...
Question 18 (1 point) Use the Staff table, as shown below, to answer question 18 to 20. StfID StfFName StfLName 1011 Eric Smith 65000 1012 Ann Jordan 70000 1013 Linda Greenberg 63000 1014 Jose Hernandez 56000 1015 Lee Jones 77000 18. Which statement regarding the SQL query below is correct? (Reminder: The table name is Staff) select StfFName, Salary, (0.05* Salary) as HolidayBonus from Staff where StID=1012; A) The report will have a column named StfID, and 1012 will be...
Question 1 (5 marks) Consider two relations called Item and Orderltem. Imagine that relation Item has 160,000 tuples and Orderltem has 200,000 tuples. Both relations store 100 tuples per a page. Consider the following SQL statement SELECT * FROM Item INNER JOIN OrderItem ON Item.ItemID-OrderItem. ItemID; We wish to evaluate an equijoin between Orderltem and Item, with an equality condition Item.ltemID Orderltem.ItemID. There are 802 buffer pages available in memory for this operation. Both relations are stored as (unsorted) heap...
Please help me on the SQL
queries, thank you so much.
Write a query to display the
title and publisher as well as the publisher contact for each book
using JOIN...USING clause.
Write a query to show the
first and last names of customers who have ordered cooking books.
Use the WHERE clause to join the tables.
Write a query to show the
title, cost and ISBN of each book in the books table. If the book
has been ordered,...
Question 9 (1 point) Which choice below describes the function of the following SQL statement? SELECT ID, Last Name, First Name, Address FROM Members WHERE Last Name Last Name a simple query a parameterized query a compound query a wildcard query Question 10 (1 point) The correct SQL syntax to sort a table by Last Name in order of A-Z is SORT BY Last Name ASCENDING ORDER BY Last Name Down ORDER BY Last Name ASC ORDER BY Last Name...
Most questions answered within 3 hours.
-
Beginning Retained Earnings are $ 79 comma 000 $79,000; sales
are $ 31 comma 700 $31,700;...
asked 28 seconds from now -
Please explain/demonstrate how to use NLTK to test unigram,
bigram, and trigram character models on guessing...
asked 5 minutes ago -
what you feel is most important to you and why regarding your
typing skills?
asked 6 minutes ago -
Consider a play of the casino game `Quick Draw'. In this game, a
player pays $11...
asked 16 minutes ago -
How do the mechanical features of bone affect its roles as
repositories of phosphate and calcium,...
asked 20 minutes ago -
P agreed to buy 100 barrels of widget oil, which was stored in a
large tank...
asked 20 minutes ago -
The unstable isotope 40K is used for dating rock samples. Its
half-life is 1.28×109y. How many...
asked 23 minutes ago -
Compare and contrast constructed-response items and
selected-response items.
Identify at least one (1) advantage and one...
asked 25 minutes ago -
A) Find the moment of inertia of a 2 meter long stick with a
mass of...
asked 23 minutes ago -
For the code below write a public static main() method
in class Student that:
- creates...
asked 26 minutes ago -
Please show all steps. Thank you
A 1.0-cm-diameter pipe widens to 2.0 cm, then narrows to...
asked 38 minutes ago -
The equilibrium constant for the following reaction Ag+(aq) +
2NH3(aq) Ag(NH3)2+(aq) is K = 1.7 ×...
asked 47 minutes ago