Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is One to Many Relationship?

Answer Posted / dips

In a one-to-many relationship, each row in the related to
table can be related to many rows in the relating table.
This allows frequently used information to be saved only
once in a table and referenced many times in all other
tables. In a one-to-many relationship between Table A and
Table B, each row in Table A is linked to 0, 1 or many rows
in Table B. The number of rows in Table A is almost always
less than the number of rows in Table B.

example:
authors table
============
author_id (primary key)
lastname
firstname
book_id (foreign key - link to book_id of books table)


books table
===========
book_id (primary key)
title


author_id lastname firstname -> book_id title
--------- -------- --------- -> ------- ------
0001 henry john -> 0001 a database
primer
0002 building
datawarehouse
0003 teach
yourself sql
0002 johnson mary -> 0004 101 exotic
recipes
0003 bailey harry -> 0005 visiting
europe
0004 smith adam

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you start weblogic on unix?

835


Explain what are the status available in peoplesoft domain status menu?

907


Explain ren server?

846


How can you launch configuration manager?

865


Differentiate between rowclass and rowset?

935


Explain recycling the server processes.

905


Tell us about application server tuning.

829


What are the uses of psstatus table?

868


What are peopletools utilities?

804


Can we install two different peopletools version on same machine ie client, if yes , what oracle configuration should be installed?

863


How would you set up table-sharing in peopletools applications?

785


Suppose you want to update your password and enter a hint for forgotten password. What would you access?

821


DB is in windows, application server can be configured in Windows or Unix or Anyone?

2106


Explain how to login into bs mode?

939


What are the valid values in peoplecode debugger?

926