数据库练习题
发布时间：2020-05-22 15:48:55 所属栏目：MySql 来源：互联网
导读：设有一数据库，包括四个表：学生表（Student）、课程表（Course）、成绩表（Score）以及教师信息表（Teacher）。四个表的结构分别如表1-1的表（一）~表（四）所示，数据如表1-2的表（一）~表（四）所示。用SQL语句创建四个表并完成相关题目。
|
<p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:19.5px; font-size:13px; font-family:Verdana,Arial,Helvetica,sans-serif; background-color:rgb(254,254,242)"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:19.5px; font-size:13px; font-family:Verdana,242)"> <span style="margin:0px; padding:0px">表1-1数据库的表结构 <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:19.5px; font-size:13px; font-family:Verdana,242)"> 表（一）Student (学生表) <table border="1" cellspacing="0" cellpadding="0" style="margin:0px; padding:0px; border:1px solid silver; border-collapse:collapse; word-break:break-word; color:rgb(0,0); font-family:Verdana,sans-serif; font-size:13px; line-height:19.5px; background-color:rgb(254,242)"> <tbody style="margin:0px; padding:0px"> <tr style="margin:0px; padding:0px"> <td valign="top" width="79" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> 属性名 </td> <td valign="top" width="72" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> 数据类型 </td> <td valign="top" width="84" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> 可否为空 </td> <td valign="top" width="108" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> 含 义 </td> </tr> <tr style="margin:0px; padding:0px"> <td valign="top" width="79" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> Sno </td> <td valign="top" width="72" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> Char(3) </td> <td valign="top" width="84" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> 否 </td> <td valign="top" width="108" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> 学号（主码） </td> </tr> <tr style="margin:0px; padding:0px"> <td valign="top" width="79" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> Sname </td> <td valign="top" width="72" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> Char(8) </td> <td valign="top" width="84" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> 否 </td> <td valign="top" width="108" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> 学生姓名 </td> </tr> <tr style="margin:0px; padding:0px"> <td valign="top" width="79" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> Ssex </td> <td valign="top" width="72" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> Char(2) </td> <td valign="top" width="84" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> 否 </td> <td valign="top" width="108" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> 学生性别 </td> </tr> <tr style="margin:0px; padding:0px"> <td valign="top" width="79" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> Sbirthday </td> <td valign="top" width="72" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> datetime </td> <td valign="top" width="84" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> 可 </td> <td valign="top" width="108" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> 学生出生年月 </td> </tr> <tr style="margin:0px; padding:0px"> <td valign="top" width="79" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> Class </td> <td valign="top" width="72" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> Char(5) </td> <td valign="top" width="84" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> 可 </td> <td valign="top" width="108" style="margin:0px; padding:3px; border:1px solid silver; border-collapse:collapse"> <p style="margin:10px auto; padding-top:0px; padding-bottom:0px; line-height:1.5; font-size:13px"> 学生所在班级 </td> </tr> 相关内容
|