Binary relationships, Database Management System

One-to-one relationship:

For every 1:1 relationship type R in the ER diagram including two entities E1 and E2 we take one of entities (say E1) preferably with total participation and add primary key attribute of one more entity E2 as a foreign key attribute in the table of entity (E1). We will also have all the simple attributes of relationship type R in E1 if any.

For instance, the DEPARTMENT relationship has been extended to contain head-Id and attribute of the relationship. Please note we will maintain information in this table of only present head and Date from which s/he is the head.

There is one Head_of 1:1 relationship among FACULTY and DEPARTMENT. We select DEPARTMENT entity having total participation and add primary key attribute ID of FACULTY entity as a foreign key in DEPARTMENT entity named as Head_ID. Now the DEPARTMENT table will be as follows:

DEPARTMENT

D_NO

D_NAME

Head_ID

Date-from

 

 

 

 

 

 

 

 

Posted Date: 3/6/2013 6:26:41 AM | Location : United States







Related Discussions:- Binary relationships, Assignment Help, Ask Question on Binary relationships, Get Answer, Expert's Help, Binary relationships Discussions

Write discussion on Binary relationships
Your posts are moderated
Related Questions
Explain the dependency relationship of object oriented A dependency is a relationship which states that a change in specification of one thing can affect another thing, but n

What is database Trigger? A database trigger is a PL/SQL block that can explained to automatically execute for insert, update, and delete statements against a table. The trigge

1. Identify the comparisons and exchanges made to sort the following array using the selection exchange sort technique. Note: you may not need all columns. Ori

In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.

Short Note on mid Square Method of hashing? Mid square method of hashing: In the method midsquare hashing, the key is squared and the address selected from the center of the s

Why are cursors necessary in embedded SQL? A cursor is an object used to store the output of a query for row-by-row processing through the application programs. SQL statements

What is property - properties of a database ? It is an integrated collection of logically related records. It consolidates separate files into a common pool of data records and

Give two profit of Reuse of Code. Reusing the implementation . Place existing class directly inside a new class. The new class can be made up of any number and type of the oth

The definition of the classes and operation can often be adjusted to increase the amount of inheritance". Justify the above statement.   Adjustment of Inheritance The def

Define two-phase locking protocol. Ans: Two-phase locking is significance in the context of ensuring that schedules are serializable. The two-phase locking protocol defines a p