1 answer

W with explanation please Pg. 02 Question Two Leaming Outcomers) Question Two 10 Marks Create a...

Question:

w

with explanation pleasePg. 02 Question Two Leaming Outcomers) Question Two 10 Marks Create a SQL statement to retrieve information from a relational database Consider the relations: requested STUDENT | Student# Std-Name Address Khan Madina Muhammad Yanbu 3 Ahmad Riyadh |+| COURSE Student# Course | Course-Name 1 IT342Enterprise Systems 2 IT407Professional Issues 2 IT445DSS Write a query using the Right Outer Join to retrieve the record from the two relations. Also, construct the table displaying the output of your query

Pg. 02 Question Two Leaming Outcomers) Question Two 10 Marks Create a SQL statement to retrieve information from a relational database Consider the relations: requested STUDENT | Student# Std-Name Address Khan Madina Muhammad Yanbu 3 Ahmad Riyadh |+| COURSE Student# Course | Course-Name 1 IT342Enterprise Systems 2 IT407Professional Issues 2 IT445DSS Write a query using the Right Outer Join to retrieve the record from the two relations. Also, construct the table displaying the output of your query

Answers

Hi,

For a join between 2 tables, the table which is writen on the left hamd side of the join is called a left table and a table which is written on the right hand side of the join is called right hand side table. In the given question, if we join student table with course table, the student table is considered as left table and course table is right table.

Also, it is asked in the question to use the right join. Joon will work on the basis of join condition. We need to find the colimn which is common in both student and course relation. The common column is student#.

So, we need to use this column in the join condition. Also, as it is a right join it will return the unmatched rows from the right table which is course table.

Query-

select * from student s right outer join course c on s.student_number=c.student_number;

Output-

student# std-name Address student# course course_name
1 Khan Madina 1 IT342 Enterprise systems
2 Mohammad Yanbu 2 IT407 Professional Issues
null null null 3 IT445 DSS
.

Similar Solved Questions

1 answer
Eft:1:02:50 Daniel Anderson: Attempt 1 question 8 (3 points) You assign a unique number from 1...
eft:1:02:50 Daniel Anderson: Attempt 1 question 8 (3 points) You assign a unique number from 1 to 6 to yourself and 5 friends. You roll a single die. The person with the number corresponding to the die value chooses which movie the group will see. Which describes the sampling method used? O systemat...
1 answer
A-DA-EEEE JE Norm Paragraph Kirchoff's Current Law (KCL) 116: Online Lab - 6 Work Sheet 750...
A-DA-EEEE JE Norm Paragraph Kirchoff's Current Law (KCL) 116: Online Lab - 6 Work Sheet 750 Colours Brown green red Violet green brown Green blue brown Red red bronn Orange orange brown Red violet brown Brown black red Rs-5664 Ri= 12 VT M Vi | V | V6 | VI-VI- 10 V V1 V3 4.05 4.38 5.67 6.12 7.297...
1 answer
A 0.030-m^3 container is initially evacuated. Then, 4.0 g of water is placed in the container,...
A 0.030-m^3 container is initially evacuated. Then, 4.0 g of water is placed in the container, and, after some time, all the water evaporates. If the temperature of the water vapor is 388 K, what is its pressure?...
1 answer
3. Node Voltage Analysis: Perform Node Voltage Analysis on the circuit shown. Use the node voltages...
3. Node Voltage Analysis: Perform Node Voltage Analysis on the circuit shown. Use the node voltages provided. This analysis requires the use of a supernode. VB 13 10V > 4 Ohms DAA DA VREF = 0 Volts a) Canvas Question # 17: What is the supernode constraint equation involving VA, VB and the voltage...
1 answer
The Sky Blue Corporation has the following adjusted trial balance at December 31. Credit Debit $...
The Sky Blue Corporation has the following adjusted trial balance at December 31. Credit Debit $ 1,320 2,900 3,200 3,900 16,500 Cash Accounts Receivable Prepaid Insurance Notes Receivable (long-term) Equipment Accumulated Depreciation Accounts Payable Salaries and Wages Payable Income Taxes Payable ...
1 answer
Determine if the following limits have an indeterminant form, state it, and use L'Hopital's rule to...
Determine if the following limits have an indeterminant form, state it, and use L'Hopital's rule to compute the limit if possible. (a) limz-x++3x2–1 1 -3 (d) lim240 32° +sin(e"), (b) lime- 2 sin(3x) (e) lime-o(1 – x) tan(7), x2 – In(2/x) (f) limo+(1+2).. X-2 5.0 (c)...
1 answer
Step 1 of 4: Find the point estimate for the population mean of the paired differences....
Step 1 of 4: Find the point estimate for the population mean of the paired differences. Let x1 be the blood pressure before taking the new drug and x2 be the blood pressure after taking the new drug and use the formula d=x2−x1 to calculate the paired differences. Round your answer to one decim...
1 answer
Can you show step by step how to solve it, including the equations. 5. An 8.0...
Can you show step by step how to solve it, including the equations. 5. An 8.0 mm (0.31 in.) diameter cylindrical rod fabricated from a 7075-T6 alloy is subjected to reversed tension-compression load cycling along its axis. If the maximum tensile and compressive loads are +8400 N (1890 lby) and -8400...
1 answer
Chavez Corporation reported the following data for the month of July Inventories: Raw materials Work in...
Chavez Corporation reported the following data for the month of July Inventories: Raw materials Work in process Finished goods Beginning Ending $ 27,000 $ 30,000 $ 16,800 $ 17,000 $ 32,000 $ 47,000 Additional information: Raw materials purchases Direct labor cost Manufacturing overhead cost incurred...
1 answer
On June 3, Patel Company sold to Pham Inc. merchandise having a sale price of $1,500...
On June 3, Patel Company sold to Pham Inc. merchandise having a sale price of $1,500 with terms of 2/10, n/60, f.o.b. shipping point. An invoice totaling $45, terms n/30, was received by Pham on June 8 from the John Booth Transport Service for the freight cost. On June 12, the company received a che...
1 answer
Find the future value and interest earned if $8806.54 is invested for 9 years at 6%...
Find the future value and interest earned if $8806.54 is invested for 9 years at 6% compounded (a) serniannually and (b) continuously (a) The future value when interest is compounded semiannually is approximately $ (Type an integer or decimal rounded to the nearest hundredth as needed.) The interest...
1 answer
Ve 2 for 2
ve 2 for 2...
1 answer
Consider a simple economy that produces only three products: baseballs, pizzas, and tables. Using knowledge you...
Consider a simple economy that produces only three products: baseballs, pizzas, and tables. Using knowledge you acquired in Module 2.1, use the information in the table below to calculate your answers to the questions, Product Quantity Base Year Price (2001) Price (2018) Price (2019) Baseball 10 $1....
1 answer
True or False : 14 of 15 FINISH QULZ TRUE FALSE 1) This scheme shows the...
True or False : 14 of 15 FINISH QULZ TRUE FALSE 1) This scheme shows the correct transformation (reactant to product) when conducting the reaction shown 3) NOME MO 5) LDATEC, THE SPRCH, Q Zoom 1) NaOme 2) Х Br Br Ph 3) NaOme 4) H/H20, A 5) LDA, -78°C, THE 6) PhCH2B1 MULTIPLE CHOICE ....
1 answer
While life in the USA is not perfect today we have substantially reduced racial discrimination and...
While life in the USA is not perfect today we have substantially reduced racial discrimination and child labor since the 19th century a. these examples serve as illustrations that argue against all other arguments b. these examples are good for shedding light on the moral progress argument c. these ...
1 answer
How do you evaluate #c^ -3(16^ -2)# for c=4?
How do you evaluate #c^ -3(16^ -2)# for c=4?...
1 answer
1. Who proposed the original central dogma of molecular biology? Draw the original central dogma that...
1. Who proposed the original central dogma of molecular biology? Draw the original central dogma that depicts the flow of information transfer, name each step and indicate the enzyme involved in each step. In the modified central dogma what two steps were added and which enzymes perform these steps?...
1 answer
Your company manufactures 150 mg ibuprofen tablets. You randomly sample 20 tablets and measure their mass,...
Your company manufactures 150 mg ibuprofen tablets. You randomly sample 20 tablets and measure their mass, then calculate the average mass X from this sample. You know that the standard deviation of tablet mass from your manufacturing process is o=6 mg. a. Specify a null and alternative process to d...