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
Adding Redundant Associations for Efficient Access The expression redundant association means using "duplicate association for proficient access". While analysis, it is not a

What is DML compiler? DML Compiler: Translates DML statements in a query language within low level instructions understandable through the query evaluation engine. Attempts to

What is OCR? OCR (Optical Character Recognition) is a technology that enables you to change different types of machine-readable documents, like scanned paper documents, PDF fil

Single Valued Normalisation  Codd in the year 1972 formed three normal forms (1NF, 2NF, and 3NF). These were based on functional dependencies between the attributes of a relati

What is Gathering information and Producing ERD Gathering information: This could be a written document that explains the system in question with reasonable quantity of detai

What is Trigger? Trigger: A database trigger is procedural code which is automatically executed in response to specific events on a particular table in a database. Triggers can

NEED FOR A DATABASE MANAGEMENT SYSTEM A Database is a structured, persistent collection of data of an organisation. The database management system (DBMS) manages the database o

Explain the disadvantages of creating a temporary table? If you have already created a temporary table with a shown name and attempting to create a second one with that nam

Define the terms 1) physical schema 2) logical schema. Physical schema: The physical schema explains the database design at the physical level, which is the lowest level of abs

These are the binary operations; i.e., each is applied to two relations or sets. These two relations can be union compatible excluding in case of Cartesian product. Two relations R