Question: SQL assignment Do not turn in an MDB (MS Access database) file or any other database file. Write your SQL script in a text editor
SQL assignment



Do not turn in an MDB (MS Access database) file or any other database file. Write your SQL script in a text editor or word-processor and then turn in a word-processor file (e.g., doc or docx), a text file (i.e., tx), or a PDF file. Using the University database (univ db in pp. 80-82 of the textbook: Microsoft Access Database univ4.mdb), create a "SELECT" SQL statement for each of the following problems. [An SQL statement may include nested queries.] Note: The University database (univ db) in pp. 80-12 of the textbook contains partial, not complete, lists of records of tables Turn in SQL statements only. (Do NOT turn in the results of SQL statements.) . List the course number and course description of the course that was taken by more students than any other courses were. (Note: Do not use "Top 1" or "Limit 1" in your query.) (If the records of tables in the univx .db description were complete, a correct statement would give the following result.) IS320 FUNDAMENTALS OF BUSINESS PROGRAMMING 2. List the names of faculty members and the course numbers for which the faculty member teaches the same course as his or her supervisor in 2013 (If the records of tables in the unix db description were complete, a correct statement would give the following result.) LEONARD LEONARD FIBON VINCE IS320 IS320
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
