PeopleSoft Administration Question:

Download Job Interview Questions and Answers PDF

What is One to Many Relationship?

PeopleSoft Administration Interview Question
PeopleSoft Administration Interview Question

Answer:

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

Download PeopleSoft Administration Interview Questions And Answers PDF

Previous QuestionNext Question
Given ma a SQL Statement, if you have been asked to check the right syntax?A Customer wants to use a new Image in HRMS, where it is stored?