Semijoin and composition - sql, PL-SQL Programming

Semijoin and Composition - SQL

For semijoin, the dyadic relational operator MATCHING, defined thus:

r1 MATCHING r2, where r1 and r2 are relations such that r1 JOIN r2 is defined, is equivalent to

(r1 JOIN r2) {r1-attrs}

where r1-attrs is a commalist containing all and only the attribute names of r1.

and the example

COURSE MATCHING EXAM_MARK

is given as a relational expression for the predicate, "There exist a student StudentId and a mark Mark such that StudentId sat the exam and scored Mark marks for course CourseId and CourseId is entitled Title" (which could be abbreviated to "At least one student sat the exam for Course CourseId, entitled Title"). The resulting relation consists of just those tuples in COURSE that have at least one matching tuple in EXAM_MARK.

Posted Date: 1/18/2013 6:02:00 AM | Location : United States







Related Discussions:- Semijoin and composition - sql, Assignment Help, Ask Question on Semijoin and composition - sql, Get Answer, Expert's Help, Semijoin and composition - sql Discussions

Write discussion on Semijoin and composition - sql
Your posts are moderated
Related Questions
Keyword &Parameter Description: index_name: This is an undeclared identifier which can be referenced only within the FORALL statement and only as the collection subscript

Procedural Constraint Enforcement (Triggers) SQL has an alternative method of addressing database integrity, involving event-driven procedural code. The special procedures th

Literature review

Collections:   The collection is an ordered group of elements, all of similar type (for illustration, the grades for a class of students). Each element has an exclusive subsc

Overriding Default Locking By default, the Oracle locks the data structures for you automatically. Though, you can request exact data locks on rows or tables when it is to you

Example of GROUP BY and COLLECT Operator Example: Using GROUP BY and COLLECT to obtain C_ER2 SELECT CourseId, CAST ( COLLECT (ROW (StudentId, Mark)) AS ROW (Studen

Keyword & Parameter Description: PRAGMA: These keywords signify that the statement is a pragma (i.e. compiler directive). The Pragmas are processed at the compile time, n

BEGIN Parameter Description in pl sql: BEGIN: This keyword signals the beginning of the executable section of a PL/SQL block, that contains executable statements. The execut

Using FIRST and LAST FIRST and LAST return the first and last (minimum and maximum) index numbers in a collection. When the collection is empty, the FIRST and LAST return NULL

Tables within a Table - SQL Figure here is an exact copy of the one in the theory book and as before it is just an alternative way of representing some of the information con