procedure:
Step 1 – Open LibreOffice Base Application → Office LibreOfffice Base
Step 2 – Create new Database Datebase wizard → Create a new database Next → Yes, register database for me → Open the data base for editing → click on Finish button
Step 3 – In save Dialogue box, give the name STUDENTFILE and select a location to save the database and click Save button. The new database le STUDETFILE.odb is created
Step 4 – Create Data Tables
Create Table – 1
From the left Data base pane, click on the Icon Tables and below the Tasks section, click on ‘Create Table in Design view’, Data base Pane → Tables → Create Table in Design view
Step 5 – Field name Entry: In Table creation screen, Enter the eld names and select appropriate Data Types as given below
| Field Name |
Data Type |
| Admn No. |
Number (Numeric) |
| Name |
Text (VARCHAR) |
| Class |
Text (VARCHAR) |
Step 6 – Setting Primary key To set Admn No as the primary key Right click → Primary key from the drop-down menu
Step 7 – Save Table Press Ctrl+S on click on save button to save the table. Enter the name TBLSTUDENT → Click OK button.
Step 8 – Repeat the same steps for creating the second Table Create Table -2
| Field name |
Data Type |
| Class No. |
Number (Numeric) |
| Mark |
Number (Numeric) |
Set ‘Class No’ as the ‘Primary key’ save the table by naming TBLMARKS. Then close the table creation screen.
Step 9 – Data Entry Data base Pane → Tables → Created Tables → Select → (Two tables TBLSTUDENT and TBLMARKS one by one) → Double click to open it
Enter all the details one by one.
Step 10 – Create Relationship
(a) Go to the Tools menu, select Relationships. Now Add Table dialogue box will appear. Add both the tables to the relationship window and close the Add Table dialogue box
(b) Create relationship between TBLSTUDENT and TBLMARK. Position the mouse pointer over the primary key of TBLSTUDENT table, hold down the left mouse button, drag the pointer right to the primary key in the TBLMARK table and then release the mouse button.
(c) Click on Save button in relation design window to save the relationship File → Save Click Close button to close the relation design window
Output:
