Funda ngeSimmas kunye nobudlelwane babo kwiinkcukacha

I-schema yiplani yesiseko sedata eqinisekisa ukuhlelwa

I-schema ye-database iyimqoqo yemethadatha echaza ubudlelwane kwi-database. I-schema iphinda ichazwe njengoluhlobo okanye uluhlu lweenkcukacha ezibonisa indlela idatha ehlelwe ngayo kwiibhile.

I-schema ivame ukuchazwa ngokusetyenziswa koLwimi oluCwangcisiweyo oluCwangcisiweyo (SQL) njengoluhlu lwesitatimende sokudala esingasetyenziselwa ukuphindaphinda i-schema kwisiseko esitsha sedatha.

Indlela elula yokujonga i-schema kukucingela njengebhokisi elithatha amatafula, iinkqubo ezigcinwe, iimbono kunye nazo zonke ezinye iinkcukacha. Omnye unokunika abantu ithuba lokufikelela kwibhokisi, kwaye ubunini bebhokisi bunokutshintshwa kwakhona.

Iintlobo zeShedama yeSiseko

Kukho iintlobo ezimbini zeedayim e-database:

  1. I-schema yolwazi lwezinto ezibonakalayo inikeza isicwangciso sendlela nganye isahlulo sedatha egcinwe ngayo kwi database.
  2. I-schema enengqiqo inika isakhelo kwisetyuli kunye nobudlelwane ngaphakathi ngaphakathi kwedatha. Ngokuqhelekileyo, i-schema enengqiqo idalwe ngaphambi kwesikimu sezinto ezibonakalayo.

Ngokuqhelekileyo, abayili beenkcukacha basebenzisa i-model model ukudala i-schema ye-database esekelwe kwisofthiwe esiza kusebenzisana kunye nedatha.