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
Eliminate Redundant Data In the "Database Relation" above, the primary key is made up of the D-ID and the Emp-ID. The database-name relies only on the D-ID. The similar databas

Write a query to define tables students and teachers as sub tables of people? Create table students of student under people Create table teachers of teacher under people

Question: Describe briefly the three parts of the Relational Model. (a) The term integrity refers to the accuracy or correctness of the data in the database. Define the fol


What are the benefits of OOA technology? Using OOA technology can produce many benefits, such as:  i) Reusability of code  ii) Productivity is gained through direct mappi

Question 1 Discuss the classification of DBMS based on location of database Question 2 Explain with examples different SQL commands used for creating and deleting relations.

What is a cascading update? Referential integrity constraints needs that foreign key values in one table correspond to primary key values in another. If the value of the primar

Security And Integrity After Reading the concepts of database recovery in the last section, let us now deal with a vital concept that helps in minimizing consistency errors in

Give an example of Operations from the functions of a bank. For creation of a saving account, you can write: bank::: create -savings-account (customer)->account. For oper

Question 1 What do you mean by database management system? Question 2 Write a note on Object-Oriented Model Question 3 Explain Sequential File Organization Question