k3lad_Assign8.docx - CS 200 Assignment 8 \u2014 SQL Due Wednesday March 13th 2019 11:59 pm 1 Download ForAssign8 and SampleDB_Diagram from Assignments >

k3lad_Assign8.docx - CS 200 Assignment 8 u2014 SQL Due...

This preview shows page 1 - 2 out of 9 pages.

CS 200 Assignment 8 — SQL Due Wednesday March 13 th 2019, 11:59 pm 1. Download ForAssign8.docxand SampleDB_Diagram.pdffrom Assignments > Assignment 8 > Assignment Fileson Learn. Rename ForAssign8.docxto username_A8.docxusername1_username2_A8.docxif you are working with a partner. Using MS Wordinsert your input and/or output after each sub-question. Please format your answerswith the following styles provided in ForAssign8.docx.Use the style AnswerTop for the first line of your statement e.g. SELECT.Use the styleAnswer for the lines between AnswerTop and AnswerBot.Use the styleAnswerBot for the last line of your statement.Use the style SQL_Outputfor tabular SQL output, where requested. You do not need to create an MS Word table. Dba dba DbaThese styles are already in ForAssign8.docx.Approximately 7% of the marks for this question are reserved for proper formatting of your answer within ForAssign8.docx.[75%] In InteractiveSQLcreate the appropriate statements to answer the queries below, based on the database described in SampleDB_Diagram.pdfa)What SQL statement would you use to list the courses known to the database? or , : Select Course From Course b) What SQL statement would you use to list the student numbers of people taking Algebra? c)What SQL statement would you use to list the courses that have assignments due on Oct. 18, 1986, with their respective assignment numbers, and ordered by course?
Image of page 1
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture