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
a set of possible data value of an attribute is called??

A database will be made to store information about patients in a hospital. On arrival, each patient’s personal details (name, address, and telephone number) are recorded where poss

Describe in brief about the Sequence Diagrams Sequence diagrams are interaction diagrams which emphasize time ordering of messages. In UML, it is shown as a table which shows

Consider the E/R schema with weak entity sets shown below. Come up with the SQL CREATE TABLE statements (with appropriate primary key, unique and foreign key constraints). Include

Explain weak and strong entity type ? Weak and Strong entity type: An entity set which does not have a primary key is referred to as a weak entity set. The existence of a wea

The users who use easy-to-use menu are called ? The users who use easy to use menu are called as Naïve users.

what do you mean by consistency in rdbms?


Views A view is like a window by which data from tables can be changed or viewed. The table on which a view is based is known as Base table. The view is stored as a SELECT stat

Funky Festivals Specification Funky Festivals organise music festivals which take place at various venues throughout the UK.  A venue needs to be booked before a Festival can t