{"id":69013,"date":"2021-08-10T04:10:04","date_gmt":"2021-08-10T08:10:04","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/normalization-in-relational-dbms-systems-6\/"},"modified":"2021-08-10T04:10:04","modified_gmt":"2021-08-10T08:10:04","slug":"normalization-in-relational-dbms-systems-6","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=69013","title":{"rendered":"Normalization in Relational DBMS Systems #6"},"content":{"rendered":"<pre>First Normal Form:All table columns should have distinct meaningIn another word: All attributes of an entity\/table must be uniqueSolution: Grow the table row wise[in the direction of rows] not the column wiseGroup the columns with same meaning into oneTo handle multiple values for the same attribute of an entity create multiple rows [not multiple columns]To keep track of paycheques, you may think the table should be as follows:Name, provider company, date 1, pay cheque 1, date2 , pay cheque 2, date 3, paycheque 3See date1, date2, and date 3 have the same meaningPay cheque 1, Pay cheque 2, and Pay cheque 3 have the same meaningThese are the repeating attributesSolution:create table with:number name, company, date,   paycheque100    1,    xyz,      12\/13,  1000.00100    1,    abc,      12\/13,  1000.00100    1,    xyz,      12\/31,  1000.00or create a child entity with Date and amount. And a master entity with number, Name and CompanyEntity one: number, name, companyEntity two: number, date, amount2nd Normal form:----------------Rule: All attributes can be identified from the primary key. Primary key is directly related to all other attributes.All attributes are fully dependent on the primary key.Line Item Table\/Entity:--------------------number [line item] [pk]order number[pk]vendor namevendor townproduct codeproduct amountHere, vendor name and vendor town may not be fully dependent on the whole primary key. They are dependent on the order number.So we can decompose it into another table.Order entityNumber [pk]Vendor NameVendor TownLineitem entitynumber [pk]order_number [pk]product codeproduct amount3rd normal form-----------------Rule: Non key attributes are fully dependent on the primary key but not on any other key or attribute.In Order entity table, vendor town is not fully dependent on number[pk], but it does depend on the vendor name. So we can decompose order entity table into twoVendor EntityName [pk]TownOrder EntityNumbervendor-name<\/pre>\n<p>From: http:\/\/sitestree.com\/?p=4761<br \/> Categories:6<br \/>Tags:<br \/> Post Data:2013-04-30 16:31:25<\/p>\n<pre><code>    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\"&gt;https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    (Big Data, Cloud, Security, Machine Learning): Courses: &lt;a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"&gt; http:\/\/Training.SitesTree.com&lt;\/a&gt; \n    In Bengali: &lt;a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\"&gt;http:\/\/Bangla.SaLearningSchool.com&lt;\/a&gt;\n    &lt;a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\"&gt;http:\/\/SitesTree.com&lt;\/a&gt;\n    8112223 Canada Inc.\/JustEtc: &lt;a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\"&gt;http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) &lt;\/a&gt;\n    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com'&gt; https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    Medium: &lt;a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"&gt; https:\/\/medium.com\/@SayedAhmedCanada &lt;\/a&gt;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>First Normal Form:All table columns should have distinct meaningIn another word: All attributes of an entity\/table must be uniqueSolution: Grow the table row wise[in the direction of rows] not the column wiseGroup the columns with same meaning into oneTo handle multiple values for the same attribute of an entity create multiple rows [not multiple columns]To &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=69013\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-69013","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69266,"url":"http:\/\/bangla.sitestree.com\/?p=69266","url_meta":{"origin":69013,"position":0},"title":"SQL Server: Index #38","author":"Author-Check- Article-or-Video","date":"August 16, 2021","format":false,"excerpt":"SQL Server: Index Indexes make database access faster. Without index your queries will run but indexes can increase the performance dramatically. You can define multiple indexes for a table and select the index that is required for current operations. Only one clustered index is supported for a table To get\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10269,"url":"http:\/\/bangla.sitestree.com\/?p=10269","url_meta":{"origin":69013,"position":1},"title":"JTable Examples","author":"","date":"August 26, 2015","format":false,"excerpt":"# JTableSimpleExample.java Simple table that takes column names and data from arrays of Strings. import java.awt.*; import javax.swing.*; \/** Simple JTable example that uses a String array for the \u00a0*\u00a0 table header and table data. \u00a0* \u00a0*\/ public class JTableSimpleExample extends JFrame { \u00a0 public static void main(String[] args) {\u2026","rel":"","context":"In &quot;Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8&quot;","block_context":{"text":"Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8","link":"http:\/\/bangla.sitestree.com\/?cat=1417"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69123,"url":"http:\/\/bangla.sitestree.com\/?p=69123","url_meta":{"origin":69013,"position":2},"title":"Hibernate: A simple example #48","author":"Author-Check- Article-or-Video","date":"August 12, 2021","format":false,"excerpt":"Hibernate: A simple example First, you need to create an xml file to specify the database parameters that you are going to use. Database parameters may include: the database driver, user name and password to access the database. Then you should create a persistent class to represent the database table.\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27192,"url":"http:\/\/bangla.sitestree.com\/?p=27192","url_meta":{"origin":69013,"position":3},"title":"JTable Examples #Programming Code Examples #Java\/J2EE\/J2ME #Advanced Swing","author":"Author-Check- Article-or-Video","date":"May 13, 2021","format":false,"excerpt":"# JTableSimpleExample.java Simple table that takes column names and data from arrays of Strings. import java.awt.*; import javax.swing.*; \/** Simple JTable example that uses a String array for the * table header and table data. * *\/ public class JTableSimpleExample extends JFrame { public static void main(String[] args) { new\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10113,"url":"http:\/\/bangla.sitestree.com\/?p=10113","url_meta":{"origin":69013,"position":4},"title":"DatabaseUtilities.java: Several general-purpose utilities discussed and used in the chapter.","author":"","date":"August 4, 2015","format":false,"excerpt":"package cwp; import java.sql.*; \/** Three database utilities: \u00a0*\u00a0\u00a0 1) getQueryResults. Connects to a database, executes \u00a0*\u00a0\u00a0\u00a0\u00a0\u00a0 a query, retrieves all the rows as arrays \u00a0*\u00a0\u00a0\u00a0\u00a0\u00a0 of strings, and puts them inside a DBResults \u00a0*\u00a0\u00a0\u00a0\u00a0\u00a0 object. Also places the database product name, \u00a0*\u00a0\u00a0\u00a0\u00a0\u00a0 database version, and the names of all\u2026","rel":"","context":"In &quot;Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8&quot;","block_context":{"text":"Code . Programming Samples . \u09aa\u09cd\u09b0\u09cb\u0997\u09cd\u09b0\u09be\u09ae \u0989\u09a6\u09be\u09b9\u09b0\u09a8","link":"http:\/\/bangla.sitestree.com\/?cat=1417"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69412,"url":"http:\/\/bangla.sitestree.com\/?p=69412","url_meta":{"origin":69013,"position":5},"title":"Comparison: FireBird, MySQL, PostGreSQL #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"PosTGRESQL Provides better query responsetime than firebird and MySql. Firebird stands somewhere in the middle. A little longer response time than PostGreSql.http:\/\/benchw.sourceforge.net\/benchw_results_open3.html Several PostGreSQL versions are compared at:http:\/\/benchw.sourceforge.net\/benchw_results_postgres_history.html Several MySQL versions are compared at:http:\/\/benchw.sourceforge.net\/benchw_results_mysql_indexes.html A good comparison among these databases will be found at:http:\/\/www.geocities.com\/mailsoftware42\/db\/ Mentionable comments PostGreSQL Supports 400+GB DB.One\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69013","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69013"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69013\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69013"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}