Page 306 - TP_IT_V1.0_C10_flipbpookl
P. 306

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 questions 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





                      OPENING A DATABASE

              Follow the given steps to open an already created database:
              Step 1:  Select the File → Open option from the Menu bar.
                      The Open dialog box open.
              Step 2:  Navigate the location where the database is stored.
              Step 3:  Select the desired database that you want to open.
              Step 4:  Click on the Open button.





























              The selected database gets opened.


                304   Trackpad Information Technology (Ver. 1.0)-X
   301   302   303   304   305   306   307   308   309   310   311