Design an ER diagram for an ABC IT Training Institute that will meet t he training needs for
individuals and employees of corporate offices. Clearly indicate the entities, relationships,
cardinality and the key constraints. The description of the environment is as follows:
The Institute offers 5 advanced courses of 3 months duration each. The Institute has 20 faculty
and can handle upto 40 trainees per batch. The training will be conducted batch wise. They can
accommodate maximum 5 batches per day (2 batches in the pre-lunch session and 3 batches in
the post-lunch session). The student can register upto 2 courses simultaneously. Training
consists of theory and practicals. Theory and practicals are scheduled on alternate days. Each
batch is assigned a faculty member who takes theory sessions as well as practical sessions.
Sunday is holiday for everyone. A test will be conducted per course every week to continuously
evaluate the performance of the student. The question paper will be set by the faculty concerned
whoever is teaching the batch. The result/grade will be declared at the end of the third month
after conducting course-end exam.
individuals and employees of corporate offices. Clearly indicate the entities, relationships,
cardinality and the key constraints. The description of the environment is as follows:
The Institute offers 5 advanced courses of 3 months duration each. The Institute has 20 faculty
and can handle upto 40 trainees per batch. The training will be conducted batch wise. They can
accommodate maximum 5 batches per day (2 batches in the pre-lunch session and 3 batches in
the post-lunch session). The student can register upto 2 courses simultaneously. Training
consists of theory and practicals. Theory and practicals are scheduled on alternate days. Each
batch is assigned a faculty member who takes theory sessions as well as practical sessions.
Sunday is holiday for everyone. A test will be conducted per course every week to continuously
evaluate the performance of the student. The question paper will be set by the faculty concerned
whoever is teaching the batch. The result/grade will be declared at the end of the third month
after conducting course-end exam.
This is just what everyone wold like to see and hear. But I am not sure that the strategy is correct and everything is clear.
ReplyDeleteI hope that you were able to pass the exam successfully. The course was not easy, by the way! There are some obstacles that make the process most difficult.
ReplyDeleteThe diagram is really seamless. But why haven't you posted it yet? What's wrong? Can you share the details? Thank you in advance!
ReplyDelete