Page 269 - Trackpad 402_Class-X_Final
P. 269

A new database with the name - School.odb is created with the objects -Tables, Queries, Forms and Reports.
                    The given database window opens:





























                                    Table: STATIONARY
                     uiz Bee
                                         SID          SNAME        COMPANY          PRICE        STOCKDATE
                                        DP01      Pen                 ABC             10         2011-03-31
                                         PL02     Pencil              XYZ             6          2010-01-01
                                         ER03     Eraser              XYZ             7          2010-02-14
                                         PL01     Pencil              CAM             5          2009-01-09
                                        GP02      GelPen              ABC             15         2009-03-19

                                    Table: CONSUMER

                                         CID          CNAME         ADDRESS          SID
                                          01      Good Learner   Delhi               PL01
                                          06      Write Well     Mumbai             GP02
                                          12      Topper         Delhi              DP01
                                          15      Write & Draw   Delhi               PL02
                                          16      Motivation     Bengaluru           PL01
                                    Answer the following based on the above tables:
                                    a.  Identify the Primary Key for the tables STATIONARY and CONSUMER
                                    b. Identify the Alternate Key of the table CONSUMER
                                    c.  Identify the Candidate Keys of the table STATIONARY
                                    d. Identify the Foreign Key of the table CONSUMER







                    STEPS TO CREATE A TABLE

            To create a table, select the Table option in the Database list.  In the OpenOffice Base there are two different methods
            used to create a table.






                                                                                   Database  Management System  269
   264   265   266   267   268   269   270   271   272   273   274