jason19203
Students和SC表做自然连接,其结果再和Courses表做自然连接然后对自然连接后的结果做选择操作,选择Speciality字段值为"SE"的数据最后做投影操作,只留下Sname和Cname两个字段SQL如下,都快忘了这东西了,回顾不易,望采纳SELECT Students.Sname, Courses.Cname FROM Students JOIN SC ON Students.Sno = SC.Sno JOIN Courses ON SC.Cno = Courses.Cno WHERE Students.Speciality = "SE"
cathyying850
This system is a student curriculum and the result management systemmanagement system, it is in a universities educational administrationmanagement system management system sub- system. The main user is thestudent, the teacher and the manager. The system facilitated thestudent to choose the class and to look up the minute. Has facilitatedteacher's teaching management and the student result input. The systemhas more more importantly facilitated the school educationaladministration management. This system uses the MVC three overheadconstructions the patterns, can use Struts and Hibernate in theperformance history processes the page logic and the object lastingwork. This system development certainly not pure use JSP+Servletcarries on, but was unified Struts and Hibernate, this was for clearlycause the system the structure simultaneously to simplify thedevelopment work. The student curriculum and the result managementsystem management system production greatly reduced in manpowerinconvenient, lets the entire data management more scientific bereasonable. This system most has the characteristic the place is thebackstage database to the student curriculum and the resultunification management. The system contact surface is manufacturesusing Dreamware software, backstage database Mysql probably dividesinto following several tables: The manager shows, student informationtable, class and grade information table, curriculum informationtable, teacher information table, student curriculum and resultinformation table. Under who can help me to translate! Anxious! Thanksfellow chivalrous people! !
赏你五个指头
This system is a student's course and result to manage system, it is one statures system in high school educational administration management system.The main customer is student, teacher and managing person.The system was convenient the student select elective courses and check a cent.Convenience the teacher's teaching management and student's result record to go into.More important BE, the system was convenient the educational administration of the school manage.The this system adoption MVC is three layers of modes of structures, will use the Struts and the Hibernate to handle page logic and the last long chemical engineering of object to make during the period of developing.The development of this system has no pure usage JSP Servlet to carry on, but combined Struts and Hibernate, this is for making system of the structure is more clear to simplify development work in the meantime.The creation of student's course and result management system reduced the inconvenience on the manpower consumedly, let the whole piece according to management more science reasonable.The place that this system has special features most is a backstage database to unify student's course and the result a management.The interface of system makes use of Dreamware software a creation, the backstage database Mysql probably is divided into a few forms as follows:Managing person's form, student information form, class information form, course information form, teacher information form, student's course and result information form. Who can translate bottom for me!Nasty!Many thanks to each big 侠 !!
