Basic set operation, Database Management System

These are the binary operations; i.e., each is applied to two relations or sets. These two relations can be union compatible excluding in case of Cartesian product. Two relations R (A1, A2,....., An) and S (B1, B2,......,Bn) are said to be union compatible if they have the similar degree n and domains of the corresponding attributes are also the similar

i.e. Domain (Ai) = Domain (Bi) for 1<=i<=n.

Posted Date: 3/6/2013 5:41:24 AM | Location : United States







Related Discussions:- Basic set operation, Assignment Help, Ask Question on Basic set operation, Get Answer, Expert's Help, Basic set operation Discussions

Write discussion on Basic set operation
Your posts are moderated
Related Questions
Multi-Key File Organisation In this part, we will introduce two basic file Organisation schemes that permit records to be accessed by more than one key field, therefore, allowi

Need 2 projects completed in 3NF format.

Construct a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles that comprise an engine number and cost; cars that have a chass

Why a report generator is used ? Report generator is used for print files on paper.

3NF Normal Form A relation schema R is in 3NF if it is in 2NF and for each FD X A either of the following is true X is a Super-key of R. A is a prime attribute of R

What are the advantages and disadvantages of merging an association into a class?  Advantages: i)  Less number of tables ii) Faster performance due to the fewer tables

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this info


What Command You Use What Day of the week were you born

Having Clause with sub queries: First we have to recollect the GROUP BYclause. The following query searches the minimum salary in every department. SELECT DEPTNO, MIN (SAL)