Question

Q. Consider the following scenario and normalize the database upto 3NF - Best-East University is currently in need of a software system for course registration. The university has more than one department and each department has many courses of a particular program such as the Bach- elor and Masters program. A student may register (enroll) all or subset of offered courses for a trimester (e.g. Spring, Summer, Fall). During the registration period, a student's registration is authorized (signed) by the batch advisor. A batch advisor is a faculty member assigned to the batch. Once the registration date is over, a student may late register courses with a late registration fee. In the case of late registration, a student requires the signature of both the batch advisor as well as the department chairman's authorization. Note: You are allowed to have necessary assumptions to answer this queston.

Answer 1