Skip to content

xwu64/525-HW

Repository files navigation

=================================================================================
=                            Document for Homework 1                            =
=================================================================================

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                             1. Cartesian-Product program

Write data in 'Cartesian-Product_file1', 'Cartesian-Product_file2' files. 

Print command:

    $ python Cartesian-Product.py

Result will display in terminal

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                             2. Natural Join program

Write data in 'Natural_Join_file1', 'Natural_Join_file2' files. 

First and third columns in Natural_Join_file1 compare with second and third columns in Natural_Join_file2.

Print command:

    $ python Natural_Join.py

Result will display in terminal

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
                             3. Outer Join program

This is left outer join.

Write data in 'Outer_Join_file1', 'Outer_Join_file2' files. 

First and third columns in Natural_Join_file1 compare with second and third columns in Natural_Join_file2.

Print command:

    $ python Outer_Join.py

Result will display in terminal


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages