Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help with questions 9-12. thank you For questions 9-12, use the following two tables. Assume each shape can only have one color i.e. this

please help with questions 9-12.
thank you
image text in transcribed
For questions 9-12, use the following two tables. Assume each shape can only have one color i.e. this is not a many-to-many relationship. IMPORTANT NOTE: Questions 9-11 are ALL OR NOTHING. You either get them exactly correct or they are worth 0 points. Colors Shapes color_id color shape id color_id shape Red Blue Orange Green Square Circle Star 4 1 Triangle (12 points) Name all the color and shape combos (e.g. purple hexagon, teal decagon) the following query would produce: SELECT c.color, s.shape FROM COlors AS C JOIN shapes AS S ON c.color ids.color id: Color / shape combos: 0. (12 points) Name only the colors that would appear in the following query SELECT c.color FROM colors AS C LEFT JOIN shapes AS S ON c.color id s.color id Colors: (12 points) Name only the colors that would appear in the following query: SELECT c.color FROM shapes AS s RIGHT JOIN colors As c ON s.color id c.color id Colors: 12. (10 points) Using colors as the left table and shapes as the right table, would a LEFT JOIN and a FULL OUTER JOIN produce different results? Why or why not

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle9i Database Administrator Implementation And Administration

Authors: Carol McCullough-Dieter

1st Edition

0619159006, 978-0619159009

More Books

Students also viewed these Databases questions

Question

2. What is the meaning and definition of Banking?

Answered: 1 week ago

Question

3.What are the Importance / Role of Bank in Business?

Answered: 1 week ago