Answer:
To determine which book titles have been purchased by a customer and when the order shipped the following tables and fields would be used.
Table:
Fields
Table
Fields:
Table:
Fields:
Table:
Fields
BOOKS table contains field like title of the books, so this will help in finding which book titles have been purchased.
CUSTOMERS table keeps information about customers that purchasing an ordering the books. The customerno uniquely identifies each customer so that the order information can be found using the customerno of a specific customer.
ORDERITEMS keeps information about orders via orderno
ORDERS table will keep track about the shipment of orders. Orderno identifies each order, shipdate will help determine when an order is shipped.
Answer:
from socket import *
hostname = input('Enter the host to be scanned: ')
ip_add = gethostbyname(hostname)
connections = [ ]
for i in range(133, 136):
s = socket(AF_INET, SOCK_STREAM)
conn = s.connect_ex((ip_add, i))
print(conn)
connections.append(conn)
if 0 in connections:
print ('Host is online')
s.close()
else:
print ('system is unreachable')
Explanation:
The python source code above scans for all the available range of ports in the provided hostname, if any port is available, the host is online else the program print the error message "system is unreachable.
It can have only 16,384 number of columns
Answer:
b. ethernet
Explanation:
It was an ethernet that was developed in the 1970s that improved the ability to send the information over the network. It is the most widely used method to connect the computers in a LAN or the local area network, ever since 1980 when it was first introduced for commercial use. And it is being used in bulk even today.