Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> What should be the Database Design in this case?
Hi All!
I've been stuck with this issue and could not find any answers. I am designing the database for a School Information System. I've the following tables:
Course - Stores all the Available Courses
-----------------
Id Name
----------------
1 IX 2 X Subjects - Stores all the Available Subjects
CourseSubjects - Stores the Subjects that are taught for a particular course. The data given below indicates Maths & English are taught in IX
and English & Scienceare taught in Xth.
1 1 1 2 1 2 3 2 2 4 2 3 Exams - Stores all the Exams that areheld in the School
1 UnitTest 2 HalfYearly 3 Final CourseExams - Stores which exams are taken for which courses. The data given below indicates Only HalfYearly and Final exams are taken for Cousre IX andHalfYearly and UnitTest are taken for Course X
1 1 2 2 1 3 3 2 2 4 2 1
I hope the above database schema is clear and also properly normalized. Now I want to store Subject wise MaximumMarks for each course. I have two possible database designs for that.
a)
CourseWiseExamSubjectParticulars
1 2 1 50 1 2 2 50 2 1 3 25
b)
CourseWiseExamSubjectParticulars
1 1 50 1 2 50 4 4 25
I am not sure which one is better. Each of the above has its own pluses and minuses.
A)
+More Normalized
-Consumes More Database Space
B)
-Less Normalized (Can reach to Course via both CourseSubjectId and
CourseExamId)
-Consumes Less Database Space
- Easier to ensure data integrity because on those courseExamIds and
CourseSubjectId's can be mapped which have the same courseId.
Any help on this would be highly appreciated.
Thanks in advance
Puneet Received on Thu Dec 05 2002 - 12:20:02 CST