- ----------------------------------------------- -- % 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.
- ----------------------------------------------- -- % 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
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
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.Recommended textbooks for you
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning