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

Compare the Nested-loop join and block-nested loop join Ans: Nested  loop join - It is costly as worst case cost, no. of block accesses needed is n r * b s + b r   where b

Define Specialisation and generalization in brief? Specialisation / generalization: Generalization or Specialization represents the is a relationship set, an necessary element

Modify a sequence: ALTER SEQUENCE SEQSS INCREMENT 2 MAXVALUE 3000;   Removing a sequence: DROP SEQUENCE SEQSS;

These are interactive interfaces, graphical that hide the difficulty of the DBMS and query language behind an intuitive, simple to understand, and convenient interface. This permit

Explain the ACID properties of a transaction Ans: ACID properties are a significant concept for databases. The ACID stands for Atomicity, Consistency, Isolation, and Durability

Hi is anyone well versed in accounting information systems available now to help me work through an important assignment due tomorrow at noon?

i have a homework assignment identical to one you have listed

What is a relationship called when it is maintained between two entities? A relationship is called Binary relationship when it is maintained between two entities.

Benefits of Sequential File Organisation It is quick and efficient when dealing with huge volumes of data that require being processed periodically (batch system). Dra