Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
+1 vote
1.4k views
in Data Base Management System for Accounting by (27.3k points)
closed by

Create a Table named ‘Tbl students’ in LibreOffice Base with the following fields. Set the Admn No. as Primary Key

Admin No Name of student Class Admission Date Fee paid
6847 Arya Science 11/6/2013 480
6848 Aneesha Commerce 13/6/2013 430
6849 Arun Science 22/6/2018 480
6850 Akhil Commerce 24/6/2018 430
6851 Athulya Humanities 6/7/2018 360

1 Answer

+2 votes
by (25.6k points)
selected by
 
Best answer

procedure: 

Step 1 – Open Libre Office Base Application → Office → LibreOffice Base. 

Step 2 – Create a new database Database wizard → Create a New Database → Next → Yes register the database for me → Open the database for editing Finish. 

Step 3 – In Save Dialogue box, give the name STUDENT FEE and select a location to save the database and click Save button. The new database le STUDENT FEE.odb. is created 

Step 4 – Create Data Tables From the left Database Pane, click on the icon Tables and below the Tasks section, click on ‘Create Table in Design view’ Database Pane → Tables → Create Table in Design view

Step 5 – Field Name Entry In Table creation Screen, Enter the Field names and select appropriate Data Types as given below.

Field Name Data Type
Admn No. Number (Numeric)
Name of student Text (VARCHAR)
Class Text (VARCHAR)
Admission date Date (DATE)
Fee paid Number (Numeric)

Step 6 – Setting Primary Key To set the Admn No. as the Primary key, Right click on the row selector of Admn No. and select the Primary key from the drop down menu 

Step 7 – Save Table Click on Save button (or press Ctrl+S) to save the table. In save as dialogue box, Enter Tblstuderrts as table name and click on OK button Close the table creation screen 

Step 8 – Data Entry Database Pane → Tables → Created Tables → Select Tbl students → Double click to open it Enter all the data given one by one

Output :

Admin No Name of student Class Admission Date Fee paid
6847 Arya Science 11/6/2013 480
6848 Aneesha Commerce 13/6/2013 430
6849 Arun Science 22/6/2018 480
6850 Akhil Commerce 24/6/2018 430
6851 Athulya Humanities 6/7/2018 360

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...