Quizzes

CS 330 - Management Information Systems

Question 1:


2. In your own words summarize the difference between an INNER JOIN and a LEFT JOIN.


3. What is the correct JOIN statement to display the table in the "SQL JOINS" section displaying the OrderID and SupplierID? (For bonus points provide the complete query)


4. Imagine you had two tables one containing information about music albums and another containing information about music singles. The music albums table contains the following columns: AlbumID, AlbumLength, and AlbumArtist. The music singles table contains the following columns: "SingleID, SingleTitle, AlbumID, and SingleArtist. If your colleague wanted to see if you tend to listen to complete albums or not which JOIN would you use to show them that you do or you do not and why?


5. After reading the infographic, what is your opinion of it? Do you think it is effective?


6. Draw a sketch of an infographic of showing scenario wheren one might use an INNER JOIN or LEFT JOIN that connect three or more tables.