Antaraatma Posted August 2, 2011 Report Posted August 2, 2011 [quote author=galigannarao link=topic=219396.msg2702785#msg2702785 date=1312299456]2NFEach attribute must be functionally dependent on the primary key. Functional dependence - the property of one or more attributes that uniquely determines the value of other attributes. Any non-dependent attributes are moved into a smaller (subset) table.2NF improves data integrity.[/quote] @gr33d @gr33d *=:
Ranga_The_Donga Posted August 2, 2011 Report Posted August 2, 2011 [quote author=jamesbond link=topic=219396.msg2702782#msg2702782 date=1312299434]idanta soothante bayam estundi baa's..... Nenu maa bengalooru pothaa edanna sinna udyogam seskunta le &D_@@ &D_@@vammo endi idanta...... &*B@ &*B@[/quote]take it slow ba.....e forms evaru patinchukonu avsaram ledhu.......database architect is de responsible person.....
galigannarao Posted August 2, 2011 Author Report Posted August 2, 2011 3NFRemove transitive dependencies. Transitive dependence - two separate entities exist within one table. Any transitive dependencies are moved into a smaller (subset) table.3NF further improves data integrity. Prevents update, insert, and delete anomalies
charygaru Posted August 2, 2011 Report Posted August 2, 2011 asalu ee normal forms ante endo deni gurinchi matladuku ntunnaro mukk kuda ardham aythaldu naaku !q# !q# !q# !q# !q# !q#
ronitreddy Posted August 2, 2011 Report Posted August 2, 2011 [quote author=galigannarao link=topic=219396.msg2702785#msg2702785 date=1312299456]2NFEach attribute must be functionally dependent on the primary key. Functional dependence - the property of one or more attributes that uniquely determines the value of other attributes. Any non-dependent attributes are moved into a smaller (subset) table.2NF improves data integrity.[/quote]idedo google sesina telusthadi kada..koncham tech terms use cheyakunda layman terms lo chepochu kada.. H&*() H&*()
Antaraatma Posted August 2, 2011 Report Posted August 2, 2011 [quote author=galigannarao link=topic=219396.msg2702796#msg2702796 date=1312299509]3NFRemove transitive dependencies. Transitive dependence - two separate entities exist within one table. Any transitive dependencies are moved into a smaller (subset) table.3NF further improves data integrity. Prevents update, insert, and delete anomalies[/quote]2NF and 3NF almost same kada baa... sCo_^Y sCo_^Y naaku epudu confusion untadi renditlo.. sSa_j@il
manoghna Posted August 2, 2011 Report Posted August 2, 2011 [quote author=ronitreddy link=topic=219396.msg2702788#msg2702788 date=1312299473]oka sql query ni ela tune chestharo kuda cheppandi koncham..performance tune chestharu kada explain plan ala use chesi..dani mida kuda koncham information provide cheyandi plssss..[/quote] NOrmals forms aipoina tarvatha ..we can discuss Performance tuning... bcos Normalisation ardhamithe then denormalisation ardhamavuthundhi which is a performance tuning
Ranga_The_Donga Posted August 2, 2011 Report Posted August 2, 2011 [quote author=charygaru link=topic=219396.msg2702802#msg2702802 date=1312299554]asalu ee normal forms ante endo deni gurinchi matladuku ntunnaro mukk kuda ardham aythaldu naaku !q# !q# !q# !q# !q# !q#[/quote]fresh ga DATABASE create cheyali ante.........e forms mindlo pettukoni cheyali...adhi anamata.......
galigannarao Posted August 2, 2011 Author Report Posted August 2, 2011 [quote author=charygaru link=topic=219396.msg2702802#msg2702802 date=1312299554]asalu ee normal forms ante endo deni gurinchi matladuku ntunnaro mukk kuda ardham aythaldu naaku !q# !q# !q# !q# !q# !q#[/quote]NormalizationA logical design method which minimizes data redundancy and reduces design flaws.Consists of applying various “normal” forms to the database design.The normal forms break down large tables into smaller subsets.
manoghna Posted August 2, 2011 Report Posted August 2, 2011 [quote author=Jeedeelu link=topic=219396.msg2702776#msg2702776 date=1312299377]\dependency in a single table elimanate chesi.......rendo table create chestaru antunna......[/quote] got it ...
ladysfinger Posted August 2, 2011 Report Posted August 2, 2011 Bangalore aa baa needi sCo_^Y [quote author=jamesbond link=topic=219396.msg2702782#msg2702782 date=1312299434]idanta soothante bayam estundi baa's..... Nenu maa bengalooru pothaa edanna sinna udyogam seskunta le &D_@@ &D_@@vammo endi idanta...... &*B@ &*B@[/quote]
Ranga_The_Donga Posted August 2, 2011 Report Posted August 2, 2011 [quote author=galigannarao link=topic=219396.msg2702812#msg2702812 date=1312299624]NormalizationA logical design method which minimizes data redundancy and reduces design flaws.Consists of applying various “normal” forms to the database design.The normal forms break down large tables into smaller subsets.[/quote]naku 3NF example kavali........ardam kala..... cry@fl cry@fl cry@fl2NF and 3NF mostly same ga vunnayi....
jamesbond Posted August 2, 2011 Report Posted August 2, 2011 [quote author=Jeedeelu link=topic=219396.msg2702795#msg2702795 date=1312299504]take it slow ba.....e forms evaru patinchukonu avsaram ledhu.......database architect is de responsible person.....[/quote]yeah ade anukuntanna.... I never came across these Probably database developer use chestaaremo... memedo chinna analyst lam @3$%
galigannarao Posted August 2, 2011 Author Report Posted August 2, 2011 [quote author=ronitreddy link=topic=219396.msg2702807#msg2702807 date=1312299590]idedo google sesina telusthadi kada..koncham tech terms use cheyakunda layman terms lo chepochu kada.. H&*() H&*()[/quote]sare ayte kasuko
jamesbond Posted August 2, 2011 Report Posted August 2, 2011 [quote author=Luv Guru link=topic=219396.msg2702826#msg2702826 date=1312299743]Bangalore aa baa needi sCo_^Y[/quote]namma Bengalooru huduga :P
Recommended Posts