- ----------------------------------------------- -- % Students Table (SELECT * FROM Students) ----------------------------------------------- -- % [ StudentId, StudentName, AdvisorId ] -- % [ 1, 'Obvi Ously', 2 ] -- % [ 2, 'Gen Ius', 3 ] -- % [ 3, 'Al-Ways Lernin', 1 ] -- % [ 4, 'Solo Ryder', NULL ] -- % [ 4, 'Will Power', 2 ] ----------------------------------------------- -- ------------------------------------------- -- % Advisor Table (SELECT * FROM Advisors) ------------------------------------------- -- % [AdvisorId, FirstName, LastName ] -- % [1, 'Engineering', 'TheBest' ] -- % [2, 'Biology', 'Science' ] -- % [3, 'Economics', 'Governor'] -- % [4, 'Business', 'Person' ] ------------------------------------------- -- -- !!! You do not have to write the query results, the query alone will suffice. !!! -- -- 1. Write a query to display the names of the students who do not have an assigned advisor. -- 2. Write a query to display students and their advisor info given a specific AdvisorId `X`. -- 3. Write a query to add your name as a new advisor. -- 4. Write a query to delete your advisor row. -- 5. Write a query to display the number of students assigned to each advisor. -- 6. Write a query to display the advisors who have no students.

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

1st Edition

ISBN:9781305657458

Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Publisher:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell

Chapter8: Digital Storage : Preserving Content Locally And On The Cloud

Section: Chapter Questions

Problem 11PS

See similar textbooks

Related questions

Question

-----------------------------------------------

-- % Students Table (SELECT * FROM Students)

-----------------------------------------------

-- % [ StudentId, StudentName, AdvisorId ]

-- % [ 1, 'Obvi Ously', 2 ]

-- % [ 2, 'Gen Ius', 3 ]

-- % [ 3, 'Al-Ways Lernin', 1 ]

-- % [ 4, 'Solo Ryder', NULL ]

-- % [ 4, 'Will Power', 2 ]

-----------------------------------------------

-------------------------------------------

-- % Advisor Table (SELECT * FROM Advisors)

-------------------------------------------

-- % [AdvisorId, FirstName, LastName ]

-- % [1, 'Engineering', 'TheBest' ]

-- % [2, 'Biology', 'Science' ]

-- % [3, 'Economics', 'Governor']

-- % [4, 'Business', 'Person' ]

-------------------------------------------

-- !!! You do not have to write the query results, the query alone will suffice. !!!

-- 1. Write a query to display the names of the students who do not have an assigned advisor.

-- 2. Write a query to display students and their advisor info given a specific AdvisorId `X`.

-- 3. Write a query to add your name as a new advisor.

-- 4. Write a query to delete your advisor row.

-- 5. Write a query to display the number of students assigned to each advisor.

-- 6. Write a query to display the advisors who have no students.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.