用户希望在数据库C#SQL中保存纸张 [英] User want to save paper in database C# SQL
本文介绍了用户希望在数据库C#SQL中保存纸张的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想要一个指南或结构,任何人都可以解释一下,如果教师等想要在数据库中保存纸张,我的数据库应该是什么样子
我尝试了什么:
我所做的只是添加问题并以简单的方式检索我的sql数据库结构应该是什么样的
i有问题,问题,选项1,2,3,4以及答案和主题名称我应该添加更多什么?
解决方案
你想要的有几张桌子:
教师:
ID IDENTITY或GUID
名称NVARCHAR()主题:
ID IDENTITY或GUID
名称NVARCHAR()
论文:
ID IDENTITY或GUID
名称NVARCHAR()
SubmitDate DATE或DATETIME
TeacherID INT或GUID,Teachers.ID $ b的外键$ b SubjectID INT或GUID,Subjects.ID的外键问题:
ID IDENTITY或GUID
PaperID INT或GUID,外键到Papers.ID
...然后使用SQL JOIN语句访问它们:
SELECT q。* FROM 问题q
JOIN 论文p ON q.PaperID = p.ID
WHERE p.Name LIKE ' %Transdimensional Physics%'
i want a guideline or a structure , can anyone just explain me how my database should look like if a teacher etc wants to save paper in database
What I have tried:
all i did is added questions and retrieve like in a simple way bu idk how my sql database structure should look like
i have Questionid, question,option1,2,3,4 and answer and subjectname what should i add more r what?
解决方案
You want to have several tables:
Teachers:
ID IDENTITY or GUID Name NVARCHAR()Subjects:
ID IDENTITY or GUID Name NVARCHAR()
Papers:
ID IDENTITY or GUID Name NVARCHAR() SubmitDate DATE or DATETIME TeacherID INT or GUID, Foreign key to Teachers.ID SubjectID INT or GUID, Foreign key to Subjects.IDQuestions:
ID IDENTITY or GUID PaperID INT or GUID, Foreign key to Papers.ID ...You then access them using SQL JOIN statements:
SELECT q.* FROM Questions q JOIN Papers p ON q.PaperID = p.ID WHERE p.Name LIKE '%Transdimensional Physics%'
这篇关于用户希望在数据库C#SQL中保存纸张的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文