Home / Expert Answers / Computer Science / 8-alter-the-video-table-to-include-an-attribute-named-vid-status-to-store-character-data-up-to-fo-pa888

(Solved): 8. Alter the VIDEO table to include an attribute named VID_STATUS to store character data up to fo ...



8. Alter the VIDEO table to include an attribute named VID_STATUS to store character data up to four characters long. The attribute should have a constraint to enforce the domain (“IN,” “OUT,” and “LOST”) and have a default value of “IN”. 9. 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. 10. Alter the PRICE table to include an attribute named PRICE_RENTDAYS to store integers of up to two digits. The attribute should not accept null values, and it should have a default value of 3. 11. Update the PRICE table to place the values shown in the following table in the PRICE_RENTDAYS attribute.



We have an Answer from Expert

View Expert Answer

Expert Answer


We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe