Consider the Student database schema given below.1. Write SQL to Retrieve student id's and student names of students that passed at least one coursewith a grade better than B+ (i.e., A‐, A, or A+). Avoid duplicates.2. Use relational algebra to Retrieve student id's and student names of students that passed at least one coursewith a grade better than B+ (i.e. A‐, A, or A+). Avoid duplicates. 3. Use relational algebra to Retrieve names of students that have enrolled in Database Systems. CREATE TABLE Student (Student Id int PRIMARY KEY,Stud_Name varchar NOT NULL);CREATE TABLE Course (CourseId char (7) PRIMARY KEY,Cour_Name varchar NOT NULL,NoOfPts int NOT NULL);CREATE TABLE Enrolled (StudentId int NOT NULL REFERENCES Student,CourseId char (7) NOT NULL REFERENCES Course,Grade char(2),PRIMARY KEY (StudentId, CourseId));CREATE TABLE Stud_Sport (Student Id int NOT NULL REFERENCES Student,Sport_Name varchar NOT NULL,PRIMARY KEY (StudentId, Sport_Name));

The tables student and enrolled created and inserted data The table student is: Table enrolled is:…

Answered: Consider the Student database schema…

Database System Concepts

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

See similar textbooks

Related questions

Question

Consider the Student database schema given below.

1. Write SQL to Retrieve student id's and student names of students that passed at least one course
with a grade better than B+ (i.e., A‐, A, or A+). Avoid duplicates.

2. Use relational algebra to Retrieve student id's and student names of students that passed at least one course
with a grade better than B+ (i.e. A‐, A, or A+). Avoid duplicates.

3. Use relational algebra to Retrieve names of students that have enrolled in Database Systems.

CREATE TABLE Student (
Student Id int PRIMARY KEY,
Stud_Name varchar NOT NULL);
CREATE TABLE Course (
CourseId char (7) PRIMARY KEY,
Cour_Name varchar NOT NULL,
NoOfPts int NOT NULL);
CREATE TABLE Enrolled (
StudentId int NOT NULL REFERENCES Student,
CourseId char (7) NOT NULL REFERENCES Course,
Grade char(2),
PRIMARY KEY (StudentId, CourseId));
CREATE TABLE Stud_Sport (
Student Id int NOT NULL REFERENCES Student,
Sport_Name varchar NOT NULL,
PRIMARY KEY (StudentId, Sport_Name));

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 6 images

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.

Similar questions