hi dears, I am new in access and learner, can any body tell me which table design is better ???
hi dears, I am new in access and learner, can any body tell me which table design is better ???
Definitely not Table2.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I would say neither.
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
so assist me please
how do i improve or make better table 1
Please describe in 4 lines or less- what exactly is the purpose of this proposed table?
What other/related info are you concerned with? Student names, birthdate, address, contact/guardian, phone.....?
How many tests/exams/results for each student* subject* exam...?
You work with spreadsheets, right?
student result
2 semester
each semester has 4 phases and one final exam
total 10 exams(each class/each phase/each subject) has different total marks
info: student name, roll no, class, wing, section
It is a balancing act between normalization and ease of data entry/edit. "Normalize until it hurts, denormalize until it works."
Table2 goes too far with non-normalization. Table1 is not fully normalized but might be sufficient for your needs.
We just don't know enough about your process and requirements.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
See these models for ideas:
http://databaseanswers.org/data_mode...ters/index.htm (Roster student subject)
http://databaseanswers.org/data_mode...xams/index.htm (Exam)
Your should research Normalization
I'm going to guess one lookup table per field of this result, and this result is a query, not a table.
StudentID
NativeLang
Subject Semester Phase
1 3 5 1 1
NOTE - no spaces or special characters in object names (save for underscore _ ) and no reserved words to be used if possible. Language is one of them.
I suggest you study db normalization.
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.com...on-part-i.html
and/or
http://holowczak.com/database-normalization/
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.