Home » Articles posted by evirtualguru_ajaygour (Page 1378)

Learn online DBMS “Create Table Command in MySQL” Complete Lesson 8

CREATE TABLE COMMAND This command is used to create a new table or relation. The syntax for this command is : Create Table <table name> ( <column 1><data type> [constraint] , <column 2><data type>[constraint], <column 3><data type>[constraint] );   where []=optional The keyword “Create Table” is followed by the name of the table that you want to create. Then within parenthesis, you write the column definition that consists of column name...
Continue reading »

Learn online DBMS “Structured Query Language (SQL )” Complete Lesson 7

  Structured Query Language (SQL )   SQL is a language that is used to manage data stored in a RDBMS. It is a Data definition language (DDL) and a Data manipulation language (DML) where DDL is a language which is used to define structure and constraints of data and DML is used to insert, modify and delete data in a database. SQL commands are used to perform all the operations....
Continue reading »

Learn online DBMS “Relational Model Constraints” Complete Lesson 6

  Relational Model Constraints Constraints are restrictions on the values stored in a database based on the requirements. For example, in the relation EMPLOYEE, the Employee_ID must be a 4-digit number, the Date_of_Birth must be such that the age of employee should be >= 18 and <=65. Following are the various types of constraints in Relational Model:   Domain Constraint–It specifies that the value of every attribute in each tuple must...
Continue reading »

Essay on “Poverty Eradication Programmes-How Far Successful?” Complete Essay for Class 10, Class 12 and Graduation and other classes.

  Poverty Eradication Programmes-How Far Successful? Poverty is the greatest problem India is facing today. Poverty is a curse on Indian society. More than 40% of India’s population lives below poverty line. They do not have enough money to have two meals per day. Various planning and programmes have been introduced to fight this disease but the result has been far from satisfactory. Poverty apart from economic factor has various psychological...
Continue reading »

Essay on “Fifty Years of Indian Planning” Complete Essay for Class 10, Class 12 and Graduation and other classes.

  Fifty Years of Indian Planning Planning is very essential for any nation to achieve economic development. When India attained its independence, it has to face problems like poverty, economic inequality and social inequalities, etc. In order to achieve the goal of economic development, India planned its economy. It went for five years plans started in 1951. Planning Commission and National Development Council were set up. In the last fifty years...
Continue reading »

Essay on “Impact of Economic Reforms” Complete Essay for Class 10, Class 12 and Graduation and other classes.

  Impact of Economic Reforms Economic reforms were introduced in India in 1991 to check the declining performance of Indian economy at home and abroad. The measures taken were privatization as a part of liberalization to integrate into the world economy so that India does not fall behind in the process of globalization. Our liberalization remained partial and so was its impact. The economic reforms could not touch the poorest of...
Continue reading »

Essay on “Problem of Rural Indebtedness in India” Complete Essay for Class 10, Class 12 and Graduation and other classes.

  Problem of Rural Indebtedness in India Indians live in villages and on their betterment depends the success of our democracy. Apart from banning bonded labour, plan for liquidation of rural indebtedness has been mooted out. We can confer human rights and achieve the human purposes by securing economic freedom for the villagers. We must use the energy of the farmers for productive purposes. Till villagers participate in the working of...
Continue reading »

Essay on “Problems and Prospects of Small Scale Industries in India” Complete Essay for Class 10, Class 12 and Graduation and other classes.

Problems and Prospects of Small Scale Industries in India India is facing the problem of unemployment in a big way. To make tie situation worse there is paucity of capital resources and the unemployed cannot start their own industries. Small scale industry can provide the necessary solution. Small scale enterprises, according to the definition given by the government, is an undertaking with a fixed capital investment in plant and machinery not...
Continue reading »