Register

Recent questions tagged relational-calculus

2 votes
1 answer
3
GATE Overflow Test Series | Databases | Test 1 | Question: 13
Consider the following relation instance. $\textbf{Student}$ ... Select Enrol.CourseId from Enrol,Student where Student.weight > 45
Consider the following relation instance.$$\textbf{Student}$$$$\begin{array}{|c|c|c|c|c|}\hline \textbf{Roll}& \textbf{FirstName} & \textbf{LastName} & \textbf{Weight}\\\...
User Avatar
2 votes
2 answers
5
NIELIT 2017 July Scientist B (IT) - Section B: 19
If $R$ is a relation in Relational Data Model and $A_1,A_2,\dots A_n$ are the attributes of relation $R$, what is the cardinality of $R$ ...
If $R$ is a relation in Relational Data Model and $A_1,A_2,\dots A_n$ are the attributes of relation $R$, what is the cardinality of $R$ expressed in terms of domain of a...
User Avatar
1 votes
2 answers
7
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
User Avatar
0 votes
1 answer
8
Raghuramkrishnan Exercise-4.3 page-127
Given relation catalog(sid, pid, cost) Find pairs of sids such that the supplier with the first sid charges more for some part than the supplier with the second sid what is the relational algebra expression for this?
Given relationcatalog(sid, pid, cost)Find pairs of sids such that the supplier with the first sid charges more for some part than the supplier with the second sidwhat is ...
User Avatar
0 votes
0 answers
19
UGC-NET CS 2016 question
Given i= 0, j = 1, k = – 1 x = 0.5, y = 0.0 What is the output of given ‘C’ expression ? x * 3 & & 3 || j | k explanation please….
Given i= 0, j = 1, k = – 1x = 0.5, y = 0.0What is the output of given ‘C’ expression ?x * 3 & & 3 || j | kexplanation please….
User Avatar
0 votes
1 answer
20
RaghuramKrishnan
relation parts(pid, pname, color) catalog(sid, pid, cost) find the sids of suppliers who supply every red part. can someone give the TRC and DRC expression for this?
relationparts(pid, pname, color)catalog(sid, pid, cost)find the sids of suppliers who supply every red part.can someone give the TRC and DRC expression for this?
User Avatar
0 votes
1 answer
22
Korth
give domain relation calculus expression works(person-name, company-name, salary) find the names of all employees who earn more than every employee of Small Bank Corporation
give domain relation calculus expressionworks(person-name, company-name, salary)find the names of all employees who earn more than every employee of Small Bank Corporatio...
User Avatar
0 votes
0 answers
23
Relational Algebra
Online Site For practicing Relational Algebra https://dbis-uibk.github.io/relax/calc.htm
Online Site For practicing Relational Algebrahttps://dbis-uibk.github.io/relax/calc.htm
User Avatar
0 votes
1 answer
24
Verifying Relational Algebra Question
I think it should be option a) All query $1,3,4$ are equivalent but $2$ is not equivalent. Query $2$ should be $\prod \text{Room no,hotel no,type,price}(\sigma \text{type='single' } \wedge \text{price=200 })$
I think it should be option a)All query $1,3,4$ are equivalent but $2$ is not equivalent.Query $2$ should be $\prod \text{Room no,hotel no,type,price}(\sigma \text{type='...
User Avatar
1 votes
2 answers
28
Tuple Relational Calculus - What is the difference between these two types of bounded variables in the expressions?
If there are three tables to choose from -Sailors(sid,sname); Reserves(sid,bid); Boats(bid,color)Question is to choose a sailor who reserved a red boat.My question is wha...
User Avatar
Page: