Relational Algebra dbms

Information about a collection of students is given by the relation studinfo (studid, name, sex). The relation enroll (studld, Courseld) gives which student has enrolled ...

rohitkaushal1

737 views

rohitkaushal1 asked Sep 25, 2022

Databases
relational-algebra
databases
relations
gateforum-test-series

+ –

1 votes

3 answers

rahul sharma 5 asked Jul 13, 2017

2,390 views

DBMS Relational Algebra
How the following two expressions are equal? The LHS will remove duplicates but RHS will not.Please explain

How the following two expressions are equal?The LHS will remove duplicates but RHS will not.Please explain

rahul sharma 5

2.4k views

rahul sharma 5 asked Jul 13, 2017

Databases
relational-algebra
databases
relations

+ –

1 votes

2 answers

aditi19 asked May 8, 2019

1,254 views

Raghuramkrishnan Exercise-4.3 question 11 page no-127 Relational Algebra
Suppliers(sid, sname, address) Parts(pid, pname, color) Catalog(sid, pid, cost) Find the pids of the most expensive parts supplied by suppliers named Yosemite Sham

Suppliers(sid, sname, address)Parts(pid, pname, color)Catalog(sid, pid, cost)Find the pids of the most expensive parts supplied by suppliers named Yosemite Sham

aditi19

1.3k views

aditi19 asked May 8, 2019

Databases
databases
relations
relational-algebra
relational-calculus
joins

+ –

5 votes

3 answers

aditi19 asked Apr 11, 2019

8,828 views

Raghuramkrishnan Exercise 4.1 Relational Algebra
Given two relations R1 and R2, where R1 contains N1 tuples, R2 contains N2 tuples, and N2>N1> 0, give the minimum and maximum possible sizes (in tuples) for the result relation produced by each of the following relational algebra expressions. In each ... $σa=5(R1)$ (selection) $\pi a(R1)$ (projection) $R1/R2$ (division)

Given two relations R1 and R2, where R1 contains N1 tuples, R2 contains N2 tuples, and N2>N1 0, give the minimum and maximum possible sizes (in tuples) for the result rel...

aditi19

8.8k views

aditi19 asked Apr 11, 2019

Databases
databases
relational-algebra
relational-calculus
relations

+ –

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true

3 3 Comments reply

Please log in or register to add a comment.

Please log in or register to answer this question.

0 Answers

Related questions

3 3 Comments