Auto ________ is an Excel feature that can generate a series of values into adjacent cells

____________________ is the time it takes for networked information to travel from the transmitting device to the receiving device.

Fill in the blank(s) with the appropriate word(s).

An Internet store sends emails to customers and would like to use a database to keep track of which messages are sent to which customers. A message has a message id (mId), a subject (subject), and a body (body). A customer is identied by the email address (email), and customer's data includes the attributes name, sex, householdSize, and address. When an email is sent, the date (sendDate) is

recorded. You can assume any reasonable domains for these attributes. (a) Give an E-R diagram that completely describes the entities and relationships of this plan. (b) Translate the E-R diagram into SQL tables using SQL DDL, by specifying a table for messages, a table for customers, and a table for which messages are sent to which customers, in SQL DDL. (c) How to specify that the subject of a message must not be longer than 60 characters, in SQL? (d) How to require that customers at the same address all have dierent names, in SQL? (e) How to enforce the restriction that the only valid values of sex are male or female, in SQL? (f) How to specify that each message must be sent to no more than one customer, in SQL? (g) How to specify that each customer must be sent one or more messages, in SQL? (h) How to specify that each message must be sent to exactly one customer, in SQL? (i) How to specify that each customer must be sent exactly one message, in SQL? (j) How to specify that a message can be deleted only if no customer has been sent that message, in SQL? (k) Shipping department needs not be concerned with the sex and household size of the customers. Create an element of an external schema which is a view of customers that does not contain these attributes.