- 173
- 0
- 约6.46千字
- 约 16页
- 2017-07-24 发布于河南
- 举报
学生-课程数据库(Student course database)
学生-课程数据库(Student course database)
SQL query review questions
New students - three tables of the course database:
Student table: Student (Sno, Sname, Ssex, Sage, Sdept) Sno as the main code;
Courses: Course (Cno, Cname, Cpno, Credeit) Cno based code;
Student elective form: SC (Sno, Cno, Grade), Sno, Cno, main yards;
Student
No.
Sno name
Sname sex
Ssex age
Sage Department
Sdept
95001 Li Yongnan 20CS
95002 Liu Chen female 19IS
95003 Wang Minnv 18MA
95004 Zhang Linan 19IS
Course number
Sno course name
Cname advance lesson
Cpno credits
Credit
1 database 54
2 math 2
3 information systems 14
4 operat
您可能关注的文档
- 国税工作总结 正文(Summary of national tax work).doc
- 国税总局年终奖分摊到12个月征税(State Taxation Administration the annual bonus should be assessed to 12 months).doc
- 国贸案例分析1(Case study in China World Trade Center 1).doc
- 国庆、中秋双节促销活动策划方案(National Day and Mid Autumn Festival double promotion plan).doc
- 国内经济多地超市现亏损潮 广州零售市场能否独善其身(Domestic economy many supermarkets are losing money, Guangzhou retail market can be spared).doc
- 国际制度对非成员国的作用(The role of international institutions in non member states).doc
- 国际关系的关系性和跨文化性(The relation and cross culture of international relations).doc
- 国贸试卷4(China World Trade Center papers 4).doc
- 国际石油价格飚升的原因、影响与对策(Influence and Countermeasure of reason, international oil prices soaring).doc
- 国际私法案例(Cases of private international law).doc
- 学好英语的20条钻石法则(The 20 diamond rules for learning English well).doc
- 学生会活动策划书范文_百度知道(A student event planning book. _ Baidu know).doc
- 学生会主要活动流程介绍(Introduction of main activities of Student Union).doc
- 学生会生活部工作总结(Work summary of Student Union's life department).doc
- 学生保持精力充沛的方法(Students keep energetic methods).doc
- 学生会竞选的主持人稿(Moderator of the student union campaign).doc
- 学生会面试问题(Student union interview questions).doc
- 学生心理孤儿现象成因及对策(Causes and Countermeasures of students' psychological orphans).doc
- 学生和老师继承Person类C++源程序(Students and teachers inherit class C++ Person source programs).doc
- 学生日常行为管理规定(Regulations for the administration of students' daily behavior).doc
原创力文档

文档评论(0)