Database Management System

Softecks

Iqukethe izikhangiso

Mayelana nalolu hlelo lokusebenza

Uhlelo lwezokuphathwa kwedatha (i-DBMS) isofthiwe yesistimu yokwakha nokuphatha yolwazi. I-DBMS inikeza abasebenzisi kanye nabahleli ngendlela ehlelekile yokudala, ukuthola, ukubuyekeza nokuphatha idatha

► I-DBMS yenza ukuba abasebenzisi bokugcina bakwazi ukudala, ukufunda, ukuvuselela nokususa idatha ku-database. I-DBMS isebenza njenge-interface phakathi kwe-database kanye nabasebenzisi bokuphela noma izinhlelo zokusebenza, ukuqinisekisa ukuthi idatha ihlelwe njalo futhi ihlala ifinyeleleka kalula.

  【Izihloko ezihlanganisiwe kulolu hlelo lokusebenza zihlelwe Ngezansi]

⇢ Sibutsetelo

I-⇢ Architecture

⇢ Amamodeli wedatha

Izinhlelo ze-⇢ Data Data

⇢ Ukuzimela Kwemininingwane

⇢ ER Model - Imiqondo Eyisisekelo

I-⇢ ER Umdwebo wesignesha

I-⇢ Yokwenziwa KwamaGeneral Generation

Imithetho 12 ye-⇢ Codd

⇢ Isibalo sedatha ye-Relation

⇢ Algebra ehlobene

⇢ ER Model kuya Model Relational
                
Uhlolojikelele lwe-⇢ SQL

⇢ Ukulinganisa

⇢ Ujoyina

Uhlelo lwezokugcina lwe-⇢

Isakhiwo sefayili ⇢
          
⇢ Indexing

⇢ Hashing

⇢ Ukuthengiselana
             
Ukulawulwa kwe-Concurrency ⇢
              
⇢ Ukufa
           
I-⇢ Data Backup

⇢ Data Recovery

⇢ Iyini uhlelo lokuphathwa kwedatha?

⇢ Ngubani osebenzisana ne-DBMS?

⇢ Izingxenye zesistimu yedatha

⇢ Imiqondo Eyisisekelo Yokusetha

Amamodeli Emininingwane Ye-DBMS ye-DBMS

⇢ Database Keys

⇢ Iyini Ifomu Lokuqala Elivamile (1NF)?

⇢ Iyini ifomu lesibili elijwayelekile?

Ifomu le-Third Normal (3NF)

Ifomu le-⇢ Boyce-Codd ejwayelekile (i-BCNF)

Ifomu le-Fourth Normal (4NF)

⇢ ukudala umyalo

Umyalo we-⇢ we-ALTER

⇢ I-Truncate, Yehlisa noma Qamba kabusha iThebula

⇢ BHEKA umyalo we-SQL

⇢ UPDATE umyalo we-SQL

⇢ Phuma umyalo we-SQL

Imiyalo ye-⇢ Commit, i-Rollback ne-Savepoint SQL

⇢ UKUHLOLA bese u-REVOKE

⇢ Khetha ukhetho lwe-SQL

⇢ LAPHO isigatshana se-SQL

⇢ SQL NJENGESIGABA

⇢ UMTHETHO NGOMTHETHO

⇢ Group By Isigaba

⇢ OKUNYE isigatshana

⇢ DISTINCT igama elingukhiye

⇢ NO & OR opharetha

⇢ Division Operator ku-SQL

Izingqinamba ze-⇢ SQL

⇢ Iyini Imisebenzi ye-SQL?

⇢ Imisebenzi ye-Scalar

⇢ SQL Alias ​​- njengegama elingukhiye

⇢ SET Ukusebenza ku-SQL

⇢ Kuyini ukulandelana kwe-SQL?

⇢ SQL VIEW

Yini entsha

App contents re-structured
How to Section added
Design Improvements