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
List the set operations of SQL? 1) Union 2) Intersect operation 3) The except operation

Create role named role_table that allows a user to create tables. Using role_table allow users kripa and reena to create tables. CREATE ROLE role_table; GRANT CREATE ANY TABLE

Explain group By clause in SQL? Group By clause in SQL: The GROUP BY clause can be used in a SELECT statement to collect data across multiple records and group the results thro

What are the various properties of Relational tables? Relational tables have 6 properties: 1. Each row is unique. 2. Column values are of the same kind. 3. Values are

What are the comparison operator in SQL?  Comparison operator in SQL are =, LIKE and BETWEEN

What is the use of a slotted-page structure and what is the information are there in the header? The slotted-page structure is used for organizing records within a one block.


Question: (a) Prepare an ERD for the scenario given below. (b) Convert the ER diagram produced in (a) above into its physical design. You have to choose an appropriate Pri

Durability : This property necessitates that once a transaction has committed, the changes made by it be never lost because of subsequent failure. Thus, a transaction is also a bas

Differentiate strict two phase locking protocol and rigorous two phase locking protocol. In strict two phase locking protocol all exclusive mode locks taken by a transaction is