Here Is the code to generate above table:-
<table style="width: 669px; height: 197px;"
border="2">
<tbody>
<tr style="height: 23px;">
<td style="width: 190px; height: 23px;" colspan="2"
align="center"
bgcolor="#4187B4"><strong> Licence</strong></td>
<td style="width: 236px; height: 23px;" colspan="2"
align="center"
bgcolor="#4187B4"><strong> Monthly</strong></td>
<td style="width: 242px; height: 23px;" colspan="2"
align="center"
bgcolor="#4187B4"><strong> Yearly</strong></td>
</tr>
<tr style="height: 23px;">
<td style="width: 95px; height: 23px;" align="center"
bgcolor="#929495"> <strong>Type</strong></td>
<td style="width: 95px; height: 23px;" align="center"
bgcolor="#929495"><strong>Employee
Number</strong></td>
<td style="width: 115px; height: 23px;" align="center"
bgcolor="#929495"><strong>Subscription</strong></td>
<td style="width: 121px; height: 23px;" align="center"
bgcolor="#929495"><strong>Maintanence</strong></td>
<td style="width: 121px; height: 23px;" align="center"
bgcolor="#929495"><strong> Subscription</strong></td>
<td style="width: 121px; height: 23px;" align="center"
bgcolor="#929495"><strong>Maintenance</strong></td>
</tr>
<tr style="height: 23px;">
<td style="width: 95px; height: 23px;" align="center"
bgcolor="#929495"><strong>Individual </strong></td>
<td style="width: 95px; height: 23px;"
align="center">1</td>
<td style="width: 115px; height: 23px;"
align="center"> $40</td>
<td style="width: 121px; height: 23px;"
align="center"> $25</td>
<td style="width: 121px; height: 23px;"
align="center"> $450</td>
<td style="width: 121px; height: 23px;"
align="center"> $290</td>
</tr>
<tr style="height: 23px;">
<td style="width: 95px; height: 23px;" rowspan="2"
align="center"
bgcolor="#929495"> <strong>Site</strong></td>
<td style="width: 95px; height: 23px;"
align="center">10</td>
<td style="width: 115px; height: 23px;"
align="center">$360 </td>
<td style="width: 121px; height: 23px;"
align="center">$200 </td>
<td style="width: 121px; height: 23px;"
align="center">$4000 </td>
<td style="width: 121px; height: 23px;"
align="center">$2000 </td>
</tr>
<tr style="height: 23px;">
<td style="width: 95px; height: 23px;"
align="center">100</td>
<td style="width: 115px; height: 23px;"
align="center"> $3200</td>
<td style="width: 121px; height: 23px;"
align="center">$1800 </td>
<td style="width: 121px; height: 23px;"
align="center">$38,000 </td>
<td style="width: 121px; height: 23px;"
align="center">$18,000 </td>
</tr>
</tbody>
</table>
Write the shell HTML code to generate the following table Include any required attributes Include code...
Database Intro
Salesmen Sheet
Order_info Sheet
Business_Info sheet
1.Create your own table design based on the Excel data, and
include all relationships (joins). Apply referential integrity
rules wherever appropriate.
Import the data from Excel to Access to populate
tables:
1. Use the Chen technique and illustrate the E-R diagram for the
tables you created
Note: It may be necessary to change the data composition due to
normalization issues, if you change the composition detail how and
why; (you may find...