利用QQ群里的SQL代码,见文件xueji17.txt,创建示例数据库xueji17,再创建其中的两个数据表。 1. 学生信息表,表名为student,含有字段: ID (顺序号), sname(姓名), sno (学号), ssex(性别), sage (年龄),sdept(所属系部) ,saddress (地址), semail (电子邮件). 2. 成绩表,表名为cs,含有字段: studentid (学号),courseid (课程号) ,grade (成绩). 在数据库xueji17中完成以下题目: (1)在学生表student中添加新学生,信息如下表 sno sname saddress 3003 Green Finance (2)添加成绩表cs中新信息: studentid courseid grade 3003 002121 3002 009876 93 1002 030437 42 (3)填入学生表中的下列数据 sno,sname,ssex,sage,sdept "95001","洛燕妮","女",20,"信息系" "95002","欧阳炎","男",19,"计算机系" "95003","何东升","男",21,"美术系" "95004","刘晨","男",18,"计算机系" "95005","沙明华","女",21,"美术系" "95006","欧阳宝宝","男",19,"美术系" (4)填入成绩表中的下列数据 studentid,courseid,grade "95001", "kl02",98 "95002", "9hu2",50 "95004", "9sh02",70 "95003", "95sh2",95 "95005", "95sh2",40 "95006", "95sh2",77 "95001", "95sh2",80 "95002", "95sh2",58 "95006", "96sh2",700