subject

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.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 13:00
Which option should u select to ignore all tracked changes in a document
Answers: 1
question
Computers and Technology, 22.06.2019 14:00
Which database model is best used for data warehouse and data mining
Answers: 3
question
Computers and Technology, 22.06.2019 17:40
Consider the simple 3-station assembly line illustrated below, where the 2 machines at station 1 are parallel, i.e., the product only needs to go through one of the 2 machines before proceeding to station 2.what is the throughput time of this process?
Answers: 2
question
Computers and Technology, 23.06.2019 00:00
What engine component is shown in the above figure?
Answers: 1
You know the right answer?
The following problems expand on the tinyvideo case from chapter 7. to complete the following proble...
Questions
question
Chemistry, 29.10.2019 14:31
Questions on the website: 13722360