Per the SQL the database schema of attached image (Picture1.png).Retrieve the name and transcript of each senior student (Class = 5) majoring in CS. A transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student.Retrieve the names and major departments of all straight- A students (students who have a grade of A in all their courses).Retrieve the names and major departments of all students who do not have a grade of A in any of their courses. STUDENT Name StudentNumberClass MajorSmith171CSBrown82CSCOURSECourseNameCourseNumber CreditHours DepartmentIntro to Computer ScienceCS13104CSData StructuresCS33204CSDiscrete MathematicsMATH2410MATHDatabaseCS3380CSSECTIONSectionldentifierCourseNumberSemesterYearInstructor85MATH2410Fall98King92Cs1310Fall98Anderson102CS3320Spring99Knuth112MATH2410Fall99Chang119CS1310Fall99Anderson135CS3380Fall99StoneGRADE_REPORTStudentNumberSectionldentifierGrade1711217119885A892A81028135APREREQUISITECourseNumberPrerequisiteNumberCS3380CS3320CS3380MATH2410CS3320CS1310

A database is an organized collection of structured information , data , typically stored…

Answered: Retrieve the name and transcript of…

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

Related questions

Question

Per the SQL the database schema of attached image (Picture1.png).

1. Retrieve the name and transcript of each senior student (Class = 5) majoring in CS.
  A transcript includes course name, course number, credit hours, semester, year, and grade for each course completed by the student.
2. Retrieve the names and major departments of all straight- A students (students who have a grade of A in all their courses).
3. Retrieve the names and major departments of all students who do not have a grade of A in any of their courses.