Introduction to DataBase

1.

INTRODUCTION TO
DATABASE
Course overview
Lecturer Rita Marčiulynienė, [email protected], 224 room

2.

Today topics
Overview of databases and reasons for using them
Course presentation (topics, laboratory work, evaluation)
Simple example of database

3.

WHAT IS A DATABASE?

4.

What Is a Database?
A very large collection of data:
Collection of textual or numeric information
Collection of images, audio and video information
and so on.
A real-world model
A database is a collection of information that
is organized so that it can be easily
accessed, managed and updated.

5.

Three conceptions of databases

6.

Three conceptions of databases
(1) A database (DB) is a collection of stored and related
data that has the following characteristics:
Integration
Redundancy
Independence
Non-controversy (consistency)
Security

7.

Three conceptions of databases
(2) Database is a First Concept Definition (DB) + a set of
applications that perform data processing operations (DBMS)

8.

DataBase Management system (DBMS)

9.

Three conceptions of databases
(3) A database is a set of information, mathematical, linguistic,
software, technical and organizational tools for centralized data
collection in order to obtain operational information. Data base - as
information system.

10.

Where we meet a Database in our life?
Source: https://philip.greenspun.com/software/claim-construction-tutorial/example/

11.

Where we meet a Database in our life?
Šaltinis: http://emarkets.eu/global-data-base-management-systems-dbms-market/

12.

Why We need Database?
Why not enought usual text files or spreedsheets?

13.

What Database is better?
Data is organized so, that is easier to find relevant information.
Data gets updated, expanded and deleted as new information is
added.
Databases process workloads to create and update themselves,
querying the data they contain and running applications against it.
Reduced application development time.
Data integrity and security
Uniform data administration.

14.

What We study Databases?
Shift from computation to information.
Datasets increasing in diversity and volume.
Databases encompasses most of computer systems
OS, languages, multimedia…

15.

How can we learn DB?
As users

16.

How can we learn DB?
As developers

17.

Database course topics
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
Main Concepts of Database Systems.
Database efficiency criteria.
Data representation levels
Conceptual modelling.
Classical Models of Data Organization.
Relational data model.
Fundamentals of Relational Algebra.
Relational calculus.
Database normalization.
Data Retrieval Methods and Application in Database Systems.
SQL basics.
Data Integrity.
SQL statements in the applications and their execution phases.
14.
Database management systems review and development trends.

18.

Course format
Activities
Place and time
Evaluation form
Lectures
Thursday from 13.00 to 14.30 159 a. Universiteto 10.
Midterm exam 17 %
Exam
50%
You must select one time from the list below: Monday
from 15.00 till 16.30, 116a. Universiteto 10.
Monday from 18.35 till 20.05, 119a. Universiteto 10.
Wednesday from 13.00 till 14.30
Wednesday from 17.15 till 18.45, 118 a. Universiteto 10.
Thursday from 11.15 till 12.45, 103 a. Universiteto 10
L1-L5 defense 16.5%
Practical
work
Individual task 16.5%

19.

Course evaluation
Exam
50%
Midtearm exam
17%
Laboratory works
33%

20.

Laboratory works
Starts from 11.09.2021

21.

DB starts from
subject area analysis
create data model ( data model – collection of consepts for describing
data)
recognize objects
define the properties of the objects
recognize properties which unambiguously defined object.
provide relationships between diferent objects.
Create schema ( schema- description of a particular colection of data,
using the given data model)
Implement schema to relational DBMS (MySQL)

22.

Let’s try together
We need do create DB for university to colect data about sudents and
courses which they take and marks too.
•recognize objects
•define the properties of the objects
•recognize properties which unambiguously defined object.
•provide relationships between diferent objects.

23.

Let’s try
You need do create DB for lybrary to colect information about readers,
books and books have been taken.
Create simple data model and schema for this DB.
•recognize objects
•define the properties of the objects
•recognize properties which unambiguously defined object.
•provide relationships between diferent objects.