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

.   hat is    MS
             Ans.  R D B M S   is   a   r e l a t io n a l   D B M S   in   w h ic h   t a b l e s   a r e   l in k e d   t o   e a c h   o t h e r   b y   f ie l d s .   I n   a d d it io n   t o   a l l   t h e   a d va n t a g e s   o f
                 D B M S ,   R D B M S   h e l p s   in   t h e   m a n a g e m e n t   o f   a   d a t a b a s e   in   a   b r o a d e r   w a y .

                .   hat is database server   xplain  rimary key and Foreign key.
              ns.   atabase servers are dedicated computers that can hold the actual databases. It can run only the   MS and its
                 related software.  atabases available on the database servers are accessed through  ommand  ine or  raphic
                  ser Interface tools also called as Frontends. Other servers are referred to as  ackends that process the re uest
                 and provides the data.
                   Primary Key:  rimary key is a field which is used to uni uely identify records in a database. It is a uni ue field
                   and it cannot be left blank. There can be only one primary key in a table. If there are more than one primary
                   keys  then there will be two identities against a row.  here can be only one identity against a row. So  we cannot
                   have more than one primary key. To make retrieval of records faster, Primary keys are indexed in database.
                   Foreign Key:  he main table of a database is referred to as the  Master  able  and the tables in which the related
                   data is stored are referred to as   ransaction  able .  he tables are related and are linked through a field which
                   is common.  his common key field in the transaction table is called the  Foreign key  and its value depends on
                   the primary key values of the master table.

                .   hat are  lip  rts   ifferentiate between  inking and  mbedding an ob ect.
              ns.   lip rts are collections of pictures or images that can be imported into an o ce application.
                    ifference between  inking and  mbedding an ob ect:
                   Linking:  hen an ob ect is linked  information can be updated if the source file is modified.
                   Embedding:  hen an ob ect is embedded  it becomes a part of the file and does not get updated if the source
                   file is modified.

                .   hat do   MS and    MS stand for   xplain in short.
              ns.    MS stands for  atabase Management System. It is a software that controls the creation  maintenance and use
                 of a database.
                      MS stands for  elational  atabase Management System. In this database system  tables are linked to each
                 other by fields and helps in management of database in a broader way.
                .   hat do you mean by primary key and foreign key

             Ans.     Primary Key:  rimary key is a field which is used to uni uely identify records in a database. It is a uni ue field
                    and it cannot be left blank. There can be only one primary key in a table. If there are more than one primary
                    keys  then there will be two identities against a row.  here can be only one identity against a row. So  we cannot
                    have more than one primary key. To make retrieval of records faster, Primary keys are indexed in database.

                    Foreign Key:  he main table of a database is referred to as the  Master  able  and the tables in which the
                    related data is stored are referred to as   ransaction  able .  he tables are related and are linked through a
                    field which is common.  his common key field in the transaction table is called the  Foreign key  and its value
                    depends on the primary key values of the master table.


















                                                                                  Database Management          313
   310   311   312   313   314   315   316   317   318   319   320