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 01:50
Click on this link toopens a new window. bring up a flowchart in a new browser window. based on this flowchart, would a d-link 3347 gateway with an xbox 360 multiplayer problem be in scope or out of scope
Answers: 2
question
Computers and Technology, 23.06.2019 11:30
The most accurate readings that you can take on an analog vom are when the meter's pointer is at the a. center scale. b. extreme right. c. near right. d. extreme left.
Answers: 1
question
Computers and Technology, 23.06.2019 13:30
Me ! evelyn is a manager in a retail unit. she wants to prepare a report on the projected profit for the next year. which function can she use? a. pmt b. round c. division d. what-if analysis
Answers: 2
question
Computers and Technology, 23.06.2019 16:30
How to do this programming flowchart?
Answers: 3
You know the right answer?
The following problems expand on the tinyvideo case from chapter 7. to complete the following proble...
Questions
question
History, 10.02.2021 22:10
Questions on the website: 13722363