Thursday, 14 February 2013

Practical File of computer application



      

              About college

     The Foundation of this college was laid in the memory of Late Sri. Bhawani Prasad Pandey Jee, a legend Vaidhya, a Learned person of Sanskrit Literature, a Thinker and a Social Worker, so as to bring drastic changes in the status of higher education to realised the role of Purvanchal in over-all development of Nation and to defend the ideal "Humanity" of Late Sri. Bhawani Prasad Pandey Jee.

     The College is one of the leading and notable institution in respect of Education and Discipline, which is dedicated to give practical shape to the dreams of its inspiring, renouned social worker Late Sri. Bhawani Prasad Pandey Jee. The College is constantly progressing undey the capable leadership of Sri. Sriprakash Pandey, the Manager; Sri. S.P.Pathak, the Dy. Manager and Dr. Brijesh Prasad Dubey, the Principal. The College is affiliated to Deen Dayal Upadhyay Gorakhpur University (www.ddugu.edu.in).    
   

      To establish a new standard in Educational Status of Northern Uttat Pradesh Bhawani Prasad Pandey P.G. College was eatablished on 2nd February 2002 under Draupati Devi Lok Kalyan Sansthan (established in the year 2001) The College is affiliated to Deen Dayal Upadhyay Gorakhpur University (www.ddugu.edu.in).The College has started as Under-Graduate College but now its is known to be an Post-Graduate from the current session 2006-07 and is authorised to run Hindi and Sanskrit at the Post-Graduate level.The College has its own Magazine which is published annually by the name "DRISTI", having all the updates regarding college.
 
CERTIFICATE

  This is certify    Mr. Pradduman Maurya

s/o Jagdish Prasad Maurya

Course   B.A.  2nd YEAR

SUBJECT   Computer Application

COLLEGE  Bhawani Prasad Pandey P.G. college karimnagar chargawa Gorakhpur

Completed practical successfully.


                            
                             Authorized Signature 

                         ………………………….


                      INDEX        
Introduction of C++ ……….……………………………………. 2                                                    
Introduction to OOPs…………………………………………… 2
Advantage of OOPs……………………………………………... 3
Inheritance: ………………………………………………………3
Polymorphism……………………………………………………..4
Encapsulation……………………………………………………..4
Operator overloading……………………………………………..5
Access specifier………………………………………………….....5
Intro to Function…………………………………………………..6
Introduction to Operator…………………………………………7
Array……………………………………………………………….9
Introduction of Pointer: …………………………………………10
Class and Object with example………………………………….11
LOGIC GATES…………………………………………………...12
Cache Memory……………………………………………………15
VIRTUAL MEMORY……………………………………………15
DBMS & RDBMS ………………………………………………...16
Karnaugh Map……………………………………………………17
Flip Flop……………………………………………………………18
Registers: ………………………………………………………….19
Multiplexer………………………………………………………..20
INTRODUCTION TO FOXPRO……………………………….21
ER- Model…………………………………………………………22
Entity……………………………………………………………..23
INSERT INTO command……………………………………….23
CREATE TABLE Command…………………………………..24
DELETE Command…………………………………………….24
PROGRAM FOR SHOW FABONICCI SERIES………….....25
A PROGRAM FOR PRINT THE TABLE
OF GIVEN NUMBER ………………………………………….26
A program using switch….case. ……………………………….27
Question…………………………………………………………………………….......28 
Introduction of C++

       C++ is an extension of C language with additional features of objects oriented programming. The C++ programming language was developed by Bjarne Stroustup at AT&T Bell laboratories in Murray Hill, New jersey in 1979.
     Most additions made by Stroustrup to C support object oriented programming. Stroustrup states that some of C++’s object oriented feature were inspired by another object oriented language called Simula67. Therfore C++ is the blending of two powerful programming methods.
     It was initially called the new language “C with Classes”, however in 1983 the name was changed to C++. The invention of C++ was necessitated by one major programming factor: increasing complexity. The essence of C++ is to allow the programmers to comprehend and manage larger, more complex program.            


                Introduction to OOPs  
      OOP is a programming paradigm that uses object to design application and computer programs.
   It uses several techniques from previously established paradigm including encapsulation, abstraction, polymorphism and inheritance.
    Object oriented programming language is a feature that allows a mode for modularizing programs by forming separate memory area for data as well as function that is used as object of making copies of modules as per requirement.
   This programming like as a robot search an object in room which is specified for robot. As like OOP is also based on this phenomena which called module, class etc.


                        

                                 Advantage of OOPs
1.    Rules of code:à Linking of code to objects and explicit specification or relations between objects allows related objects to share code. Encapsulation allows class definition allows class definition to be reuse in other application.
2.    Easy to comparison:à The class can be setup to closely represent the generic application concepts and processes. OOP codes are more near to real world model than other programming methodology code.
3.    Easy of fabrication and Maintenance :à The concept such as encapsulation, data abstraction allow for every clean design when an object is going into disallowed status, which  are not permitted, only its methods need to be investigated.
            Eg. If student is getting more than maximum mark only the functions are to be retested.

4. Easy redesign and extension.


                            Short notes:

1.Inheritance:à Inheritance is the process by which one class acquires the properties of another class.
  This is important because it supports the concept of hierarchies’ classification.
By use of inheritance and object need only define those qualities that make it unique within its class. It can inherit its general attributes from its parent.

        Class abc
{
 ----------
 ----------
};
Class xyz:public abc
{
----------
----------
};

          2.Polymorphism à Polymorphism is important concept of OOPs. Polymorphism a Greek term, means the ability to take more than one form . An operation may exhibit different behavior depend upon instances. The behavior depends upon the type of data used in the operation. It means the ability to take more than one function with the same name but with different functionalities.
    Polymorphism means the ability to take more than one form of any function. Polymorphism gives the ability to user to define a single function and use it in much different form on the basis of argument which we provide in the function.
    Eg.  

           float   area(float)
  {
        return a*a;
}
  float area(float a,float b)
{
return  a*b;
}
    

          Encapsulation à Wrapping up of data and function into a single unit is known as encapsulation. This is one of strong feature of object oriented programming. The data is not directly accessible from outside of the class.   Eg.
   class student
{
public:
    int a,b,c;
    input();
    show();
};
student::input()
{
cin>>a;
cin>>b;
}
                 Operator overloadingà
Operator overloading is just like the functions are being overloaded, the operator can also be overloaded in C++.
     Operator overloading means, giving additional meaning to the operators like +,-,*,/,>=,<= when dealing with the  objects of user defined class.
  Syntax-
      return_type operator operator overloaded(parameter)

              Access specifier

    The class body contains the declaration of its members. These members have a limited scope to access the class members. Access specifier denotes the scope of member function within outside the class of inside the class. In C++ access specifiers are following types-

  Privateà These are the members that cannot be accessed from outside the class. These are accessible only through the member function of the class.
  Public à Public specifier means that they are accessible from outside the class also, generally the member functions of class are declared in public section. Public member can be directly accessible by any function.
  Protectedà These are the members that can be use only by member function. The protected members are similar to private members that they cannot be accessed by non member function.
  class abc
  {
    private:
    ------------
    ------------
    public:
     ------------
     ------------
   protected:
      -----------
      -----------
     };
            
                     Intro to Function

   Function is a self contained part of program which carries out a specific and well defined task. Functions are actually smaller segment which help to solve bigger problem. Functions of C++ are dependently coded.
  In other word we can say that the functions are self contained blocks of code or statements, which performs a specific task.
      It can be devided into two categories-
1.   User defined function.
2.   Built in function or binary function.

1. User defined functionà C++ allows users to create and use their own function. In programs where only specific activity is to be performed its function is created and it is called whenever you needed them.

3.   Built in function or library functionà  These are predefined functions which are stored in the library files of C++. User can directly use them and there is no need to define by the users.
       These functions are also called a library function.
  
  E.g. Paw (), sort (), stripy () etc.





     
           Introduction to Operator

  Operatorà These are the symbolic representation of any operation.
     An operator specifies an operation to be performed that yields a value.  The variables, constants can be joined by various operators to form an expression.
10+2=12




Operand     operator 

These are three types of operators à

  1.Unary operator:- The operator that use only one operand to operation is called unary operator.
    Ex- unary plus(+)   int a=+18;
           unary minus(-) int b=-38;

 2. Binary Operator: - Binary operator is most useful operator of C++. It taken two operand to perform the operation. C++ has following binary operator.

1.    Arithmetic Operator
2.    Relational operator
3.    logical operator
4.    assignment operator
5.    Increment/decrement operator.
 

1.     Arithmetic Operator: - Arithmetic operators used for various mathematic calculation.
  Ex. +,*,-, / etc.
2.     Logical operator: - Logical operator combined the result of two or more than two expression. These operators are use to check the final result, either true or false.
        There are three types of logical operators

Logical AND           &&
Logical OR              ||
Logical NOT            !


3.    Assignment operator: - Assignment operator use to assignment value of an expression to a variable.
‘=’ is an assignment operator.

Eg. c=a+b


  4. Increment/decrement: - C++ provides the special (++) and (--) operators. The increment operator (++) add ‘1’ to its operand and decrement operator(--) subtract ‘1’ to its operand.
  
4.Ternary Operator:à
These operators taken three operands to perform its operation. It is represented by the symbol (?:).
Eg. a=14,b=58;
      c= (a>b)?a:b;
 result c=58

               What is Array?
  Array:  Array is a collection of similar type of data items and each data item is called an element of the array. The data type of the element may be any valid data type like char, int or float. The elements of array share the same variable name but each element has a different index number known as subscript.

   Declaration of array-
                                        data_type  array_name[size];

 Types of Array-
1. One dimensional array.
2. Two dimensional array.
3. Multi dimensional array.
1. One dimensional array:-
                                       Single dimensional arrays are essentially lists of information of the same type that are store in contiguous memory locations in index order.
Eg.-
   chara[12];

2.Two dimensional array:-
                                             Two dimensional arrays is called array of array. It is also called matrix, because it gives the output in matrix form. The element of two –dimensional array are stored in memory of contiguous memory.
   Eg.- int a[34][32];
 
     3.Multi dimensional array:-
                                            C/C++ allows array of more than two dimensions. The exact limit, if any is determined by our compiler. The general form of a multidimensional array declaration is-
        data_type araray_name [size1][size2][size3]…[size n];


        


                    Introduction of Pointer:

 A pointer is a variable that stores memory address. Like all other variables it has a name has to be declared and occupies some space in memory. It is called pointer because it pints to a particular location in memory by storing the address of that location.
  Declaration of Pointer- 
                                 Like other variables, pointer variables should also be declared before being used.
          The general syntax of declaration is -  data_type *pname.
       Here the pname is the name of pointer variable. Which should be a valid identifier?
                    
                        Example-
       #include<iostream.h>
main()  
{
 Int a=87;
Int  *p=&a;
cout<<”value of p =address of a =”,p;
cout<<”address of p”, &p;
cout<<”value of a=<<a<<*p<<*(&a);
}
                

             Class and Object with example

  Class :-  Classes are templates from which we can create objects. Each objects contain data and has method to manipulate and access that data.
    The class define what data and functionality has each particular object of that class.
              A class is the accomplishment of abstract data type. It defines the nature and method that acts on the data structure and abstract data type respectively.
  In other word a class is a grouping of objects having identical properties common behavior and shared relationship.
            Eg.

      Class <class name>
  {
     Private:
   [ variable declaration ];
    [ function declaration];
  Public:
    [ variable declaration ];
    [ function declaration];
Protected:
[ variable declaration ];
    [ function declaration];
};




  Object: - Objects are basic runtime entities of an object oriented system. They may stands for a thing that has specific application. For example-
                                 A spot, A person, any data related to program including user defined data types.

         Eg.
     Int main()
     {
     <Class name> <object name>
  Abc       a;
<Object name>.<function name>
  a.function();
 return 0;
}

                           

               LOGIC GATES

Logic Gatesà
Logic gates are electronic circuits that operate on one or more input signals to produce on output signal. In other words we can say-
                     A logic gate is an electronic circuit which makes logical decisions
                                                         Or
                              The logic gates are the building blocks of hardware which are available in the form of various integrated circuits.
The most commonly used logic gates are AND, OR , NOT and  NOR gate.
AND Gateà The logical multiplication is commonly (known as AND function) performed by AND gate. If A and B are the input variables of an AND gate and Y is its output then the logic equation will be:
                                Y=A.B

OR Gateà The logical addition is commonly (known as OR function) performed by OR gate. If A and B are the input variables of an OR gate and Y is its output then its logic equation will be
                                       Y=A+B
                            

 

NOT Gate: - Inversion or complementation is performed by the NOT Gate. This gate gives the opposite logic level of the applied logic level means if 1 is applied we will get 0 and vice versa.
 

NAND Gate (A­B)à NAND is the contraction of two gates NOT and AND.
If any one or both inputs are low (logic 0) then the output is HIGH (1). The NAND operation is the inversion of AND operation.


 NAND Gate is also known as bubbled OR gate. The logical function of NAND gate is
  Y=


NOR Gate(A¯B)à
                                 NOR gate is the complemented OR gate. NOR gate is derived by the contraction of NOT and OR gates. So , the logical symbol of the NOR gate will be given by



NOR Gate is also known as Bubble AND gate. The logical function of NOR gate is.  
                          Y=

      Exclusive OR(Ex-OR) Gateà The exclusive OR , denoted by the symbol Å, is a logical operation that performs the following Boolean operation:
      Y=

An X-OR gate has two or more input and one output. X-OR gate gives a HIGH voltage (logic 1) if one and only one input is at high voltage state and gives  a Low voltage(logic 0) if both inputs are at same voltage level (either 0 or 1).




Exclusive –NOR (Ex-NOR) Gateà The complemented operation of the exclusive OR is represented by the exclusive NOR. The logical operation of the Ex NOR gate is given by the Boolean function.

        Y=







Short notes:


    Cache Memoryà Cache memory is extremely fast memory that built into a computer’s central processing unit or located next to it on a separate chip. A cache, in computer terms, is a place to store information that is faster than the place where the information is usually stored. Cache memory is fast memory that is used to hold the most recently accessed data in slower main memory. The idea is that frequently accessed data will stay in cache, which allows the CPU to access it more quickly, which means it does not have to wait for the data to arrive.
 In reference to the processor, the Cache Memory is the processor’s internal quick hand storage that is uses for things that’s currently processing at that given time.
As with most things, the more cache memory a processor has, it will usually run smoother and faster than one with less of about the same frequency.


                                         VIRTUAL MEMORY
   Virtual memory is the technique that allows automatic swapping of program and data blocks between main memory and auxiliary memory. This concept allows constructing the programs larger than the memory space available, which may be equal to the totally of auxiliary memory. Each address generated by the processor goes through an address mapping scheme that transforms this address to the actual location where the requested data is stored. Such mapping procedure is handled automatically by the hardware using some mapping table.





   DBMSà Database Management system is a software package that allows data to be effectively stored, retrieved and manipulated. The data contained in a DBMS package can be accessed by multiple application programs and users. Application packages such as SQL server, Oracle , MS-Access are some commercially available DBMS packages.
     


   RDBMSà Relational Database management system is a software package use to store and retrieve data that is organized in the form of tables. In other words Relational database management system stores information in rows and columns and conducts searches by using data in specified columns and rows of one table as well as to find additional data in another related table.
              Two dimensional table is a natural way to represent data to a user. A table must be set up in a way that no information about the relations among the data elements is lost.

           
                      





                                 Karnaugh Map  



    Karnaugh mapping is a method of plotting a Boolean function and is use to a simplify tha expression making use of truth table.
    To draw a karnaugh map a Boolean function must be written in a sum of product  form or in the meanterm form. If it is not in this form then we should use the truth table to convert it to sum of product form.

       In other word K-map is a tool which can be use in the simplification of any Boolean expression.
         Some properties of K-map are listed below-
1.    K-map is a diagram which consists of squire and each squire represent a mean term of the function. These squires are also referred as cell.
2.    In an N-variable K-map, there are 2n cell.
3.    K-map pictorially represents all possible ways in which a function may be expressed in standard form(either in sum of product or product of sum).
4.    The simplest expression obtained by K-map is not unique. Sometimes we will find two or more expressions satisfying the minimization criteria. In such a case any of the solution is satisfactory.







                 Flip Flop
                  
    A flip flop is a binary cell which store one bit of information. It itself is a sequential circuit. A flip-flop can change it’s state when the clocks transitions from 0-1(rising age) or from 1 to 0(falling age) and not when clock is one. In simple word, flip flop is age triggered.
     We can also say that flip flop is the basic storage element for synchronous sequential circuit.
   A flip flop can show two conditions-
1. Reset condition.
2. Set condition.

1.Reset condition- In reset conditions value of S(set) is zero(0) and R(reset) value one time 1 another time 0(zero).

2. Set condition- In set condition value of R (reset) is 0(zero) is 0(zero) and S (set) is some time 1 another time 0(zero).
                The most common type of flip flops are-


         1. R-S flip-flop.
         2. J-K flip-flop.
         3. D flip-flop.
         4. T flip-flop.
         5. Master Slave flip-flop.







            Registers:
          
       A register is a group of flip flop, which store binary information, and gates which controls when and how information is transferred to the register on N-bit of binary information.
        In its broadcast definition, “A register consists of a group of flip-flop and gates that effect, their transition, the flip-flop hold the binary information and the gates control when and how new information is transferred into the register. For instance, A register used to store on 8-bit binary number must have 8 flip-flop, naturally the flip-flop must be connected such that the binary number can be entered shifted into the register and possible shifted out. A group of flip-flop connected to provide either or both of the functions is called a shift register.
      The bit in a binary number (call them the data) can be moved from one place to another in either of two ways. The first method involves shifting the data on bi at a time in a serial fashion, beginning with most significant bit (MSB) the last significant bit(LSB).

          Two basic types of register
1. Parallel register.
2. Shift register.



            Multiplexer
      Multiplexer is one of the basic building units which allow sharing of common line by more than one input line. It connects multiple input lines to a single output line we can say that multiplexer is a combinational circuit that receives binary information from many input but single output by us and control signal. We can select any input to the output in general the circuit has an input and a control signal and one output where n=2n .

     In other word we can say that multiplexer is one of the basic building unit of computer system which principle allows a sharing of common line by more than one input line. It connects multiple inputs line to a single output line. At a specific time one of the input line is selected and the selected input line is passed one to the line, selected line or control signal decided which input line is to be selected. The selected line provide the communication among the various component of a computer for the sake of consistency we as you input line as ‘i’ output line as ‘o’ and control line is‘s’.



             INTRODUCTION TO FOXPRO


         FoxPro is a relational database procedural programming language. Though it was initially developed by Fox Software in 1984. The company late merged with Microsoft in 1992. FoxPro was integrated as part of Microsoft’s Visual Studio. This term is also known as Visual FoxPro.
                Visual FoxPro is a relational-database with an object oriented programming environment from Microsoft that comes with prewritten classes. Visual FoxPro is part of Microsoft’s Visual-studio suite of products.
        Visual FoxPro is relatively easy to learn and fast for developing reusable code. A programmer can write code to access a FoxPro database or as well as to connect to such database as SQL-Server and Oracle. Microsoft says that there are at least 500,000 developers using FoxPro.
               In other words FoxPro is a Database Management System and it does support relationship between tables.
        The term “database” and “tables” are not synonymous in Visual FoxPro. The term database(.dbc file) refers to a relational database that is a container of information about one or more table (.dbf files ) or views.

           The key to effective database design lies in understanding exactly what information you want to store and the way a relational database management system, such as Visual FoxPro, stores data. To efficiently and accurately provide you with information Visual FoxPro needs to have the facts about different subjects employees and another that stores facts only about sales.

        When you design a database , you first break down the information you want to keep as separate subjects, and then you tell Visual FoxPro how the subjects are related to each other so that Visual FoxPro can bring the right information together when you need it. By maintaining information in separate tables, you make it easier to organize and maintain your data, as well as to build a high-performance application.

                                    ER- Model
     A model can be use to represent the pictorial form of a database.
   The entity relationship data model represents the explains design of database. In ER-Model we show all the relation & describe the Physical database model. Most of the databases are based on relational and network model.

    The relationship between entity set is represented by a name ER –relationship and can 1:1, 1:m, m:1, m:m. Eg.

          Entityà An entity is an object that is record finally organization. Objects are similar types or characterize by the some set of attributes or properties such similar object form an entity or entity tuple. Two objects are represented an entity set by giving them unique identifiers.
        Collections of similar type of entities are called entity set or entity type. Objects are represented by attribute from a primary key or other key for uniquely identify of an entity.
         Entity type that have primary key are called strong key and the entity which have no any primary key is called the weak key.


             INSERT INTO commandà  INSERT INTO command adds (appends) new rows (records) to a table. In other word, ones a table is created the next step in this table INSERT the record in the table the row are added to relations using INSERT command

     The syntax is –
 INSERT INTO<table name>
VALUES(<vaue>,<value>….)









             CREATE TABLE Commandà CREATE TABLE commands are use when we create a table by using this command first we write the table name  and then column and the data type of each column.

    The syntax of CREATE TABLE command is –

 CREATE TABLE<Table name>
[<column name> <data type> (size)]






            DELETE Command- The DELETE command removes row from a table this removes the entire rows, not individual fields value.

Eg. à If Radha(with emp_code,104) working in accounts department got posted then there is no need keep her records in this table.
     The SQL statement to DELETE the record of radha is – DELETE WHERE emp_code 104.
 To remove all the content of the table we would have enter the following statement DELETE from <table name> .
         The table would now be empty.




  PROGRAM FOR SHOW FABONICCI SERIES

#include<iostream.h>
#include<conio.h>
    main()
  {
long x,y,z;
int i,n;
x=0;y=1;
cout<<"enter the number of term";
cin>>n;
cout<<y;
for(i=1;i<n;i++)
   {
z=x+y;
cout<<z;
x=y;
y=z;
    }
cout<<"\n";
return 0;
    }

A PROGRAM FOR PRINT THE TABLE OF GIVEN NUMBER




#include<iostream.h>
#include<conio.h>
 void main()
{
int n,t,i=1;
clrscr();
cout<<"enter the num";
cin>>n;
cout<<"the table is ";
while(i<=10)
{
t=n*i;
cout<<t;
i++;
}
getch();
}

 A program using switch….case.

#include<isotream.h>
#include<conio.h>
void main()
{
int a;
cout<<"enter the number between 1 to 7";
cin>>a;
switch(a)
{
case 1:
cout<<"sunday";
break;
case 2:
cout<<"monday";
break;
case 3:
cout<<"tuesday";
break;
case 4:
cout<<"wednessday";
break;
case 5:
cout<<"thursday";
break;
case 6:
cout<<"friday";
break;
case 7:
cout<<"saturday";
break;
default:
cout<<"please enter value between 1 to 7 only";
}
getch();
}
Question :à Create a table Employee. Insert a field emp_name, emp_code, emp_designation,  emp_salary,  emp_address  and  after insert  10 record . And                                                   perform retrieve data.

Emp_code
Emp_name
Emp_designation
Emp_salary
Emp_address
101
Ram
Manager
25000
Gorakhpur
102
Shyam
Accountant
10000
Deoria
103
Ghanshyam
Assistant manager
15000
Gorakhpur
104
Girija
Engineer
20000
Bareli
105
Ranjeeta
Accountant
20000
Gorakhpur
106
Raj Kumari
Engineer
25000
Gorakhpur
107
Neha
Engineer
25000
Deoria
108
Rashmi
Steno
15000
Gorakhpur
109
Nisha
Clerk
10000
Gorakhpur
110
Kamal
Accountant
15000
Gorakhpur
                    Employee
      
CREATE TABLE Employee
Emp_code integer,
Emp_name char(20),
Emp_designation char(30),
Emp_salary integer,
Emp_address char(20);

            INSERTING RECORDS IN EMPLOYEE TABLEà
    INSERT INTO Employee
  VALUE 101, ‘Ram’, ’Manager’, 25000, ‘Gorakhpur’;

 INSERT INTO Employee
VALUE 102, ‘Shyam’, ’Accountant’, 10000, ‘Deoria’;

INSERT INTO Employee
VALUE 103, ‘Ghanshyam’, ‘Assistant manager’, 15000,‘Gorakhpur’;

INSERT INTO Employee
VALUE 104, ‘Girija’, ‘Engineer’, 20000, ‘Bareli’;

INSERT INTO Employee
VALUE 105, ‘ranjeeta’, ‘accountant’, 20000 ‘gorakhpur’;

INSERT INTO Employee
VALUE 106, ‘rajkumari’, ‘Engineer’, 25000 ‘gorakhpur’;

INSERT INTO Employee
VALUE 107, ‘neha’, ‘Engineer’,25000  ‘deoria’;

INSERT INTO Employee
VALUE 108, ‘rashmi’, ‘steno’,15000,  ‘gorakhpur’;

INSERT INTO Employee
VALUE 109, ‘nisha’, ‘clerk’,10000  ‘gorakhpur’;

INSERT INTO Employee
VALUE 110, ‘kamal’, ‘accountant’,15000  ‘gorakhpur’;

RETRIEVE  DATA

        SELECT  *  FROM Employee;