I created basic module and implemented basic curd operations but am unable to write code for below conditions pls help me and if possible ER digram also
A university has several faculties, such as Engineering, Medicine, Natural Sciences etc. Each faculty can have one or more departments (e.g. Natural Sciences faculty may have departments for Mathematics, Chemistry, Zoology etc.). Students can register for only one faculty, but can enroll for subjects from any department within the faculty. There is a restriction that a student can register for a maximum of 3 subjects from at least two departments per semester. There are three semesters per year. A lecturer can be assigned to only one department throughout his/her stay in the university, but can lecture on any subject falling under his/her specialty. A lecturer can lecture for only one subject per semester per batch of students. A lecturer can lecture for a maximum of two different batches in a semester.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 6/18/15, 9:35 AM|
|Seen: 422 times|
|Last updated: 6/20/15, 5:32 AM|