One-to-many relationship, Database Management System

For each 1: n relationship type R involving two entities E1 and E2, we recognize the entity type (say E1) at the n-side of the relationship type R and contain primary key of the entity on the other side of the relation (say E2) as a foreign key attribute in the table of E1. We contain all easy attributes (or easy components of a composite attributes of R (if any) in the table of E1).

For example, the works_in relationship among the DEPARTMENT and FACULTY.

For this relationship choose the entity at N side, i.e., FACULTY and add primary key attribute of one more entity DEPARTMENT, i.e., DNO as a foreign key attribute in FACULTY.

FACULTY (CONTAINS WORKS_IN RELATIONSHIP

ID

NAME

ADDRESS

BASIC_SAL

DNO

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Posted Date: 3/6/2013 6:27:08 AM | Location : United States







Related Discussions:- One-to-many relationship, Assignment Help, Ask Question on One-to-many relationship, Get Answer, Expert's Help, One-to-many relationship Discussions

Write discussion on One-to-many relationship
Your posts are moderated
Related Questions
What is object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.

Evaluate, compare and contrast the two methods of relational database design namely top down method and Bottom up method. What will be your choice if you are asked to select a meth


Draw an ER diagram that represents the information described below. Show all entity sets, relationship sets, primary keys, and the mapping cardinality of the relationship sets.

Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t

Produce a set of relations (equivalent to the Finkelstein entity list) in third normal form (3NF) from the following un-normalised relation. You must use the Finkelstein methodolog

er diagtram for icici

What is association? Give an example of association Association is used for establishing relationships among classes. Association describe links among/between classes. For exa

What are shortcomings in structured approach? Structured methodology treats data and their behaviours separately, and this makes it harder to isolate changes. If changes are re

The database depicted in the Visio diagram describes Proceeding , Article , Researcher , article PublishedIn a proceeding, article WrittenBy researchers and proceedings Edi