Answer to Question #195341 in Databases | SQL | Oracle | MS Access for Israt Jerin

Question

Consider the following scenario and normalize the database upto 3NF - [10]

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.

Answer 1

The answer to your question is provided in the image: