Page 319 - IT 402 v2.0 class 10
P. 319

am le: Create a table of ‘Students’ that contains four columns: STUDENT_ID, FIRST NAME, LAST NAME and
            MARKS.
              Click on ‘Tools’ menu and then select ‘SQL’ option. ‘Execute SQL Statement’ window appears on the screen.
              Type the following SQL Commands in the ‘Command to execute’ section.


            CRE AT E  T AB L E  ST U D E NT
            (
                 ST U D E NT _ I D  I NT ,
                   F I RST NAM E  V ARCH AR ( 2 5 5 ) ,
                   L AST NAM E  V ARCH AR ( 2 5 5 ) ,
                   M ARK S I NT
            ) ;
              Click on ‘Execute’ button.
              Successful execution of command is displayed on ‘Status’ section.

































            CREATE COMMAND WITH PRIMARY KEY

            CRE AT E  T AB L E  ST U D E NT
            (
               Ad mno nu mer ic p r imar y  K ey ,
               firstname varchar(200),
                  lastname varchar (200),
                         mar k s int
            ) ;
                MANAGING QUERY
             ueries are commands that are used to define the data structure and also to manipulate the data in the
            database.  uery is used to collect specific information from the table.    uery helps us to  oin information
            from different tables and filter specific information as per the re uired criteria.





                                                                                       More on Database        317
   314   315   316   317   318   319   320   321   322   323   324