Open Office Databases
Topics:
1. Database Concepts
2. Edit Tables using Wizards and SQL statements
3. Data Definition Language and Data Manipulation Language
4. Retrieve Data using Query
5. Create Forms and Reports using wizard.
Databases
A database is an organized collection of data. You can visualize
it as a container of information.
The data is typically organized to model relevant aspects of
reality in a way that supports processes requiring this
information.
Databases
Students Database, Employee, Hotels are some examples.
Softwares Used: Microsoft Access, OpenOffice.org Base,
MySQL, Oracle, Microsoft SQL Server, Mongo DB .
Databases
The database concept has evolved since
the 1960s to ease increasing
difficulties in designing, building, and
maintaining complex information
systems.
(typically with many concurrent end-users, and
with a large amount of diverse data).
Database Management System (DBMS)
A database management system is a software package with
computer programs that controls the creation,
maintenance, and use of a database.
A database is an integrated collection of data records,
files, and other objects.
It allows different user application programs to
concurrently access the same database.
Database Servers
Database servers are dedicated computers that hold the
actual databases and run only the DBMS and related
software.
Typically databases available on the database servers are
accessed through command line or GUI tools referred to
as Frontends.
Database servers are referred to as Back-ends. Such type
of data access is referred to as a client-server model.
Data can be organized into two types:
❖ Flat File:Data is stored in a single table. Usually
suitable for less amount of data.
❖ Relational:Data is stored in multiple tables and the
tables are linked using a common field. Relational
is suitable for medium to large amount of data.
Softwares used in flat File is excel,google sheets,
open office calc.
Relational database: Access,Open office
Database,Oracle, MySQL.
RDBMS
A relational database management system (RDBMS) is a
database management system that is based on the
relational model as introduced by E. F. Codd, of IBM’s San
Jose Research Laboratory.
Most popular databases currently in use are based on the
relational database model.
RDBMS
In the relational model of a database, all data is
represented in terms of tuples, grouped into relations.
● The users directly state what information the db
contains and what information they want from it.
● DBMS software take care of describing data
structures for storing the data and retrieval
procedures for answering queries.
Advantages of Databases
● Reduces Data Redundancy : single database and any
change in it is reflected immediately.
● Sharing of Data:authorisation to access the data, and
consequently the data can only be shared based with
the authorized users.
● Data Integrity:data is accurate and consistent in the
database.
Advantages of Databases
● Privacy : only the authorized users can access a
database according to its privacy constraints.
● Backup and Recovery :automatically takes care of
backup and recovery.
● Data Consistency :there is no data redundancy (no
Duplication of information)
THANK YOU!!
