数据库练习题
发布时间：2020-12-12 00:02:44 所属栏目：MySql教程 来源：网络整理
导读：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)" 一、 设有一数据库，包括四个表：学生表（Student）、课程表
|
<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>
`student` （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |