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

