Page 179 - Artificial Intellegence_v2.0_Class_11
P. 179

RIGHT JOIN table2
                 ON table1.matching_column = table2.matching_column;

                 Full Outer Join
                 Combines the result of both LEFT JOIN and RIGHT JOIN. It returns all records which match   Left    Right
                 in either left or right table.                                                       Table       Table
                 Syntax: SELECT table1.column1, table1.column2, table2.column1, ....
                 FROM table1

                 FULL JOIN table2
                 ON table1.matching_column = table2.matching_column;


                                Reboot

                      1.  Identify the type of join and the set operation from the diagram given below:






                                                           table 1       table 2







                      2.  Identify the relational and set operation from the diagram given below:







                                                            A             B












                        Simple Statistical Concepts

                 Statistics  is  a  set  of  tools  that  can  be  used  to  obtain  answers  to  important  questions  about  data.  It  is  generally
                 considered a prerequisite in the field of machine learning. We need statistics to help turn observations into information
                 and answer questions about observation samples.
                 “Central tendency” is expressed as a summary of a data set in a single value, representing the entire distribution of

                 a data domain (or data set). Central tendency does not analyze the individual values  in the data set but provides a
                 complete summary of the entire data.






                                                                                                 Maths for AI   177
   174   175   176   177   178   179   180   181   182   183   184