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, 23.06.2019 11:00
What are the possible consequences of computer hacking? what is computer piracy? describe some examples. what are the effects of computer piracy? what are the possible consequences of computer piracy? what is intentional virus setting? describe some examples. what are the effects of intentional virus setting? what are the possible consequences of intentional virus setting? what is invasion of privacy? describe some examples. what are the effects of invasion of privacy? what are the possible consequences of invasion of privacy? what is an acceptable use policy and what is the purpose of the acceptable use policy what is intellectual property and how can you use it?
Answers: 1
question
Computers and Technology, 23.06.2019 21:40
Simon says is a memory game where "simon" outputs a sequence of 10 characters (r, g, b, y) and the user must repeat the sequence. create a for loop that compares the two strings. for each match, add one point to user_score. upon a mismatch, end the game. sample output with inputs: 'rrgbryybgy' 'rrgbbrybgy'
Answers: 3
question
Computers and Technology, 24.06.2019 16:30
Jenny needs to record the names of 30 students, write down the subjects they studied, and note their grades in each subject after the midsemester exams and the end-of-semester exams. she divides the midsemester and end-of-semester information into two separate worksheets, sheet 1 and sheet 2. how will she rename the two worksheets?
Answers: 2
question
Computers and Technology, 24.06.2019 18:30
What is the local portion of the e-mail address below? [email protected] a.) @ b.) biz c.) gumchewer d.) twrigley
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
Mathematics, 21.01.2021 19:40
question
Chemistry, 21.01.2021 19:40
question
Mathematics, 21.01.2021 19:40
question
Mathematics, 21.01.2021 19:40
question
Chemistry, 21.01.2021 19:40
Questions on the website: 13722367