{"id":9422,"date":"2026-06-02T10:07:08","date_gmt":"2026-06-02T08:07:08","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&#038;p=9422"},"modified":"2026-06-02T10:07:09","modified_gmt":"2026-06-02T08:07:09","slug":"care-este-structura-modelului-relational-al-bazei-de-date","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/ro\/knowledgebase\/what-is-the-structure-of-the-relational-database-model\/","title":{"rendered":"Care este structura modelului rela\u021bional al bazei de date?"},"content":{"rendered":"<div class=\"translation-block translation-block-merged\">\n<p class=\"wp-block-paragraph\">Modelul bazei de date rela\u021bionale a fost introdus \u00een 1970 de c\u0103tre Edgar F. Codd. \u00cen lucrarea sa revolu\u021bionar\u0103, acesta a propus organizarea datelor \u00een tabele alc\u0103tuite din r\u00e2nduri \u0219i coloane, \u00een locul utiliz\u0103rii structurilor de date ierarhice sau de navigare.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Aceast\u0103 abordare a devenit fundamentul sistemelor moderne de gestionare a bazelor de date rela\u021bionale (RDBMS).<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Cuprins<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class=\"ez-toc-list ez-toc-list-level-1\"><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/what-is-the-structure-of-the-relational-database-model\/#Basic_Components_of_a_Relational_Database\">Componente de baz\u0103 ale unei baze de date rela\u021bionale<\/a><ul class=\"ez-toc-list-level-3\"><li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/what-is-the-structure-of-the-relational-database-model\/#Tables\">Tabele<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/care-este-structura-modelului-bazei-de-date-rela\u021bionale\/#Chei_primare\">Chei primare<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/what-is-the-structure-of-the-relational-database-model\/#Foreign_Keys\">Chei externe<\/a><\/li><\/ul><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/what-is-the-structure-of-the-relational-database-model\/#Example_of_a_Relational_Database\">Exemplu de baz\u0103 de date rela\u021bional\u0103<\/a><ul class=\"ez-toc-list-level-3\"><li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/what-is-the-structure-of-the-relational-database-model\/#Customers_Table\">Tabelul clien\u021bilor<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/care-este-structura-modelului-bazei-de-date-rela\u021bionale\/#Orders_Table\">Tabelul Comenzi<\/a><\/li><\/ul><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/what-is-the-structure-of-the-relational-database-model\/#Data_Integrity_Rules\">Reguli privind integritatea datelor<\/a><ul class=\"ez-toc-list-level-3\"><li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/what-is-the-structure-of-the-relational-database-model\/#Entity_Integrity\">Integritatea entit\u0103\u021bilor<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/what-is-the-structure-of-the-relational-database-model\/#Referential_Integrity\">Integritatea referen\u021bial\u0103<\/a><\/li><\/ul><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/what-is-the-structure-of-the-relational-database-model\/#Data_Domains_and_Constraints\">Domenii de date \u0219i constr\u00e2ngeri<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/what-is-the-structure-of-the-relational-database-model\/#Physical_Data_Independence\">Independen\u021ba datelor fizice<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/what-is-the-structure-of-the-relational-database-model\/#Logical_Data_Independence\">Independen\u021ba logic\u0103 a datelor<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/what-is-the-structure-of-the-relational-database-model\/#Summary\">Rezumat<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Basic_Components_of_a_Relational_Database\"><\/span>Componente de baz\u0103 ale unei baze de date rela\u021bionale<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<\/div>\n\n<div id=\"mybox-374930311\" class=\"mybox-content mybox-entity-placement\"><div class=\"early-access-banner-inpost\">\r\n  <div class=\"banner-left-inpost\">\r\n    <div class=\"icon-box-inpost\">\r\n      <img decoding=\"async\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2026\/02\/square-info-icon.svg\" alt=\"Info\">\r\n    <\/div>\r\n    <div class=\"text-box-inpost\">\r\n      <span class=\"label-inpost\"><span class=\"translation-block translation-block-banner-text\">Acces timpuriu<\/span><\/span>\r\n      <h4><span class=\"translation-block translation-block-banner-text\">Mai ave\u021bi nevoie de ajutor?<\/span><\/h4>\r\n      <p><span class=\"translation-block translation-block-banner-text\">Contacta\u021bi echipa noastr\u0103 de servicii pentru clien\u021bi.<\/span><\/p>\r\n    <\/div>\r\n  <\/div>\r\n\r\n  <div class=\"banner-right-inpost\">\r\n    <a href=\"https:\/\/panel.mybox.com\/helpdesk2\/v\/list\/\" class=\"banner-button-inpost\"><span class=\"translation-block translation-block-banner-text\">Trimite mesaj<\/span><\/a>\r\n  <\/div>\r\n<\/div><\/div>\n\n<div class=\"translation-block translation-block-merged\"><p class=\"wp-block-paragraph\">O baz\u0103 de date rela\u021bional\u0103 este alc\u0103tuit\u0103 din una sau mai multe tabele.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Tables\"><\/span>Tabele<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Un tabel stocheaz\u0103 un tip specific de informa\u021bii, cum ar fi clien\u021bi, produse sau comenzi.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fiecare tabel este alc\u0103tuit din:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Coloane (atribute) \u2013 definesc tipul de date stocate<\/li>\n\n\n\n<li>R\u00e2nduri (\u00eenregistr\u0103ri) \u2013 con\u021bin intr\u0103ri individuale de date<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">De exemplu, un tabel cu clien\u021bi poate con\u021bine urm\u0103toarele coloane:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>ID client<\/th><th>Nume<\/th><th>E-mail<\/th><th>Num\u0103r de telefon<\/th><\/tr><\/thead><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Fiecare r\u00e2nd reprezint\u0103 un client unic.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Primary_Keys\"><\/span>Chei primare<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Fiecare tabel trebuie s\u0103 con\u021bin\u0103 o cheie primar\u0103.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">O cheie primar\u0103:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Identific\u0103 \u00een mod unic fiecare \u00eenregistrare<\/li>\n\n\n\n<li>Nu poate con\u021bine valori duplicate<\/li>\n\n\n\n<li>Nu poate fi goal\u0103 (NULL)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Exemplu:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>ID client<\/th><th>Nume<\/th><\/tr><\/thead><tbody><tr><td>1001<\/td><td>John Smith<\/td><\/tr><tr><td>1002<\/td><td>Jane Doe<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen acest caz, <code>ID-ul clientului<\/code> este cheia primar\u0103.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Foreign_Keys\"><\/span>Chei externe<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">O cheie extern\u0103 creeaz\u0103 o rela\u021bie \u00eentre dou\u0103 tabele.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Aceasta con\u021bine valori care fac referire la cheia primar\u0103 a unei alte tabele.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">De exemplu:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tabelul Clien\u021bi<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>ID client<\/th><th>Nume<\/th><\/tr><\/thead><tbody><tr><td>1001<\/td><td>John Smith<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Tabelul comenzilor<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>ID comand\u0103<\/th><th>ID client<\/th><th>Produs<\/th><\/tr><\/thead><tbody><tr><td>5001<\/td><td>1001<\/td><td>Laptop<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><code>ID-ul clientului<\/code> din tabelul Comenzi este o cheie extern\u0103 care leag\u0103 comanda de client.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Exemplu_de_baz\u0103_de_date_rela\u021bional\u0103\"><\/span>Exemplu de baz\u0103 de date rela\u021bional\u0103<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">O baz\u0103 de date simpl\u0103 pentru afaceri ar putea con\u021bine:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Customers_Table\"><\/span>Tabelul Clien\u021bi<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>ID client<\/th><th>Nume<\/th><th>E-mail<\/th><\/tr><\/thead><\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Orders_Table\"><\/span>Tabelul comenzilor<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>ID comand\u0103<\/th><th>ID client<\/th><th>Produs<\/th><th>Data comenzii<\/th><\/tr><\/thead><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Folosind aceste rela\u021bii, diferi\u021bi utilizatori pot genera rapoarte diferite pe baza acelora\u0219i date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Exemple:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Un manager de v\u00e2nz\u0103ri poate vizualiza achizi\u021biile clien\u021bilor.<\/li>\n\n\n\n<li>Un manager de contabilitate poate verifica facturile \u0219i pl\u0103\u021bile.<\/li>\n\n\n\n<li>O echip\u0103 de asisten\u021b\u0103 poate accesa informa\u021biile de contact ale clien\u021bilor.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Data_Integrity_Rules\"><\/span>Reguli de integritate a datelor<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Bazele de date rela\u021bionale utilizeaz\u0103 reguli pentru a men\u021bine acurate\u021bea \u0219i coeren\u021ba datelor.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Entity_Integrity\"><\/span>Integritatea entit\u0103\u021bilor<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Integritatea entit\u0103\u021bii asigur\u0103 c\u0103:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Fiecare tabel are o cheie primar\u0103<\/li>\n\n\n\n<li>Valorile cheii primare sunt unice<\/li>\n\n\n\n<li>Valorile cheii primare nu pot fi NULL<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Referential_Integrity\"><\/span>Integritatea referen\u021bial\u0103<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Integritatea referen\u021bial\u0103 asigur\u0103 c\u0103:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Fiecare valoare a cheii str\u0103ine corespunde unei valori existente a cheii primare<\/li>\n\n\n\n<li>Rela\u021biile dintre tabele r\u0103m\u00e2n valabile<\/li>\n\n\n\n<li>Se previne apari\u021bia \u00eenregistr\u0103rilor orfane<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">De exemplu, o comand\u0103 nu poate face referire la un client care nu exist\u0103.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Data_Domains_and_Constraints\"><\/span>Domenii de date \u0219i constr\u00e2ngeri<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">La proiectarea unei baze de date, administratorii pot defini:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tipuri de date permise<\/li>\n\n\n\n<li>Intervale de valori valide<\/li>\n\n\n\n<li>C\u00e2mpuri obligatorii<\/li>\n\n\n\n<li>Reguli de unicitate<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Aceste restric\u021bii contribuie la asigurarea faptului c\u0103 sunt stocate numai date valide.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Physical_Data_Independence\"><\/span>Independen\u021ba fizic\u0103 a datelor<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Independen\u021ba fizic\u0103 a datelor \u00eenseamn\u0103 c\u0103 administratorii bazelor de date pot modifica modul \u00een care datele sunt stocate fizic f\u0103r\u0103 a afecta aplica\u021biile care utilizeaz\u0103 baza de date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Exemple includ:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Schimbarea dispozitivelor de stocare<\/li>\n\n\n\n<li>Ad\u0103ugarea sau modificarea indexurilor<\/li>\n\n\n\n<li>Utilizarea unor structuri de stocare diferite<\/li>\n\n\n\n<li>Modificarea metodelor de organizare a fi\u0219ierelor<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Aplica\u021biile continu\u0103 s\u0103 func\u021bioneze f\u0103r\u0103 modific\u0103ri, deoarece structura logic\u0103 r\u0103m\u00e2ne neschimbat\u0103.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Logical_Data_Independence\"><\/span>Independen\u021ba logic\u0103 a datelor<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Independen\u021ba logic\u0103 a datelor permite modificarea structurii bazei de date f\u0103r\u0103 a fi necesare actualiz\u0103ri ale aplica\u021biilor existente.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Exemple:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ad\u0103ugarea de tabele noi<\/li>\n\n\n\n<li>Ad\u0103ugarea de coloane noi<\/li>\n\n\n\n<li>Crearea de rela\u021bii noi<\/li>\n\n\n\n<li>Eliminarea atributelor neutilizate<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">At\u00e2ta timp c\u00e2t structurile existente r\u0103m\u00e2n compatibile, aplica\u021biile pot continua s\u0103 func\u021bioneze normal.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Summary\"><\/span>Rezumat<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Modelul bazei de date rela\u021bionale organizeaz\u0103 informa\u021biile \u00een tabele conectate prin chei primare \u0219i chei externe. Aceast\u0103 structur\u0103 asigur\u0103 stocarea eficient\u0103 a datelor, coeren\u021ba \u0219i flexibilitatea, permi\u021b\u00e2nd \u00een acela\u0219i timp mai multor utilizatori \u0219i aplica\u021bii s\u0103 acceseze \u0219i s\u0103 gestioneze datele \u00een mod fiabil. Caracteristici precum integritatea datelor, independen\u021ba logic\u0103 \u0219i independen\u021ba fizic\u0103 au f\u0103cut din bazele de date rela\u021bionale fundamentul standard pentru aplica\u021biile moderne de afaceri.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[11500,11493,42,11391,11490],"manual_kb_tag":[5482,5483,5484,5485,5486,585,804,5474,5477,5478],"class_list":["post-9422","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-database-basics-concepts","manualknowledgebasecat-databases-sql","manualknowledgebasecat-miscellaneous","manualknowledgebasecat-databases-mysql","manualknowledgebasecat-developer-resources","manual_kb_tag-referential-integrity","manual_kb_tag-entity-integrity","manual_kb_tag-relational-database-model","manual_kb_tag-database-schema","manual_kb_tag-table-structure","manual_kb_tag-database-tables","manual_kb_tag-relational-database","manual_kb_tag-relational-database-management-system","manual_kb_tag-primary-key","manual_kb_tag-foreign-key"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/9422","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":1,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/9422\/revisions"}],"predecessor-version":[{"id":9423,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/9422\/revisions\/9423"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/media?parent=9422"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manualknowledgebasecat?post=9422"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb_tag?post=9422"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}