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
properties of derirable decomposition

What is known as sequential file organization? In the sequential file organization, the records are kept in sequential order, according to the value of a "search key" of every

Explain Record Based Logical Models? Record-Based logical Models: Also define data at the conceptual and view levels. Unlike object-oriented models, are used to state overall

Two Phase Locking (2PL) The two-phase locking protocol having of two phases: Phase 1 : The lock acquisition phase : If a transaction T needs to read an object, it wants to

Discuss the mechanism to read data from and write to a disk? Disk read/write heads are mechanisms in which read data from or write data to disk drives. The heads have gone by

Consider entity type Employee with attributes empNumber (this is unique), empName, and the year when he/she was hired. An employee can either be a technical employee, a marketing e

sir, could anybody help me in getting complete information about the mentioned topic

Differentiate between strict two-phase and rigorous two-phase with conversion protocol Ans:  Strict two-phase locking holds all its exclusive that is write locks until commit t

Give an example of enforcement in Typing. You can understand the idea of enforcement as it makes sure objects of dissimilar classes may not be interchanged as below:  Exampl

A relation has: Relational Schema Relation instance Relational Schema: A relational schema shows the relation's name, its attributes and the domain of every a