What is basic SELECT statement?

SELECT Statement A SELECT statement retrieves data from the database. With SELECT statement PROJECTION, SELECTION and JOIN can be performed on database tables. As data in relational database is stored in TABLES. TABLE has ROW and COLUMN structure. With SELECT statement all rows and all columns can be retrieved, this is known as PROJECTION. But, if rows and columns are retrieved on the basis of some condition, it is known as SELECTION. And suppose if some information is needed and that is stored in two or more different tables but are related, use JOINS to retrieve it from two or more tables. In SQL, basic SELECT statements are as follows: SELECT  * FROM  [ table_name ] ; SELECT   [ column1 ] ,  [ column2 ] ,  [ column3 ] ,   .....   FROM   [ table_name ] ; SELECT and FROM are known as clauses.  SELECT clause allows to specify columns to be selected from the database table.  FROM clause allows to specify table name that has those column to be s

What are the types of Functional Dependency?

Types of Functional Dependency

There are basically two types of functional dependency, 

  1. Trivial Functional Dependency
  2. Nontrivial Functional Dependency

A functional dependency A à B is a trivial, if B is a subset of A. 

It means dependent is  a subset of determinant or right term is a subset of left term. That is trivial, and is not so important. As B is a subset of A, which we already know and so we are not getting any new thing.

A functional dependency à B is a nontrivial, if B is not a subset of A.

It means dependent is not a subset of determinant or right term is not a subset of left term. That is nontrivial, and is important. As B is not a subset of A, which we don't know and so we are getting something new.

Example of Trivial FD:


Example of Nontrivial FD:



Popular posts from this blog

Define the terms: domain, tuple, attribute and relation

With the help of block diagram explain the architecture of a DBMS.

What are the different types of database users?