TOPIC: Collect one example for Mapping fro ER Model to Relational model

PAYROLL MANAGEMENT SYSTEM :The employer,employee and salary are represented as entities.Employee details ename,eid,dob,phoneno,edesignation are stored.Employer details name,id,designation and department are stored.Salary details such as medical allowance,basic,hra,ta,da,incentive are also noted.The primary keys are EID,ID and BASIC respectively.

ER DIAGRAM

————————-

NEW

——————————–

ENTITIES:

COMPANY

CNAME CID

BRANCH

BNAME BRANCH#

EMPLOYEE

ENAME EID DOB PHONENO EDESIGNATION

EMPLOYER

NAME ID DESIGNATION DEPARTMENT

SALARY

MEDICAL ALLOWANCE BASIC HRA TA DA INCENTIVE

RELATIONSHIPS:

HAS

CID BRANCH#

HEADED BY

BRANCH# ID

EMPLOYS

EID ID

GETS

EID BASIC

PAYS

ID BASIC
Advertisements