union,cartesian product

Question

0.00/5 (No votes)

See more:

express a specific example for cartesian product, union, and set difference as everyday English and as relational algebra using the table you created in the previous example.
Is it possible to have union or cartesian product with only one relation(table)? sorry for the table i cant make it fit, but the attributes are licenceNo, yrinsured,yeinsuredExpired,model,color,auto/man,owner

Please may someone help, I am still waiting for an answer. Can this be done to this table and how?

01  licenceNo    yr_insured    yr_insuredExpired    model    color    auto/man    owner
02  111-aaa                1999          2009             beatle    pink     auto     Johnson
03  222-bbb                1999          2009            mustang    white    auto     Trot
04  333-ccc                2000          2010            tacoma    blue      auto     White
05  444-ddd                2007          2017             f-350    blue      auto     Black
06  555-eee                2005          2015            d-2500    black     auto     Smith
07  666-fff                2007          2017           corolla    white     man      Lee
08  777-ggg                2010          2020            matrix    white     auto     Kim
09  888-hhh                2008          2018             civic    green     man      Singh
10  999-iii                2008          2018           escalde    black     auto     Williams
11  000-jjj                2009          2019              civic    red      auto     Vanderhoot

Posted 26-Sep-10 11:29am

polska03

Updated 4-Oct-10 8:50am

v4

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Henry Minute · Accepted Answer · 2010-09-26T12:41:00

Well, yes and no. :)

For example in an employee table that includes a manager attribute, one solution to discovering the hierarchy is to use a self join which can result in a cartesian product.

So yes, because there would only be one table. No because it is being treated as two tables for the purposes of the join.