Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Database Management System (DBMS) using LibreOffice Base: Introduction and Concepts, High school final essays of Technology

Technology

A comprehensive introduction to database management systems (dbms) using libreoffice base. It covers fundamental concepts like data redundancy, reports, and the differences between data and information. The document also explores various data models, including network and hierarchical models, and highlights the advantages of using a dbms. Additionally, it delves into the practical aspects of using libreoffice base, including data types, table design, and sorting data.

Typology: High school final essays

2023/2024

Available from 03/16/2025

usoskrish
usoskrish 🇮🇳

1 document

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
NEW HORIZON SCHOLARS SCHOOL
INFORMATION TECHNOLOGY - 402
Unit III: Database Management System (Advanced) using LibreOffice Base
Chapter 8- Introduction to Database Management System
Q1.Define the terms:
a) Database
Ans. A database is a collection of logically related data items stored in an organized manner.
b) Data redundancy
Ans. Data redundancy means the occurrence of duplicate copies of similar data. Data redundancy
refers to the practice of keeping data in two or more places within a database or data storage system.
c) Report
Ans. A report is a formatted presentation of data from a database that is used to convey information in a
way that is easy to understand. Reports can be used for a variety of purposes.
Q2. Give one point of difference between:
a) Data and information
Ans. Data- The raw facts constitute Data.
Information- Information is the processed and organized form of data.
b) Form and Query
Ans. Form- A form is a feature of a database using which we can enter data in a table in an easy and user
friendly manner. A form consists of text boxes, labels, radio buttons, list boxes, checkboxes etc. that give a
user-friendly interface for entering data. The data entered through the forms is stored in tables.
Query – A query is used to retrieve the desired information from the database. The data set
matching the given criterion is retrieved from the table and displayed on the screen.
c) Network and hierarchical data
Ans. Network Data Model- In this model, multiple records are linked to same master file. It is also
considered as an inverted tree where master is present in the bottom of the tree and the branches
contain information linked to the master. The data of the company is represented using the network data
model.
Hierarchical Data Model- In this model the data is organized into a tree like structure. The data is stored in
the form of records. A record is a collection of fields and its data values. All these records are linked to
each other at various levels, thereby forming a hierarchy. For example, the data of a company is stored
using a hierarchical data model.
Q3. Give any four advantages of DBMS.
Ans. The advantages of DBMS are:
➢ Organised Storage
➢ Data Analysis
➢ Data Sharing
➢ Minimal Data Redundancy
➢ Data Consistency
pf3
pf4

Partial preview of the text

Download Database Management System (DBMS) using LibreOffice Base: Introduction and Concepts and more High school final essays Technology in PDF only on Docsity!

NEW HORIZON SCHOLARS SCHOOL

INFORMATION TECHNOLOGY - 402

Unit III: Database Management System (Advanced) using LibreOffice Base Chapter 8- Introduction to Database Management System Q1.Define the terms: a) Database Ans. A database is a collection of logically related data items stored in an organized manner. b) Data redundancy Ans. Data redundancy means the occurrence of duplicate copies of similar data. Data redundancy refers to the practice of keeping data in two or more places within a database or data storage system. c) Report Ans. A report is a formatted presentation of data from a database that is used to convey information in a way that is easy to understand. Reports can be used for a variety of purposes. Q2. Give one point of difference between: a) Data and information Ans. Data- The raw facts constitute Data. Information- Information is the processed and organized form of data. b) Form and Query Ans. Form- A form is a feature of a database using which we can enter data in a table in an easy and user friendly manner. A form consists of text boxes, labels, radio buttons, list boxes, checkboxes etc. that give a user-friendly interface for entering data. The data entered through the forms is stored in tables. Query – A query is used to retrieve the desired information from the database. The data set matching the given criterion is retrieved from the table and displayed on the screen. c) Network and hierarchical data Ans. Network Data Model - In this model, multiple records are linked to same master file. It is also considered as an inverted tree where master is present in the bottom of the tree and the branches contain information linked to the master. The data of the company is represented using the network data model. Hierarchical Data Model - In this model the data is organized into a tree like structure. The data is stored in the form of records. A record is a collection of fields and its data values. All these records are linked to each other at various levels, thereby forming a hierarchy. For example, the data of a company is stored using a hierarchical data model. Q3. Give any four advantages of DBMS. Ans. The advantages of DBMS are: ➢ Organised Storage ➢ Data Analysis ➢ Data Sharing ➢ Minimal Data Redundancy ➢ Data Consistency

Q4. Consider the table given below and answer the questions that follow Table: Library Book_Id Book Name Author Name Price Publisher F001 Pride and Prejudice Jane Austen 550 ABC S004 Amazing Astronomy E. Shane 1050 ABC C005 IT and Mankind MHA Diwaan 2500 HYM a) Name the fields in the given table. Ans. There are five fields in the table named - Book_Id, Book Name, Author Name, Price, Publisher. b) Which field should be made the primary key? Ans. Book_Id. c) Is there any alternate key in the table? Ans. No d) How is primary key different from foreign key? Explain with example.

Q3. How can we define a primary key in a table? Ans. A primary key is the column or columns that contain values that uniquely identify each row in a table. Primary keys must contain UNIQUE values, and cannot contain NULL values. E.g. ID number, serial number or code, GR. No. Q4. Write steps to sort the table in descending order of primary key. Ans. Data in a table can be arranged in ascending or descending order. This process of arranging the records in particular order on any field is called as sorting. Following are the steps to sort the table: Step 1 - Open the Event table in datasheet view and select the primary key field. Step 2 - From the tool bar click Sort Descending icon if the table has to be sorted in descending order of selected field. Step 3 - The table will be sorted in the descending order of points. Q5. What is the use of navigation box with respect to tables in a database? Ans. Navigation box is used to navigate (move) through various records of the table. The various components of Navigation Box are as follows: Record Selector Box – This is the text box where the currently active record number is displayed. We may enter the record number that we want to see in this text box. Navigation Buttons – These are used to scroll vertically in the table. Press  to move to the first record Press ► and ◄ to move to the next and previous records respectively. Press to move to the last record