The following problems expand on the tinyvideo case from chapter 7. to complete the following problems, it is necessary to have first completed the table creation and data entry requirements specified in problems 44 and 45 in chapter 7.35. alter the detailrental table to include a derived attribute named detail_dayslate to store integers up to 3 digits. the attribute should accept null values.36. alter the video table to include an attribute named vid_status to store character data up to 4 characters long. the attribute should not accept null values. the attribute should have a constraint to enforce the domain ("in", "out", and "lost") and have a default value of "in".37. update the vid_status attribute of the video table using a subquery to set the vid_status to "out" for all videos that have a null value in the detail_returndate attribute of the detailrental table.38. alter the price table to include an attribute named price_rentdays to store integers up to 2 digits. the attribute should not accept null values, and should have a default value of 3.39. update the price table to place the values shown in the following table in the price_rentdays attribute.

The type of program is the hierarchical grid

My favorite is "be concise."have you ever received an email and had to read a page full of information? by the time you finished reading it, you had to re-read it? i have even hit "reply" so that i could break it down into separate paragraphs and send it back to myself.what is concise? get to the point, fast. when opening an email like this, some will close it or print it to read later.i learned to use the subject line to prepare the reader for content. such as, "need on (blank), " "info only re: (blank)," "request input on (blank)," "read before (blank) meeting." these are just some.if you are asking for something, make that your first sentence. follow this by who, what, when, where, and how. use these, as necessary. example; (1) who (who needs it and or who does it), (2) what (specific description of what is needed), (3) when (specific, i need this by 8: 00 am monday or i need this by 10: 00 am today), (4) where (does it have to be printed and taken to someone, maybe the place of the meeting), (5) how (i need it scanned or faxed back to me at this email address, provide me with a hard copy).do not send yet. re-read it. did some spell check change a word? maybe let someone else read it for understanding. you want to avoid multiple emails asking for clarification. if important, put a read receipt on it. you will know it was opened, not necessarily read.end with a you.