-
Notifications
You must be signed in to change notification settings - Fork 0
/
README
45 lines (25 loc) · 1.39 KB
/
README
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
=================================================================================
= 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~