⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 bookpublisher.html

📁 ssd7 练习一答案 供大家参考 如有错误 请多多包涵
💻 HTML
字号:
🔍 
<html>
    <body>
	<p>
	    Tables and keys    
	</p>
	<h4>BOOK TABLE</h4>
	<table border="1">
	    <tr>
		<td>Primary Author</td>
		<td>Title</td>
		<td>ISBN</td>
		<td>PublisherID</td>
		<td>Edition</td>
		<td>Date of Publication</td>
	        <td>Price</td>
		<td>Book Description</td>
	    </tr>
            <tr>
		<td>Bob</td>
		<td>Chinese</td>
		<td>11</td>
		<td>111</td>
		<td>ONE</td>
		<td>2006/01/02</td>
	        <td>50.00</td>
		<td>GOOD</td>
	    </tr>
            	    <tr>
		<td>Tom</td>
		<td>Computer</td>
		<td>22</td>
		<td>222</td>
		<td>TWO</td>
		<td>2007/01/02</td>
	        <td>100.00</td>
		<td>GOOD</td>
	    </tr>
            <tr>
		<td>Jim</td>
		<td>Math</td>
		<td>33</td>
		<td>333</td>
		<td>THREE</td>
		<td>2008/01/02</td>
	        <td>150.00</td>
		<td>GOOD</td>
	    </tr>
            <tr>
		<td>Max</td>
		<td>English</td>
		<td>44</td>
		<td>444</td>
		<td>FOUR</td>
		<td>2009/01/02</td>
	        <td>200.00</td>
		<td>GOOD</td>
	    </tr>
	</table>
	<p>
            Primary Key(s)(PKs):ISBN</br> 
            Alternate Key(s)(AKs):Primary Author,Title,Edition;Primary Author,Title,Date of Publication</br>
	    Foreign Key(s)(FKs):PublisherID 
        </p>
        <h4>PUBLISHER TABLE</h4>
	<table border="1">
	    <tr>
		<td>PublisherID</td>
		<td>Name</td>
		<td>Address</td>
	    </tr>
            <tr>
		<td>111</td>
		<td>Addison Wesley</td>
		<td>AMERICAN</td>
	    </tr>
	    <tr>
		<td>222</td>
		<td>McGraw Hill</td>
		<td>JAPAN</td>
	    </tr>
            <tr>
		<td>333</td>
		<td>APPLE</td>
		<td>CHINA</td>
	    </tr>
            <tr>
		<td>444</td>
		<td>SUN</td>
		<td>INDIA</td>
	    </tr>
	</table>
        <p>
            Primary Key(s)(PKs):PublisherID</br> 
            Alternate Key(s)(AKs):Name,Address</br>
	    Foreign Key(s)(FKs):No,there isn't.
        </p>
        <h4>
        Columns and Domains 
        </h4>
        <table>
        <table border="1">
	    <tr>
		<td>Attribute </td>
		<td>domains</td>
	    </tr>
	    <tr>
		<td>Primary Author </td>
		<td>TEXT</td>
	    </tr>
	    <tr>
		<td>Title</td>
		<td>TEXT</td>
	    </tr>
	    <tr>
		<td>ISBN</td>
		<td>VARCHAR(30)</td>
	    </tr>
	    <tr>
		<td>PublisherID</td>
		<td>INTEGER</td>
	    </tr>
	    <tr>
		<td>Edition</td>
		<td>VARCHAR(5)</td>
	    </tr>
	    <tr>
		<td>Date of Publication</td>
		<td>DATE</td>
	    </tr>
	    <tr>
		<td>Price</td>
		<td>NUMERIC</td>
	    </tr>
	    <tr>
		<td>Book Description</td>
		<td>VARCHAR(40)</td>
	    </tr>
	    <tr>
		<td>Name</td>
		<td>TEXT</td>
	    </tr>
	    <tr>
		<td>Address</td>
		<td>TEXT</td>
	    </tr>
        </table>		
    </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -