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:














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
Define the Boyce-Codd Normal Form with instance and also Compare BCNF and 3NF.  Ans: BCNF: For each functional dependency X->Y in a set F of functional dependencies over relati

How can i turn a conceptual entity relationship diagram into a logical entity relationship diagram? what do i have to do with "mandetory or" and "optional or" relationships?

#questiontypes of keys examples..

What is primary Key Explain? Primary Key - Primary key is one of the candidate keys. It should be selected such in which its attribute values are never, or very rarely, chang

Server Control It is usual to control access to the data via the front end application, for example by displaying data as ‘read only'. This part of the assignment illustrates ho

What are the disadvantages of file processing system? The drawbacks of file processing systems are a) Data redundancy and inconsistency b) Complexity in accessing data

what is lossless & dependency preserving decomposition ?

what should be included in this???

What is indexed sequential file organization? What are the applications of this organization?  Ans: An index file can be employed to effectively overcome the problem of storing