Page 303 - TP_IT_V1.0_C10_flipbpookl
P. 303

Which of the following statements about a primary key in a relational database is correct?

                           It can contain duplicate values.
                           It can be NULL.
                           It uniquely identifies each record in a table.

                           It is used to define relationships between tables.





                          What is an attribute or a set of attributes whose values match the primary key of another table?



                         CREATING A DATABASE USING LIBREOFFICE BASE

                 Following the given steps to create a database using LibreOffice Base:

                 Step 1:  Click on the Start button. The Start menu will appear.
                 Step 2:  Select the LibreOffice folder from the Start menu.
                 Step 3:  Click on the LibreOffice Base option.

                 The Database Wizard with two steps will appear as explained below:
                 1.   Select database: This will help you create a new database, open an existing database file or connect to a database
                    stored on a server. So, you can select:
                    •  Create a new database: To create a new database.
                    •   Open an existing database file: It helps you open an existing file displayed when clicking on the drop-down list.
                    •  Connect to an existing database: This can be used if the database is stored on a server.
                 Step 4:  Select the Create a new database radio button.
                 Step 5:  Click on the Next button.
































                                                              Database pane


                                                                        Database Management System using LibreOffice Base  301
   298   299   300   301   302   303   304   305   306   307   308