Database system. Lecture 5

Июль 21, 2022

Главная
Информатика
Database system. Lecture 5

Содержание

2. Lecture 1 INTRODUCTION TO ICT Lecture 2 introduction to computer systems Lecture 3 software Lecture 4
3. Database system DBMS Types of DBMS SQL
4. Data - facts that related to any object inconsideration: Name, Age, Height etc., or to you:
5. Functions of the DBMS - search for information in the database - perform simple calculations -
6. Types of Databases - Hierarchical - Network - Relational - Object oriented
7. Hierarchical Model
8. The Network Model
9. The Relational Model A relational database - a set of simple tables, between which connections (relations)
11. What is SQL? - Structured Query Language (SQL) is a standardized language used to manipulate database
13. Скачать презентацию

Слайд 2

Lecture 1 INTRODUCTION TO ICT Lecture 2 introduction to computer systems Lecture

3 software Lecture 4 usability of interfaces Lecture 5 database system

Слайд 3

Database system
DBMS
Types of DBMS
SQL

Слайд 4

Data
- facts that related to any object inconsideration: Name, Age, Height

etc.,
or to you: image, file, pictures etc.

Database

- systematic collection of DATA

Dbms

Database Management System – collection of programs which enables:
- to access databases;
- to manipulate and control data etc.

Слайд 5

Functions of the DBMS
- search for information in the database
- perform

simple calculations
- printing reports
- database editing

Слайд 6

Types of Databases
- Hierarchical
- Network
- Relational
- Object

oriented

Слайд 7

Hierarchical Model

Слайд 8

The Network Model

Слайд 9

The Relational Model
A relational database - a set of simple tables,

between which connections (relations) with the numeric codes.

Слайд 10

Слайд 11

What is SQL?
- Structured Query Language (SQL) is a

standardized language used to manipulate database objects and the data they contain
- used for: insert, search, update, delete database records.
- SQL being a nonprocedural is not a general-purpose programming language.