Click here to Skip to main content
15,879,535 members
Home / Discussions / Database
   

Database

 
AnswerRe: sharing sql server without client installation Pin
Manas Bhardwaj26-Jun-07 22:24
professionalManas Bhardwaj26-Jun-07 22:24 
AnswerRe: sharing sql server without client installation Pin
originSH26-Jun-07 22:29
originSH26-Jun-07 22:29 
GeneralRe: sharing sql server without client installation Pin
mamatha_raghu27-Jun-07 0:06
mamatha_raghu27-Jun-07 0:06 
GeneralRe: sharing sql server without client installation Pin
originSH27-Jun-07 1:06
originSH27-Jun-07 1:06 
AnswerRe: sharing sql server without client installation Pin
Mike Dimmick27-Jun-07 2:46
Mike Dimmick27-Jun-07 2:46 
QuestionSequence of events/methods execuion in SSIS Pin
I.explore.code26-Jun-07 19:57
I.explore.code26-Jun-07 19:57 
Questionpull subscriptions Pin
SVb.net26-Jun-07 12:58
SVb.net26-Jun-07 12:58 
QuestionDatabase design for exam system? Pin
HinJinShah26-Jun-07 8:08
HinJinShah26-Jun-07 8:08 
Sir!
I am trying to develop a computer based Result Tabulation System for the school I work in.
I have designed the tables for Teachers, Classes, Students etc. but am stuck with the design of tables for exam system itself. Can you please guide me as to how better it could be done?
The examination system of school is as follows.

1. There are Two Terms in an academic year
2. There are two Bimontlhy's(BM) in each term
3. There are Four Class works(cw), One Oral Project(OP) and One Assessment Test(AT) in one Bimonthly
4. The aggregate of all the class works and OP and ATs make one Bimonlthly
Its Like
cw1+cw2+cw3+cw4+OP+AT = BiMonthly(BM)
5. The aggregate of two Bi Monthly and Term Exams make A Term Assements
and
BM1+BM2+First Term Exam = First Term

I am wondering as how to make normalized tables and avoid any anomalies.
Should I make separate tables for Classworks like
tblClasswork: cwID, cwname, cwshort
1 , Classwork1, cw1
and same for AT and OPs.
and them make a table for Bimonthly to Put CWID in it ...
and then for term?
I have also tried to create a table named
tblExamData with fields: stuID, teacherID, subjectID, sessionID, cwID, opID, atID, bmID, termID
but it won't serve the purpose coz it will store the information about CWs, Ops and Ats not the obtained marks of the students.
I have also tried to change it like
tblExamData: stuID, teacherID, subjectID, sessionID, cwID, cwMarks, opId, opMarks, atID, atMarks, bmID, bmMarks, termID, termMarks.

but then there may be some update, delete anomalies.?

what to do with it?

I apologise for this long write up but i am writing in a hope to get a better guideline.

thank you

regards,
AnswerRe: Database design for exam system? Pin
Ashiq Shaikh26-Jun-07 22:56
professionalAshiq Shaikh26-Jun-07 22:56 
GeneralRe: Database design for exam system? Pin
HinJinShah27-Jun-07 6:31
HinJinShah27-Jun-07 6:31 
QuestionProblem configuring an OldDbDataAdaptor in VS03 Pin
Dan Neely26-Jun-07 4:54
Dan Neely26-Jun-07 4:54 
AnswerRe: Problem configuring an OldDbDataAdaptor in VS03 Pin
Dan Neely26-Jun-07 6:58
Dan Neely26-Jun-07 6:58 
AnswerRe: Problem configuring an OldDbDataAdaptor in VS03 Pin
hisi_200526-Jun-07 16:50
hisi_200526-Jun-07 16:50 
QuestionCalling all Irish devs!! Region-specific characters Pin
Mel Padden26-Jun-07 4:48
Mel Padden26-Jun-07 4:48 
AnswerRe: Calling all Irish devs!! Region-specific characters Pin
Mike Dimmick27-Jun-07 3:10
Mike Dimmick27-Jun-07 3:10 
QuestionMS Access functions to Oracle Pin
Mangilipelli26-Jun-07 2:20
Mangilipelli26-Jun-07 2:20 
AnswerRe: MS Access functions to Oracle Pin
leckey26-Jun-07 9:30
leckey26-Jun-07 9:30 
GeneralRe: MS Access functions to Oracle Pin
Mangilipelli26-Jun-07 22:54
Mangilipelli26-Jun-07 22:54 
GeneralRe: MS Access functions to Oracle Pin
Vasudevan Deepak Kumar27-Jun-07 2:52
Vasudevan Deepak Kumar27-Jun-07 2:52 
QuestionHow can i return the names of a stored procedures input parameters? Pin
Red_Wizard_Shot_The_Food25-Jun-07 23:52
Red_Wizard_Shot_The_Food25-Jun-07 23:52 
AnswerRe: How can i return the names of a stored procedures input parameters? Pin
Manas Bhardwaj26-Jun-07 0:10
professionalManas Bhardwaj26-Jun-07 0:10 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
originSH26-Jun-07 0:13
originSH26-Jun-07 0:13 
AnswerRe: How can i return the names of a stored procedures input parameters? [modified] Pin
originSH26-Jun-07 0:11
originSH26-Jun-07 0:11 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
Gamzun26-Jun-07 0:25
Gamzun26-Jun-07 0:25 
GeneralRe: How can i return the names of a stored procedures input parameters? Pin
originSH26-Jun-07 0:28
originSH26-Jun-07 0:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.