Question : Good evening! I’m working on designing my very first actual database from the following UML class diagram (in […]
Tag: relational-algebra
Creating relationships between tables that where not specified in the given UML diagram
Question : Good evening! I’m working on designing my very first actual database from the following UML class diagram (in […]
Equivalent of SQL’s “INNER JOIN USING” in relational algebra
Question : I’m following a course in databases (Standford introduction to databases on YT) and, at some point, it’s mentioned […]
Why does the UNION operation require that the relations on which they are applied be union compatible?
Question : With respect to the operations in relational algebra (not in SQL): I’m having trouble understanding why 2 relations […]
Proof that Inner Join is Commutative
Question : I’m trying to prove to myself that the order of inner joins doesn’t matter, but, in an abstract […]
Is there a shortcut for ‘SELECT * FROM table’ in relational algebra?
Question : Problem A question I once found on a test was worded as such: Report the book information for […]
the verbosity of “(SELECT * FROM A)”?
Question : This might be a novice question. But sometimes, I find it necessary to use things like (SELECT * […]
Nontrivial joining a relation with itself [closed]
Question : Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? […]
Show the result of a set difference between tables Q and R [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Converting SQL to Relational Algebra / Calculus
Question : I have designed a schema and generated a few SQL queries. I’m using PostgreSQL. For example: CREATE TABLE […]
- 1
- 2