Construct an E-R diagram for a coaching institute which prepares students for entrance to engineering programs. The institute conducts theory classes from Monday to Saturday from 9 am to 8 pm in Physics, Chemistry, Maths and English. The institute maintains records about faculty (visiting, full time) and supporting administrative staff, students, assignments, test result, class timings and payments made to staff. Students are admitted to the institute after they have successfully passed the test. The institute issues transcripts to students showing student’s performance in the class tests. The transcript contains student’ name, subject (physics, chemistry, math and English), assignment score and test score. Clearly indicate the entities, attributes, relationship between entities, keys and cardinalities.

Leave a Reply