GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Career Advice  >  Projects
Go To First  |  Previous Question  |  Next Question 
 Projects  |  Question 5 of 23    Print  
1) What is meant by JOINT DEPENDENCY in NORMALIZATION? Give Details.

2) What is a MULTIVALUED DEPENDENCY? Explain.

  
Total Answers and Comments: 1 Last Update: December 29, 2006     Asked by: fenum 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
December 29, 2006 10:56:15   #1  
sravan        

RE: 1) What is meant by JOINT DEPENDENCY in NORMALIZAT...
u see.....joint dependency means that.........when u decompose tables those decomposed table should satisfy JOIN dependency ...ie., when they are joined they should make the original table without any conflicts.......MULTIVALUED DEPENDENCIES means the fourth normal form.......when a table is in such a way that t1(a)=t2(a)=t3(a)=t4(a);t1(b)=t2(b) and t3(b)=t3(4);t1(c)=t3(c) and t2(c)=t4(c);this can be decomposed again with the 4th normal form.....
 
Is this answer useful? Yes | No

 Related Questions


 Sponsored Links

 
Related Articles

What is Data Normalization

Data Normalization is a process to develop the conceptual schema from the external schema.  In its very essence, data normalization is the process of organizing data inside the database in order to remove data redundancy. The presence of many redundant data can have very undesirable results
 

ASP.NET DataBound Controls - Details View

ASP NET 2 0 Free Tutorials DataBound Controls Details View In this tutorial you will learn DetailView DataBound Control To create a file system Web site Connecting to SQL Server Use a Drop Down List as the Master and To test the drop down list mosgoogle The DetailsView is a control that is complemen
 

Tutorial 69: MSAS - Browsing the Dependency Network

The predictive model of the decision tree helps users determine whether similar cases will have a similar behavior The attributes of the tree can be examined for impact analysis by using the Dependency Network Browser This can be opened by right clicking on a decision tree data mining model in the A
 

SQL Server 2000 Training Details

We are glad to let you know that we have started SQL Server 2000 training series See the topics below which we will be providing the tutorials Please let us know if there anything you would like to add to the topics SQL Server 2000 Training mosgoogle 1 Introduction to Microsoft SQL Server 2000 Overv
 

Oracle Developer Exam Details

Test code Test Name Status Number of Questions Passing Score Time 1Z0 001 SQL and PL SQL Expired July 2001 60 640 800 90 minutes 1Z0 101 Developer PL SQL Program Units Expired July 2001 57 7 are ungraded 620 800 90 mi Category Certification
 

Oracle DBA Certification Exam Details

Oracle DBA Certification Exam Details Oracle8 8i 1Z0 020 Oracle8 i New Features 8 0 to 8i upgrade Active 90 minutes Oracle8i 1Z0 001 SQL and PL SQL same as for Oracle7 Active 39 57 68 90 minutes Oracle8i 1Z0 023 Oracl Category Certification
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape