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
In which relational modes, cardinality is termed? Answer : Cardinality is termed in a number of tuples relational modes.

Mention the purpose of SID and SOD lines SID (Serial input data line): It is an input line by which the microprocessor accepts serial data. SOD (Serial output data line)

What Count function return in SQL? Count function within SQL returns the number of values. (Count function counts all the not null values in the exact column. If we need to cou

Which operations need the participating relations to be union compatible? A UNION, INTERSECTION and DIFFERENCE operations need the participating relations to be union compatibl

What is Relational DBMS This is our subject of study. A DBMS is relational if the data is organized into relations, that is, tables. In RDBMS, all data are kept in the well-kno


Define Forms Based Interfaces? Forms-Based Interfaces - A forms-based interface display a form to each user. Forms are commonly designed and programmed for naive users and inte

Explain the utilities which help the DBA to manage the database? Every DBA uses database utilities to maintain and control their databases. But there is a lot of confusion wit

Consider the ER schema below for the MoneyMaking supermarket chain problem. Translate the given ER schema into SQL CREATE TABLE statement.