Table handling, Database Management System

Table Handling

 In RDBMS more than one table can be tackled at a time by using join operation. Join operation is a relational operation that causes 2 tables with a common domain to be joined into a single table or view. SQL states a join implicitly by referring the matching of common columns over which tables are connected in a WHERE clause. Two tables may be connected when each haves a column that shares a common domain with the other. The result of join operation is to be called a single table. Selected columns from all the tables are contained. Every row returned contains data from rows in the dissimilar input tables where values for the common columns match. A vital rule of table handling is that there should be one condition within the WHERE clause for every pair of tables being joined. Therefore if two tables are to be combined, one condition would be essential, but if three tables (X, Y, Z) are to be combined then two conditions would be necessary because there are two pairs of tables (X-Y and Y-Z) OR (X-Z and Y-Z), and so forth. There are various possible types of joins in relational database queries. Four types of join operations are define below:

 

Posted Date: 3/11/2013 2:34:00 AM | Location : United States







Related Discussions:- Table handling, Assignment Help, Ask Question on Table handling, Get Answer, Expert's Help, Table handling Discussions

Write discussion on Table handling
Your posts are moderated
Related Questions
Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

What is 2NF? A relation schema R is in 2NF if it is in 1NF and every non-prime attribute A in R is fully functionally dependent on primary key.

What is OLAP? OnLine Analytical Processing (OLAP) is a Business Intelligence (BI) reporting system. OLAP gives the user with the capability to sum, count, average and do other

What are the three data anomalies that are similarly to take place as a result of data redundancy?  Can data redundancy be completely eliminated in database approach?  Why or why n

What are the advantages of having an index structure?      Ans: The index structures commonly provide secondary access paths, which offer alternative ways of accessing the reco

Decompose the table with the following description and functional dependencies into a set of equivalent tables normalized to 3NF or BCNF. This database stores records from a (ve

Mention the purpose of SID and SOD lines SID (Serial input data line): It is an input line by which the microprocessor accepts serial data. SOD (Serial output data line)

Question: (a) What do you meant by content management and briefly describe four major components of a Content Management System? (b) Explain key benefits of a Content Manage

What is candidate key? Candidate Key - A candidate key of an entity set is a minimal superkey, which uniquely identifies each row in the relation.

Discuss the count function? The COUNT function used returns the number of tuples or values fixed in a query. The count function comprises two types of syntax: (1) COUNT (*)