{"id":9424,"date":"2026-06-02T10:08:28","date_gmt":"2026-06-02T08:08:28","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&#038;p=9424"},"modified":"2026-06-02T10:08:29","modified_gmt":"2026-06-02T08:08:29","slug":"cum-functioneaza-o-baza-de-date-relationala","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-does-a-relational-database-work\/","title":{"rendered":"Cum func\u021bioneaz\u0103 o baz\u0103 de date rela\u021bional\u0103?"},"content":{"rendered":"<div class=\"translation-block translation-block-merged\">\n<p class=\"wp-block-paragraph\">O baz\u0103 de date rela\u021bional\u0103 stocheaz\u0103 datele \u00een tabele care con\u021bin r\u00e2nduri \u0219i coloane. Aceast\u0103 structur\u0103 faciliteaz\u0103 organizarea, c\u0103utarea \u0219i gestionarea informa\u021biilor corelate.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fiecare tabel reprezint\u0103 un tip specific de date, cum ar fi clien\u021bii, produsele sau comenzile.<\/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\/how-does-a-relational-database-work\/#Tables_Rows_and_Columns\">Tabele, r\u00e2nduri \u0219i coloane<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-does-a-relational-database-work\/#Rela\u021bii_\u00eentre_tabele\">Rela\u021bii \u00eentre tabele<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-does-a-relational-database-work\/#Using_SQL_to_Access_Data\">Utilizarea SQL pentru accesarea datelor<\/a><\/li><li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-does-a-relational-database-work\/#Data_Integrity\">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-5\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-does-a-relational-database-work\/#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-6\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/cum-func\u021bioneaz\u0103-o-baz\u0103-de-date-rela\u021bional\u0103\/#Integritatea_referen\u021bial\u0103\">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-7\" href=\"https:\/\/mybox.com\/help\/ro\/knowledgebase\/how-does-a-relational-database-work\/#Benefits_of_the_Relational_Model\">Avantajele modelului rela\u021bional<\/a><\/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\/how-does-a-relational-database-work\/#Summary\">Rezumat<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Tables_Rows_and_Columns\"><\/span>Tabele, r\u00e2nduri \u0219i coloane<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<\/div>\n\n<div id=\"mybox-882984944\" 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<ul class=\"wp-block-list\">\n<li>Coloanele definesc atributele sau propriet\u0103\u021bile datelor.<\/li>\n\n\n\n<li>R\u00e2ndurile con\u021bin \u00eenregistr\u0103ri individuale.<\/li>\n\n\n\n<li>Fiecare \u00eenregistrare este identificat\u0103 \u00een mod unic printr-o cheie, denumit\u0103 de obicei cheie primar\u0103.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">De exemplu, un tabel de clien\u021bi ar putea con\u021bine:<\/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><\/tr><\/thead><tbody><tr><td>1001<\/td><td>John Smith<\/td><td><a>john@example.com<\/a><\/td><\/tr><tr><td>1002<\/td><td>Jane Doe<\/td><td><a>jane@example.com<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u00cen acest exemplu:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>ID-ul clientului<\/code> este cheia primar\u0103.<\/li>\n\n\n\n<li>Fiecare r\u00e2nd reprezint\u0103 un client unic.<\/li>\n\n\n\n<li>Fiecare coloan\u0103 stocheaz\u0103 un atribut specific al respectivului client.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Relationships_Between_Tables\"><\/span>Rela\u021biile dintre tabele<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Bazele de date rela\u021bionale conecteaz\u0103 informa\u021biile corelate folosind chei.<\/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 \"Comenzi\"<\/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 leag\u0103 comanda de clientul din tabelul Clien\u021bi. Aceast\u0103 rela\u021bie permite conectarea datelor f\u0103r\u0103 duplicarea informa\u021biilor.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Utilizarea_SQL_pentru_accesarea_datelor\"><\/span>Utilizarea SQL pentru accesarea datelor<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Bazele de date rela\u021bionale sunt gestionate de obicei folosind SQL (Structured Query Language).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">SQL permite utilizatorilor \u0219i aplica\u021biilor s\u0103:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>S\u0103 extrag\u0103 date<\/li>\n\n\n\n<li>S\u0103 adauge \u00eenregistr\u0103ri noi<\/li>\n\n\n\n<li>S\u0103 actualizeze informa\u021biile existente<\/li>\n\n\n\n<li>S\u0103 \u0219tearg\u0103 \u00eenregistr\u0103ri<\/li>\n\n\n\n<li>S\u0103 genereze rapoarte<\/li>\n\n\n\n<li>S\u0103 gestioneze structura bazei de date<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">De exemplu, o interogare SQL simpl\u0103 poate prelua to\u021bi clien\u021bii:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM customers;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Sau s\u0103 afi\u0219eze toate comenzile plasate de un anumit client:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT * FROM orders<br>WHERE customer_id = 1001;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Data_Integrity\"><\/span>Integritatea 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 \u00eencorporate pentru a asigura c\u0103 datele r\u0103m\u00e2n corecte \u0219i consecvente.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Printre regulile comune de integritate se num\u0103r\u0103:<\/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<ul class=\"wp-block-list\">\n<li>Fiecare tabel trebuie s\u0103 aib\u0103 o cheie primar\u0103.<\/li>\n\n\n\n<li>Valorile cheii primare trebuie s\u0103 fie unice.<\/li>\n\n\n\n<li>Valorile cheii primare nu pot fi goale (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<ul class=\"wp-block-list\">\n<li>Valorile cheilor externe trebuie s\u0103 corespund\u0103 unor \u00eenregistr\u0103ri valide din tabelele asociate.<\/li>\n\n\n\n<li>Rela\u021biile dintre tabele r\u0103m\u00e2n consecvente.<\/li>\n\n\n\n<li>Se previne apari\u021bia \u00eenregistr\u0103rilor nevalide sau orfane.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Benefits_of_the_Relational_Model\"><\/span>Avantajele modelului rela\u021bional<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Deoarece datele sunt organizate \u00een tabele corelate, bazele de date rela\u021bionale ofer\u0103:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Stocare eficient\u0103 a datelor<\/li>\n\n\n\n<li>Reducerea duplic\u0103rii datelor<\/li>\n\n\n\n<li>Interog\u0103ri \u0219i generarea de rapoarte rapide<\/li>\n\n\n\n<li>Gestionarea consecvent\u0103 a datelor<\/li>\n\n\n\n<li>Securitate puternic\u0103 \u0219i controale de acces<\/li>\n\n\n\n<li>Rela\u021bii fiabile \u00eentre seturile de date<\/li>\n<\/ul>\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\">O baz\u0103 de date rela\u021bional\u0103 func\u021bioneaz\u0103 prin stocarea datelor \u00een tabele structurate, conectate prin rela\u021bii. Fiecare \u00eenregistrare este identificat\u0103 printr-o cheie unic\u0103, iar limbajul SQL este utilizat pentru gestionarea \u0219i recuperarea informa\u021biilor. Aceast\u0103 abordare ofer\u0103 o modalitate eficient\u0103, fiabil\u0103 \u0219i scalabil\u0103 de stocare \u0219i organizare a datelor pentru site-uri web, aplica\u021bii \u0219i sisteme 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":[585,804,805,1742,5475,5477,5478,5481,5482,5483],"class_list":["post-9424","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-database-tables","manual_kb_tag-relational-database","manual_kb_tag-structured-query-language","manual_kb_tag-data-integrity","manual_kb_tag-relational-model","manual_kb_tag-primary-key","manual_kb_tag-foreign-key","manual_kb_tag-rows-and-columns","manual_kb_tag-referential-integrity","manual_kb_tag-entity-integrity"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/9424","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\/9424\/revisions"}],"predecessor-version":[{"id":9425,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb\/9424\/revisions\/9425"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/media?parent=9424"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manualknowledgebasecat?post=9424"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/ro\/wp-json\/wp\/v2\/manual_kb_tag?post=9424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}