Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

sid 53666Jones 53688 Smith 3999Smith Taylor staylor 1996-3-20 108 Inamelogin Brown dob credits points wn jbown1994-3-21 100 340 Walker swalker 1995-8-20 104 350 Table 1:

image text in transcribed
image text in transcribed
sid 53666Jones 53688 Smith 3999Smith Taylor staylor 1996-3-20 108 Inamelogin Brown dob credits points wn jbown1994-3-21 100 340 Walker swalker 1995-8-20 104 350 Table 1: Students call num course num course title 11121 11122 1222 CS1600 credits term year instructor id Spring 2014 222 Spring 2014 223 Spring 2014 200 CS1100 Foundation of CS Discrete Structures 4 Computer Science I4 CS1400 Table 2: Sessions sid 53666 53688 3999 53999 un grade 11121 11121 11122 11222 Table 3: Enrolled Please write the following queries on the above given relations in relational algebra: 1). Find names of students who have enrolled course CS1100 2). Find all course titles that Jones Brown has enrolled. 3). Find names of students who have enrolled in CS1400 and CS1600 4). Find names of students who have grade 'A 5). Find names of students who have not enrolled in CS1100

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Describe your ideal working day.

Answered: 1 week ago