Want to create interactive content? It’s easy in Genially!

Get started free

MÓDULO TRAINING CODE

David Carmona Arrabal

Created on September 25, 2023

Start designing with a free template

Discover more than 1500 professional designs like these:

Essential Learning Unit

Akihabara Learning Unit

Genial learning unit

History Learning Unit

Primary Unit Plan

Vibrant Learning Unit

Art learning unit

Transcript

Actividad 1.2

David Carmona ArrabalDaria Sorokina

EMPEZAR >

>

>

Contenido de la presentación

Usos de los SGBD.

Clasificación de los SGBD.

Elements of a DBSM.

Glossary of terms.

<01> Usos de los SGBD

Funciones principales:- Descripción o definición. - Manipulación. - Control.

EMPEZAR >

>

>

<02> clasificación y tipos

- Según el propósito: General o Específico. - Según el número de usuarios atendidos: Monousuario o Multiusuario. - Según su distribución: centralizados o distribuidos.

>

>

<03>elements of a DBMS

Languages based on SQL: - DDL (Data Definition Language). - DML (Data Manipulation Language). - DCL (Data Control Language).

>

>

<03>elements of a DBMS

Dictionary: - Definition of tables, indexes and more. - Structure of the database. - Quantity of storage designed to every element of the database. - Description of integrity restrictions. - Information about the permits associated with every user. - How to use the database.

>

>

<03>elements of a DBMS

- Users:

  • Designers.
  • Operators.
  • Analysts.
  • Final users.
- Tools of a databases; group of applications that allows administrators to manage the database.

<04> glossary

DCL

Allows the database administrator to add protection mechanisms to it.

DML

Allows the users to search, add, erase or modify the data of a database.

DDL

Online transaction processing systems

Allows the database designer to create and define the internal, conceptual and external structure.

DBMS

Executing a series of transactions that occur simultaneously in online banking, shopping, order entry or text messaging.

Purpose

Group of programs that allows users to access and manage the data of a database.

Cost

The reason for which something is done or created or for which something exists.

DBA

The amount of money a thing is worth.

Database administrator, manager of the performance of the database.

>

>