Cov txheej txheem:

Dab tsi ua rau Rdbms kev sib raug zoo '?
Dab tsi ua rau Rdbms kev sib raug zoo '?

Video: Dab tsi ua rau Rdbms kev sib raug zoo '?

Video: Dab tsi ua rau Rdbms kev sib raug zoo '?
Video: Lec 4: Functional dependency in DBMS | What is functional dependency | Database Management System 2024, Kaum ib hlis
Anonim

A kev sib txheeb database hais txog cov ntaub ntawv uas khaws cov ntaub ntawv hauv cov qauv tsim, siv cov kab thiab kab. Qhov no ua nws yooj yim mus nrhiav thiab nkag tau tej yam tseem ceeb nyob rau hauv lub database. Nws yog " kev sib raug zoo "vim cov txiaj ntsig hauv ib lub rooj muaj feem cuam tshuam rau ib leeg. Cov lus kuj tseem muaj feem cuam tshuam nrog cov ntxhuav.

Ib yam li ib tug yuav nug, qhov kev sib raug zoo txhais li cas hauv kev sib raug zoo database?

A kev sib txheeb database yog ib txheej ntawm cov lus piav qhia los ntawm qhov twg cov ntaub ntawv tuaj yeem nkag tau lossis rov tsim kho hauv ntau txoj kev sib txawv yam tsis tas yuav hloov kho lub database rooj. Tus txheej txheem neeg siv thiab applicationprogramming interface (API) ntawm a kev sib txheeb database yog tus qauv lus nug lus (SQL).

Ib tug kuj yuav nug, dab tsi yog lub hom phiaj ntawm kev sib raug zoo database? Yuav ua li cas Relational Databases Ua haujlwm. Cov haujlwm tseem ceeb ntawm DBMS yog nyeem (saib cov ntaub ntawv ntawm cov lus nug), tsim (ntxiv cov ntaub ntawv, rooj, kab, lossis kab), hloov tshiab (hloov cov ntaub ntawv, rooj, kab, lossis kab), thiab tshem tawm cov ntaub ntawv. Cov xwm txheej tuaj yeem raug ntxiv ua haujlwm ntxiv xws li hauv qab no: Saib cov ntaub ntawv uas ua tau raws li cov txheej txheem

Kuj kom paub yog, Rdbms cov ntsiab lus yog dab tsi?

RDBMS Cov Ntsiab Lus

  • Rooj. Ib lub rooj yog ib phau ntawm cov ntaub ntawv sawv cev hauv kab thiab kab.
  • Sau los yog Tuple. Txhua kab ntawm ib lub rooj yog hu ua cov ntaub ntawv.
  • Field lossis Kem lub npe lossis tus cwj pwm. Cov lus saum toj no “STUDENT” muaj plaub qhov chaw (lossis tus cwj pwm): Student_Id, Student_Name, Student_Addr & Student_Age.
  • Domain.
  • Piv txwv thiab Schema.
  • Cov yuam sij.

Excel puas yog cov ntaub ntawv sib raug zoo?

Excel cov lub koom haum qauv qiv nws tus kheej zoo li cas databases ua haujlwm. Ib daim ntawv qhia, ib leeg, yog a database , tab sis tsis yog a kev sib raug zoo ib. Cov Relationaldatabase yog ib qho kev sib txuas ntawm Master spreadsheet table and all of its Slave tables or spreadsheets.

Pom zoo: