What is basic SELECT statement?

Image
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

Define the terms: domain, tuple, attribute and relation

General Definitions


Relation: A relation in a relational database is described as a table. Table is organized into rows and columns.

Attribute: A column header of a table is known as attribute of a relation.

Tuple: A row in a table represents the record of a relation and known as a tuple of a relation.

Domain: A set of possible values for a given attribute is known as domain of a relation. A domain is atomic, that means values are indivisible. For example, set of values for attribute FirstName of an EMPLOYEE relation are atomic.









Comments

  1. Looking for Kamagra gel? Then we are the best for you, who suit your expectations. We have huge experience on this field. We are 100% dedicated to find you cheap pKamagra gel.
    Kamagra Gel is the most convenient and effective solution for improving and strengthening sexual function in men. You can buy Kamagra gel here and here are numberius clients buy our products. We are provide only high quality Kamagra gel for you with always customers support.


    If you want to know more, Please check out here - check here

    ReplyDelete
  2. Learn more about the blockchain-based platform, which aims at revolutionizing how musicians are valued with analytic, popularity charts, and progress tracking.
    If you want to know more, Please check out here - Music Platform

    ReplyDelete


  3. Nice post. I used to be checking constantly this blog and I am impressed! Extremely useful info particularly the ultimate section 🙂 I take care of such information a lot. I was seeking this certain information for a long time. Thank you and best of luck.
    ikigai pdf

    ReplyDelete
  4. I think one who want to understand those concept basically here very well represented without lot of unimportant information.they can use this.

    ReplyDelete

Post a Comment

Popular posts from this blog

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

What are the different types of database users?