If R1 and R2 are two relations or functions, then the result of R3 = R1 × R2 is the combination of tuples that are in R1 and R2. The product is associative and commutative.

Degree (R3) =Degree of (R1) + Degree (R2).

In case, R3 will have tuples such that R3 = {t1 || t2 | R1 ∋ t1  ∧ R2 ∋ t2}.

Example:

R2

A B A1 B1 A2 B2 A3 B3 A4 B4

       R1                         

C C1 C2

       

R3 = R1 × R2 is

 

A	B	C
A1	B1	C1
A1	B1	C2
A2	B2	C1
A2	B2	C2
A3	B3	C1
A3	B3	C2
A4	B4	C1
A4	B4	C2

 

Posted Date: 3/6/2013 5:48:36 AM | Location : United States

Ask an Expert

Related Discussions:- Cartesian product, Assignment Help, Ask Question on Cartesian product, Get Answer, Expert's Help, Cartesian product Discussions

Write discussion on Cartesian product
Your posts are moderated

Write your message here..

Related Questions

Define single valued and multivalued attributes, Define single valued and m... Define single valued and multivalued attributes. Single valued attributes: attributes with a single value for a particular entity are known as single valued attributes. Mult

What are the properties in a relation, What are the properties in a relatio... What are the properties in a relation ? In a relation Ordering of rows is immaterial and No two rows are identical.

What is a foreign key, What is a foreign key, and what is it used for? ... What is a foreign key, and what is it used for? A foreign key is used to establish relationships between relations in the relational model. Technically, a foreign key is a colu

What are the properties of transaction, What are the properties of transact... What are the properties of transaction? There are three properties of transactions :- A)     Atomicity B)      Consistency C)       Isolation

Project on designing and creating a database , This project will involve de... This project will involve designing and creating a database for an organization.  In the design of a database, there is no single "perfect" design.  So your database design may not

What is primary key, What is Primary key? Primary Key - Primary key i... What is Primary key? Primary Key - Primary key is one of the candidate keys which uniquely identifies each row in the relation.

What do you understand by data ware house, Question 1: Define the term ... Question 1: Define the term business intelligence tools? Briefly explain how the data from one end gets transformed into information at the other end? Definition Exp

Differance between ddl and sdl, Differance between DDL and SDL? DDL and... Differance between DDL and SDL? DDL and SDL - The data definition language (DDL) is used through DBA and database designers to describe internal schema, conceptual schema, and

Define the immediate update, Define the Immediate Update The immediate... Define the Immediate Update The immediate update methods may apply changes to the database on disk before the transaction arrives a successful conclusion. Though, these change

Relational database management, For this application, we will consider IBM ... For this application, we will consider IBM DB2 catalog data (i.e., metadata) for IBM's enterprise-class servers running the z/OS (formerly OS/390 or MVS) operating system.  One of