October 20, 2016 at 11:25 am
Dear All
I am working university Management system.In my project each and every activities separate approval process available.But one university to another university approval process differed.(example) One process for Internal Mark Entry for all the students.
University 1: Faculty entering internal mark ---> HOD approval1-----> principal Approval--->University Approval
University 2: Faculty entering internal mark -----> principal Approval--->University Approval
.In this above kind of scenario how the table structure should be design in configurable manner.Please help me good suggestion..
Regrds
v.s.satheesh
October 20, 2016 at 11:56 am
Based on the information provided,
If the roles are fixed then I would design it in the denormalized manner:
MarkKey (SurrogateKey)
StudentKey (Foreign key to Student)
Marks
HODApprovedDate
PrincipalApprovedDate
UniversityApprovedDate
etc
If roles are configurable then 2 tables
StudentMarkKey (SurrogateKey)
StudentKey (Foreign key to Student)
Marks
MarkApprovalKey (Surrogate Key)
StudentMarkKey
RoleKey (Foreign key to Role)
ApprovedDate
October 20, 2016 at 12:08 pm
As I understand it:
Students get marks
Marks are approved
Different universities have different approvals
It looks like you need:
Student table
Student Mark table
Student Mark Approval table
University table
University Approval table
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply