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

EDUCATIONAL DATABASE SYSTEM

The administrator, student, department, course, attendance, section and exams are represented as entities. Administrator has the properties id and name. Entity course has the attributes course id, code, qualification, experience. Department entity has attributes dept-id and name. Attendance has attributes roll no, stud name, course and percentage. Also section_id and name are stored in entity, section and attributes marks, course, stud name and reg no are stored in entity, exams.

ER DIAGRAM 

shalu edu

 

RELATIONAL MODEL

ENTITIES

S1

 

RELATIONSHIPS

S2

 

 

Advertisements