search
Log In

Recent questions tagged relational-algebra

0 votes
2 answers
1
The following relation records the age of $500$ employees of a company, where $empNo$ (indicating the employee number) is the key: $empAge(\underline{empNo},age)$ ... one other employee Employee numbers of all employees whose age is not the minimum Employee numbers of all employees whose age is the minimum
asked Feb 18 in Databases Arjun 571 views
0 votes
1 answer
2
Match $\text{List I}$ with $\text{List II}$ Let $R_1=\{(1,1), (2,2), (3,3)\}$ and $R_2=\{(1,1), (1,2), (1,3), (1,4)\}$ ... answer from the options given below: $A-I, B-II, C-IV, D-III$ $A-I, B-IV, C-III, D-II$ $A-I, B-III, C-II, D-IV$ $A-I, B-IV, C-II, D-III$
asked Nov 20, 2020 in DS jothee 179 views
2 votes
2 answers
3
Which of the following desired features are beyond the capability of relational algebra? Aggregate Computation Multiplication Finding transitive closure All of the above
asked Apr 1, 2020 in Databases Lakshman Patel RJIT 464 views
0 votes
1 answer
4
0 votes
2 answers
5
2 votes
1 answer
7
Let $pk(R)$ denotes primary key of relation $R$. A many-to-one relationship that exists between two relation $R_1$ and $R_2$ can be expressed as follows: $pk(R_2)\rightarrow pk(R_1)$ $pk(R_1)\rightarrow pk(R_2)$ $pk(R_2)\rightarrow R_1 \cap R_2$ $pk(R_1)\rightarrow R_1 \cap R_2$
asked Mar 24, 2020 in Databases jothee 235 views
3 votes
3 answers
8
With respect to relational algebra, which of the following operations are included from mathematical set theory? Join Intersection Cartisian product Project a and d b and c c and d b and d
asked Jul 2, 2019 in Databases Arjun 1.4k views
3 votes
1 answer
9
In a relational algebra ∩ is not a basic operator, to make it basic only relational operator we should have are X, – X, U U, –
asked May 25, 2019 in Databases Hirak 934 views
1 vote
3 answers
10
Consider two $n \times 1$ vectors $u$ and $v$ , stored as table $U(\text{ind,val})$ and $V(\text{ind,val})$ with the same schema A row $(i,u_i)$ of table $U$ specifies the $i^{th}$ element of vector $u$ has value $u_i$ (similarly for $v$, ... $u + v$ of the two vectors $u$ and $v$. Explain your solution.
asked May 12, 2019 in Databases akash.dinkar12 447 views
1 vote
2 answers
11
... How this implication holds true?? Selection operation is commutative. But is two project operation can be merge in one project operation? Can project operation removes duplicates too??
asked May 9, 2019 in Databases srestha 490 views
0 votes
1 answer
12
0 votes
1 answer
13
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?
asked May 7, 2019 in Databases aditi19 324 views
0 votes
0 answers
14
Here why does the 5th query select * from employees natural join works_on where PID = 'X' AND PID='Y'; is not working The queries are The output are
asked Apr 30, 2019 in Databases kd..... 267 views
2 votes
3 answers
15
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 case, state any assumptions about ... difference) $R1 X R2$ (cartesian product) $σa=5(R1)$ (selection) $\pi a(R1)$ (projection) $R1/R2$ (division)
asked Apr 11, 2019 in Databases aditi19 3.2k views
0 votes
0 answers
16
Consider the following relations: $\text{STD_CHOICES } (\underline{\text{Student_ID}}, \underline{\text{Course_ID}}, \text{Semester})$ and $\text{COURSE_ASSIGN} (\underline{\text{Teacher_ID}}, \underline{\text{Course_ID}}, \underline{\text{Semester}})$. The former ... output the ID for all the students who have not been taught by the same teacher in more than one course across all semesters.
asked Apr 8, 2019 in Databases akash.dinkar12 275 views
0 votes
0 answers
17
We know that Relational Algebra is $Procedural$ whereas TRC and DRC are $Non-Procedural$ querry languages. But what exactly differentiates them? Please explain using some example. In Relational Algebra we give what to retrieve and ... https://stackoverflow.com/questions/32837278/difference-between-relational-algebra-and-relational-calculus/32841232#32841232 Please explain using some example
asked Mar 30, 2019 in Databases !KARAN 116 views
0 votes
1 answer
18
Let R = (A, B) and S = (A, C), and let r (R) and s(S) be relations. Using the special constant null, write tuple-relational-calculus expressions equivalent to each of the following: a. r $ROJ$ s b. r $FOJ$ s c. r $LOJ$ s
asked Mar 27, 2019 in Databases ajaysoni1924 174 views
0 votes
2 answers
19
Consider two relations R1 , R2 with N1 and N2 tuples where N2 > N1 > 0, what are the minimum and maximum rows for the RA expression R2/R1 ?
asked Mar 27, 2019 in Databases Priyansh Singh 575 views
1 vote
0 answers
20
Consider the employee database shown here. Give expressions in tuple relational calculus and domain relational calculus for each of the following queries: a. Find the names of all employees who work for First Bank Corporation . b. Find the names and cities of residence of ... street, city ) works (person name, company name, salary) company (company name, city) manages (person name, manager name)
asked Mar 26, 2019 in Databases ajaysoni1924 251 views
0 votes
1 answer
21
Consider the following relational schema for a library: member(memb_no, name, dob) books(isbn, title, authors, publisher) borrowed(memb_no, isbn, date) Write the following queries in relational algebra. a. Find the names of members who have borrowed any book published by ... into account that if a member does not borrow any books, then that member does not appear in the borrowed relation at all.
asked Mar 26, 2019 in Databases ajaysoni1924 1.3k views
0 votes
0 answers
22
Consider the relational database shown here. Give a relational-algebra expression for each of the following queries: a. Find the company with the most employees. b. Find the company with the smallest payroll. c. Find those companies whose employees earn a higher salary, on ... street, city ) works (person name, company name, salary) company (company name, city) manages (person name, manager name)
asked Mar 26, 2019 in Databases ajaysoni1924 218 views
...