Conversion of er diagram to relational database, Database Management System

Conversion of entity sets:

I)   For  every  strong  entity  type  E  in  the  ER  diagram,  we  make  a  relation  R containing all the easy attributes of E. The relation R primary key will be one of the key attributes of R.

For example, the STUDENT, FACULTY, COURSE and DEPARTMENT tables in Figure.

STUDENT

ROLLNO: Primary Key

NAME

ADDRESS

 

 

 

 

 

 


 

 

FACULTY

ID: Primary

Key

NAME

ADDRESS

BASIC_SAL

 

 

 

 

 

 

 

 

 

 

 

 

COURSE

COURSE_ID: Primary Key

COURSE_NAME

DURATION

 

 

 

 

 

 

 

DEPARTMENT

D_NO: Primary Key

 

 

 

 

 

For each weak entity type W in the E R Diagram, we make another relation R that have all easy attributes of W. If E is an owner entity of W then key attribute of E is also contained in R. This key attribute of R is set as a foreign key attribute of R. Now the mixture of primary key attribute of owner partial key and entity type of weak entity type will form the key of the weak entity type.

The weak entity GUARDIAN, where the key field of student entity

RollNo has been added.

RollNo            Name

(Primary Key)

Address

Relationship

 

 

 

 

 

 

 

 

Posted Date: 3/6/2013 6:25:54 AM | Location : United States







Related Discussions:- Conversion of er diagram to relational database, Assignment Help, Ask Question on Conversion of er diagram to relational database, Get Answer, Expert's Help, Conversion of er diagram to relational database Discussions

Write discussion on Conversion of er diagram to relational database
Your posts are moderated
Related Questions
Which is the properties of entities? Attributes is the properties of entities.

Explain the function of Object model Object model describes the classes of objects in system, including their attributes and operations which they support. The analysis object

What are the benefits of decomposing a system? The benefits of decomposing a system into subsystems are that after decomposition, each individual component become smaller and e

How do you find the final model after iterative analysis? Why is iterative analysis of any of the problem needed? The final model serves as the base for system architectur

a)  Suppose we updated the catalog tables in real time, that is, after every update, insert, or delete SQL statement were executed-rather than only running RUNSTATS once every few

What are the advantages of relational data model? Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer

Explain the rules for creating a labelled precedence graph for testing view serializability.            Ans: A schedule S is view serializable if it is view equivalent to a ser

Name the various privileges in SQL? A) Delete B) Select C) Insert D) Update

In how many parts events are classified Events are classified as four types in UML 1.  Signals 2.  Calls 3.  Passing of Time 4.  Change in State

Question (a) Concurrent access to data from a database is a normal part of application program usage. Describe three approaches to concurrency control (b) Distinguish among