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)...
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,...
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...
Question 18 (1 point) Number of Workers 0 1 2 3 4 5 6 Number of...
Question 18 (1 point) Number of Workers 0 1 2 3 4 5 6 Number of Windows Produced Per Day 0 15 45 1290 135 165 180 The above table shows the total number of windows a window manufacture can produce each day if it hires a certain number of workers. What is the marginal product of the 5th worker? 165 windows per day 15 windows per day 30 windows per day 45 windows per day 29 A)
Management information system Please answer the question correctly QUESTION 16 Which of the following is the...
Management information system Please answer the question correctly QUESTION 16 Which of the following is the most widely used operating system in business? Linux Mac OS Windows Unix 2.5 points QUESTION 17 Which of the following is an open-source operating system? Unisys Windows Linux Mac OS 2.5 points QUESTION 18 Which of the following storage types is volatile? RAM ROM PROM All the choices are volatile. 2.5 points QUESTION 19 Which of the following best describes the...
Question 2 (60 points): You need the Sales OrdersExample database to complete this project. To install...
Question 2 (60 points): You need the Sales OrdersExample database to complete this project. To install the database, first, download Data code 1 and run it, then download Data code 2 and run (provided on D2L). Now answer the following questions. 2.1: (20 Points) Use the customers' table inside of the salesordersexample database, and write a query statement to show records from the CustFirstName, CustLastName, and CustCity columns 2.2: (20 Points) Use the employees' table inside of the salesordersexample database,...
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...
Question 18 (1 point) Number of Workers 0 1 2 3 4 5 6 Number of Windows Produced Per Day 0 15 45 1290 135 165 180 The above table shows the total number of windows a window manufacture can produce each day if it hires a certain number of workers. What is the marginal product of the 5th worker? 165 windows per day 15 windows per day 30 windows per day 45 windows per day 29 A)
Question 2 (60 points): You need the Sales OrdersExample database to complete this project. To install the database, first, download Data code 1 and run it, then download Data code 2 and run (provided on D2L). Now answer the following questions. 2.1: (20 Points) Use the customers' table inside of the salesordersexample database, and write a query statement to show records from the CustFirstName, CustLastName, and CustCity columns 2.2: (20 Points) Use the employees' table inside of the salesordersexample database,...
Most questions answered within 3 hours.
-
Six years of quarterly data of a seasonally adjusted series are
used to estimate a linear...
asked 14 minutes ago -
Which of the following is not an ecological model used
to foster behavior change?
PRECEDE-PROCEED Model...
asked 17 minutes ago -
On the Apollo 14 mission to the moon, astronaut Alan Shepard hit
a golf ball with...
asked 13 minutes ago -
What are John’s potential claims if he is terminated
this week?
John is a 54-year-old man...
asked 27 minutes ago -
A (8.5) cm tall object is placed at a distance of (14.2) cm from
a convex...
asked 35 minutes ago -
(2) For the following questions, consider a data set that
exhibits a normal distribution. Report the...
asked 36 minutes ago -
What exactly is an information system? How does it work" What
are its people organization,
...
asked 38 minutes ago -
The Food Marketing Institute shows that 17% of households spend
more than $100 per week on...
asked 47 minutes ago -
Go to NCBI BLAST search web page
1st search: GEKDLRRAKDINQEVYNF
2nd search: PTSQRLQLLEPFDK
3rd search: GEKDLRRAKDINQEVYNF...
asked 51 minutes ago -
Explain how each of the following three conditions could be a
red flag for a register...
asked 55 minutes ago -
In a two-way factorial ANOVA, the final F-ratio for
factor AxB is determined by dividing _____...
asked 1 hour ago -
Show your solutions for answer.
4. An aqueous solution contains 9.21 g of
K4Fe(CN)6 in a...
asked 56 minutes ago