我如何直接将一个或多个表中的计算数据插入另一个表???? [英] How do i directly insert calculated data in from one/more tables into another????

问题描述

在创建考试软件时，我在这里遇到了一些严重的问题(多项选择题).要创建学生成绩报告，我在SQL数据库中有以下表格...

GradingTbl:包含>>> ExamPaperID，A级，B级....[存储每个考试的等级界限]

AnswersTbl:包含>>>答案(已选择选项)，考试纸ID，学生ID和问题ID [此表存储了用户提供的答案]

ExamPaperTbl:包含>>>  ExamPaperID，TOTAL_Marks ....... [包含所有详细信息]

QuestionsTbl  ;:包含>>>  ExamPaperID，标记，问题，Option1，Option2，Option3，Option4 [存储所有问题]

问题>>>>>>>> ..我如何根据以上信息计算用户的总得分.

谢谢

解决方案

我认为您在提供的信息中缺少学生证，是否需要用SQL或代码执行? blockquote>

I am facing some serious problems here while creating an exam software (multiple choice questions). To create a student performance report, i have the following tables in SQL database...

GradingTbl : which contains>>>> ExamPaperID, GradeA, GradeB.... [STORES THE GRADE BOUNDARIES FOR EACH EXAM]

AnswersTbl: which contains>>>> Answer (option selected) , ExamPaperID,  Student_ID,  Question_ID [THIS TABLE STORES THE ANSWERS PROVIDED BY THE USER]

ExamPaperTbl: which contains>>>> ExamPaperID, TOTAL_Marks....... [CONTAINS ALL THE DETAILS]

QuestionsTbl : which contains>>>> ExamPaperID, marks, Question, Option1,Option2, Option3, Option4 [STORES ALL THE QUESTIONS]

Question>>>>>>>>>.. How can i calculate the total marks of the user based on the above info.

Thanks

解决方案

I think you're missing the student ID in the information you provided, Do you need yo perform it in SQL or in Code?

这篇关于我如何直接将一个或多个表中的计算数据插入另一个表????的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！