A schema ndiyo blueprint ye database yakagadzirisa kusangana
A database sedhem is a collection of metadata inorondedzera hukama mu database. Chirongwa chinotsanangurwawo sechinangwa kana blueprint ye database yakarondedzera nzira iyo data yakarongwa mumatafura.
Chirongwa chinowanzotsanangurwa uchishandisa Kurongwa Kwekutsvakurudza Mutauro (SQL) sezvikamu zvakasiyana zvezvinyorwa zve CREATE zvinogona kushandiswa kudzokorora schema mune imwe nheyo ye database.
Nzira iri nyore yekufungidzira schema ndeyekufunga nezvayo sebhokisi rinobata matafura, maitiro akachengeterwa, maonero uye mamwe ose e database iyo yakazara. Mumwe anogona kupa vanhu kupinda mubhokisi, uye umu bhokisi racho rinogona kushandurwa zvakare.
Aina dze Database Schema
Ikoko kune marudzi maviri e database database:
- Nyaya yezvigadzirwa database inopa bhueprint yekuti chikamu chimwe che data chinenge chakachengetwa sei mu database.
- Iyo schema inonzwisisika inopa maitiro kumatafura uye hukama mukati me database. Kazhinji, chirevo chinonzwisisika chinogadzirwa zvisati zvaitika.
Kazhinji, vashandi vekodhidhiyo vanoshandisa data modeling kuti vagadzire database schema inobva pane software ichabatana ne database.