What is One to Many Relationship?
Answers were Sorted based on User's Feedback
Answer / ramana
The relationship between a database server and an
application server is a one-to-many model.
That is, a single database server can have multiple
application servers connecting to it.
The database server simultaneously handles the application
server connections, Development Environment connections,
and batch programs running against it.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
What bea product is used for db transaction in peoplesoft?
Name a few third party tools / software required for ps to function.
How will you get a single ouptut by combining two or more queries?
Explain what are the components which form the part of integration broker?
Suppose I have created a menu and a page and given user access to that page, which of the tables gets affected on this?
I want to update my password and enter a hint for forgotten password. What would I access?
You want to authenticate a user in peoplesoft. How would you do that?
You want a single output by comining two or more queries. How would you do that?
Explain the different menu types available.
What is multi server definition in weblogic server?
PS Query definition is stored on which server?
Why do we use weblogic server in peoplesoft?