DBMS > Entity Relationship Model (ER Model) > Drawing ER model from Real Life Problem

Problem:

An Institute is running different types of program like:

• Diploma in ICT,
• Diploma in Web Dev. ,
• Diploma in Multimedia etc.

They check the the presence of student in different time of a day like:

Early in the morning at the plygrond

• In the first class
• In the Last class
• At night at Dorm

Presence of stdents are of different types like: 

• Present
• Late
• Absent having no permission
• Absent having  permission

Authorities wants to store present information and need to see report of a particular student of group of students. A sample of report is as follows:

Draw the ER Diagram and Schema Diagram of the database. 

Solution:

Entity Relationship diagram is as follows:

Program : This entity will store  Diploma in ICT, Diploma in Web Dev. , Diploma in Multimedia

Call  : This entity will store In the first class, In the Last class, At night at Dorm

Presence Type  : This entity will store  Present,  Late,  Absent having no permission, Absent having  permission

Student  : This entity will store  Students id, Name etc. 

presents: This entity will store date, presence type, Type of call, student id

 

Schemma of this database will be:

No More

No More

Feedback

Submit