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
Why do so various organizations use MySQL? Advantages: Open source Highly efficient Offers a high scalability in terms of size and connectivity. Highly prote

A database named yourusernameFMA has been set up for you to use for this assignment.  For the FMA you must create the required tables and run the queries using this database.  If y

under what condition log based recovery is feasible?

Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th

Consider the following relations: BRANCH( bno, street, area, city, pcode, Tel_no, Fax_no) STAFF( Sno, Fname, Lname, address, position , salary, bno) Express the subsequent qu

(a) Differentiate between information and data . (b) List and briefly explain five potential benefits of the database approach compared to conventional file systems. (c) Diff

Consistency: This property makes sure that a complete transaction implementation takes a database from one consistent state to another consistent state. If the transaction fails e

Describe Dynamic Model. The dynamic model specifies allowable sequences of changes to the objects from an object model. It contains event trace diagrams describing scenarios. A

1. Design the logic, using a looping structure, for a program that outputs every even number from 1 through 25 along with its square and cube. 2. Mr. Sanchez owns 12 apartme

Question : (a) Database Management Systems (DBMS) is the foundation of business intelligence. Explain the following concepts related to DBMS: (i) Entity Relationship Diagr