Relational DBMS

1. Relatinship between relational databse

1.1. * 1:1 relationship

1.1.1. - Should be rare in any relational database design

1.2. * 1:M relationship

1.2.1. -Relational modeling ideal -Should be the norm in any relational database design

1.3. * M:N relationships

1.3.1. - Cannot be implemented as such in the relational model - M:N relationships can be changed into 1:M relationships

1.3.2. -Implemented by breaking it up to produce a set of 1:M relationships - Avoid problems inherent to M:N relationship by creating a composite entity Includes as foreign keys the primary keys of tables to be linked

2. Right JOIN:-

2.1. Adds all the rows from the table on the left side of the join and for the rows in the right table who didn't match with any row, it gives NULL in the data entry for that row

3. relational set Operators

3.1. Relational algebra

3.1.1. Defines theoretical way of manipulating table contents using relational operators

3.1.2. Use of relational algebra operators on existing relations produces new relations

3.1.3. examples

3.1.3.1. SELECT

3.1.3.2. PROJECT

3.1.3.3. UNION

3.1.3.4. DIFFERENCE

3.1.3.5. INTERSECT

3.2. Relational Set Operators

3.2.1. Natural Join

3.2.1.1. Links tables by selecting rows with common values in common attribute(s)

3.2.2. Equijoin

3.2.2.1. Links tables on the basis of an equality condition that compares specified columns

3.2.3. Theta join

3.2.3.1. Any other comparison operator is used

3.2.4. Outer join

3.2.4.1. Matched pairs are retained, and any unmatched values in other table are left null.There are 3 types of outer joins

4. what is means by key ?

4.1. - Each row in a table must be uniquely identifiable - Key is one or more attributes that determine other attributes - Key’s role is based on determination If you know the value of attribute A, you can determine the value of attribute B - Functional dependence Attribute B is functionally dependent on A if all rows in table that agree in value for A also agree in value for B

5. the types of keys

5.1. Composite key Composed of more than one attribute

5.2. Key attribute Any attribute that is part of a key

5.3. Superkey Any key that uniquely identifies each row

5.4. Candidate key A Minimal super key i.e. whose proper subset is not a superkey

5.5. Foreign key An attribute whose values match primary key values in the related table

5.6. Secondary key Key used strictly for data retrieval purposes, or a primary key which is not choose

6. Characteristics of relational table

6.1. A table is percieved as two-dimensional structure composed of rows and columns.

6.2. Each table represent a single entity occurance within the entity set.

6.3. Each table column represents an attribute, and each column has a distinct name.

6.4. Each row/column intersection represents a single data value.

6.5. All values in a column must conform to the same data format.

6.6. Each column have a specific ranges of value known as attribute domain.

7. LEFT JOIN:-

7.1. Adds all the rows from the table on the left side of the join and for the rows in the right table who didn't match with any row, it gives NULL in the data entry for that row