Design a Database for Student's course wise marks entry

Assume that you are responsible to design a database, where the following conditions are applicable:

1. Students can not register a subject without payment.
2. Subjects and Students are belongs to Department
3. Teachers are belongs to Department
5. A teacher can submit result only for the registered students
6. Teacher will submit only subject/course wise total numbers
7.Consider the retake/improvement case
8. Published result as a Grade System
9. Automatic Grade Sheet creation by some fixed rules provided by authority. Which will be stored in a table. For example: If a student gets more then or equal to 80 marks then he/she will get a+
10. Teacher will not entry any Grade to system.

Submit necessary DDL and DML to satisfy the above system.

No comments:

Post a Comment

Popular Posts