database normalization exercises

Tags: value equal div. com DAO htm automatic informationLogin Port pageencoding=" UTF-8 "%> card number: Password: Connection request Side Import= "Com.web.cardDAO"%> pageencoding= "UTF-8"%> String Cardid=request.getparameter ("Cardid1"); String Password=request.getparameter ("Password1"); if(cardid==NULL|| password==NULL|| Cardid.equals ("") | | Password.equals ("") {out.write ("Please log into the system correctly"); } Else { //Check login InformationCarddao cd=NewCarddao (); if(Cd.

class number and the age from the big to the small order to query the student table all records.Select Class,sbirthday from Student Order by class Desc,sbirthday ASC--Question 41st, query "male" teachers and their courses.Select CNAME from course where TNO in (select TNO from teacher where tsex= ' man ')Select Tname,cname from teacher, course where teacher.tno=course.tno and tsex= ' men '--The 42nd question, the query highest score schoolmate's Sno, CNO and degree column.(1) SELECT * FROM score

their courses. - SelectCname,tname fromCourse Join Teacher on Course.tno=teacher.tnowheretsex='male'--Union of 2 tabular practices About $ Select* fromCoursewhereRninch(SelectRn fromTeacherwheretsex='male') --where procedure - --- the, Query the SNO, CNO and degree columns of the highest score. - SelectSno,cno,degree fromScorewheredegree = (SelectMAX (degree) fromScore)--Method One A + SelectTop1* fromScore ORDER BY degree desc--Method Two the --- +, inquiries and "Li J