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.
It will only display iPhone and android models
SO, OPTION C IS CORRECT
Kindly revert for any queries
Thanks.
Add Answer to:
Question 18 (1 point) Use the following information to answer question 18 to 20. Suppose there...
Question 19 (1 point) 19. Which statement can help us to find out which phone has...
Question 19 (1 point) 19. Which statement can help us to find out which phone has never been ordered by customers? a. select Products.ProdName, Orders.Quantity from Products left outer join Orders on Products.ProdID=Orders.ProdID where Orders. Quantity is null; b. select Products.ProdName, Orders.Quantity from Products right outer join Orders on Products ProdID=Orders.ProdID where Orders. Quantity is null: c. select Products ProdName, Orders. Quantity from Products inner join Orders on Products. ProdID=Orders.ProdID where Orders.Quantity is null; d. select Products. ProdName, Orders.Quantity from...
MYSQL DATABASE: 1) Use an OUTER JOIN to join the Products and OrderItems tables, returning a...
MYSQL DATABASE: 1) Use an OUTER JOIN to join the Products and OrderItems tables, returning a sorted list of product names (prod_name) and the order numbers (order_num) associated with each. 2) Modify number 1 statement so that it returns a total of number of orders for each item ( as opposed to the order numbers). products table: Columns: prod_id char(10) PK vend_id char(10) prod_name char(255) prod_price decimal(8,2) prod_desc text orderItems table: Columns: order_num int(11) PK order_item int(11) PK prod_id char(10)...
QUESTION 5 Suppose there are two tables: A and B. and we run command SELECT *...
QUESTION 5 Suppose there are two tables: A and B. and we run command SELECT * from A LEFT JOIN B on A.orderid = B.orderid. What would be the code output? only the records from table A where tables A and B have the same orderid only the records from table B where tables A and B have the same orderid the complete set of records from table A, along with the matching records (depending on the availability) from table...
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...
can you answer part e of the question Q.31 Answer the following questions (a) Explain difference between lossy decomposition and lossless decomposition (b) If you write a SQL statement to inner jo...
can you answer part e of the question
Q.31 Answer the following questions (a) Explain difference between lossy decomposition and lossless decomposition (b) If you write a SQL statement to inner join the following two tables based on Plocation value as inner join condition, is the result table lossy or lossless? (Explain why?) EMP LOCS P.K EMP PROJ1 Hours Pname Plocation Р.К. (c) Given a relation schema R ={SSN, Ename, Pnumber, Pname, Plocation, Hours) R is decomposed to R1, R2,...
NEED THE SQL QUERIES ASAP PLEASE(LIKE 1 HOUR) THE ONES WITH ID ARE PRIMARY KEYS OR...
NEED THE SQL QUERIES ASAP PLEASE(LIKE 1 HOUR) THE ONES WITH ID ARE PRIMARY KEYS OR FOREIGN etc Customer [ CustID, LastName, FirstName, Address, City, State, Zip, Phone, Fax, Email] Product [ ProdID, Description, Color, Size, Pack] Sales [ TransID, CustID, ProdID, Price, Quantity, Amount] Write SQL statement to produce a list of unique products and their prices from the Sales table. Please ensure that the products do not repeat. Write an SQL statement to list ProdID and Description for...
Question 18 (1 point) Use the following information to answer 16-20. An 8-year, 10 percent semiannual...
Question 18 (1 point) Use the following information to answer 16-20. An 8-year, 10 percent semiannual coupon bond, with a par value of $1,000, may be called in 3 years at a call price of $1,040. The bond sells for $1,060. What is the bond's capital gain or loss yield? 0.4% -0.3% 0-0.5% 0.51%
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...
I need to use SQL in microsoft access to deal with those problems. Have no ideal...
I need to use SQL in microsoft access to deal with those problems. Have no ideal on how to edit the code. Here is the requirement. Database Design and Relationships 1. Create Primary Key(s) as appropriate for all tables. In TIMESHEETS, employees can only log time to a given WORKCODE once per day (e.g., if someone works on R&D for 2 hours in the morning and 2 hours in the afternoon, it's entered on the timesheet as 4 hours for...
CUSTTYPE (TID, TypeDesc) CUSTOMER (CID, Lname, Fname, TID, Address, ZIPcode) CUSTORDER (OrderNo, OrderDate, PromiseDate, ShippedDate, ShippingTerm,...
CUSTTYPE (TID, TypeDesc) CUSTOMER (CID, Lname, Fname, TID, Address, ZIPcode) CUSTORDER (OrderNo, OrderDate, PromiseDate, ShippedDate, ShippingTerm, SalesID, CID) SALESREP (SalesID, Name, Phone, Address, ZIPcode, RepType) ORDERLINE (OrderNo, PID, Qty, Qty_RETD) FTSALESREP (SalesID, MonthPay, Rank) PTSALESREP (SalesID, HourlyRate, WeekHours) ZIP_TABLE (ZIPcode, City, State) VENDOR (VID, Name, Phone ZIPcode) PRODUCT (PID, CateID, ProdName, ProdFinish, Price, Qty_on_Hand, Description, VID) CATEGORY (CateID, CateType) Local View #1: Use three base tables to develop a SQL statement that will list the following information for a customer,...
Question 19 (1 point) 19. Which statement can help us to find out which phone has never been ordered by customers? a. select Products.ProdName, Orders.Quantity from Products left outer join Orders on Products.ProdID=Orders.ProdID where Orders. Quantity is null; b. select Products.ProdName, Orders.Quantity from Products right outer join Orders on Products ProdID=Orders.ProdID where Orders. Quantity is null: c. select Products ProdName, Orders. Quantity from Products inner join Orders on Products. ProdID=Orders.ProdID where Orders.Quantity is null; d. select Products. ProdName, Orders.Quantity from...
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...
can you answer part e of the question
Q.31 Answer the following questions (a) Explain difference between lossy decomposition and lossless decomposition (b) If you write a SQL statement to inner join the following two tables based on Plocation value as inner join condition, is the result table lossy or lossless? (Explain why?) EMP LOCS P.K EMP PROJ1 Hours Pname Plocation Р.К. (c) Given a relation schema R ={SSN, Ename, Pnumber, Pname, Plocation, Hours) R is decomposed to R1, R2,...
Question 18 (1 point) Use the following information to answer 16-20. An 8-year, 10 percent semiannual coupon bond, with a par value of $1,000, may be called in 3 years at a call price of $1,040. The bond sells for $1,060. What is the bond's capital gain or loss yield? 0.4% -0.3% 0-0.5% 0.51%
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...
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