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
What sorts of tables one can se in designing the hierarchy of a LDB? Tables, which are having Foreign Key relations.

Your friend owns and operates a wholesale shoe business with annual revenues of $5 million dollars. His wholesale business specializes in supplying and supporting retailers with sh

Defining Internal Classes and Operations When we enlarge algorithms, new classes can be added to the store intermediate results. A complex operation could be looked at, as a c

Modify a sequence: ALTER SEQUENCE SEQSS INCREMENT 2 MAXVALUE 3000;   Removing a sequence: DROP SEQUENCE SEQSS;

Question: (a) With the help of a diagram, explain the TOGAF framework for enterprise architectures. (b) Where would you position enterprise architectures in an enterpri

Differentiate between a Global and a Local temporary table? - A local temporary table exists only for the duration of a connection or if defined inside a compound statement, fo

What is called a query -execution engine? The query implementation engine takes a query evaluation plan, implements that plan, and returns the answers to the query.

What is the purpose of storage manager? The storage manager is responsible for the following a) Interaction with the file manager b) Translation of DML commands in to low

Describe the four main ways of optimising disk block access. Ans: a. Disk  b. Non-volatile writes buffers c. File organization (Clustering) d. Log-based file system

What are views? Explain how views are different from tables? A view in SQL terminology is a one table in which is derived from other tables. These other tables could be base t