Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 2: DDL- Altering Tables 8.Write an ALTER statement to add the column Phone to MEMBERSHIP 9 Write an ALTER statement to remove the column

image text in transcribed
image text in transcribed
Part 2: DDL- Altering Tables 8.Write an ALTER statement to add the column Phone to MEMBERSHIP 9 Write an ALTER statement to remove the column Phone from MEMBERSHIP 10. Write an ALTER statement to add the column Price Rentdays to PRICE. Price Rentdays is an integer. This attribute should not accept null values and has a default value of 3. II.Write an ALTER statement to change the date datatype for the Detail ReturnDate in the DETAILRENTAL table to include a time component 12. Write an ALTER statement to drop the constraint from question 2 that Movie Title be unique in MOVIE. Part 3: DML Inserting Data We will just experiment with adding & updating data in the PRICE table. fNext week, I will give you the code to insert data for all tables. Sample of the PRICE table data PRICE TABLE PRICE CODE PRICE DESCRIPTION PRICE RENTFEE PRICE DAILYLATEFEE 35 13. Write an INSERT statement to add the row (5, 'Member Loyalty, 0,.5) to PRICE. 14. Write an INSERT statement for the same data but data values given in a different order (5, 0,.5, 'Member Loyalty to PRICE. 15. Write an INSERT statement to add the row (6, 'Employee Discount') to PRICE fexample of inserting with some data missing/ We will just experiment with adding & updating data in the PRICE table. fNext week, I will give you the code to insert data for all tables.) Sample of the PRICE table data PRICE TABLE PRICE PRICE CODE PRICE DESCRIPTION PRICE RENTFEE PRICE DAILYLATEFEE New Release 3.5 13 Write an INSERT statement to add the row (5, Member Loyalty', 0,.5) to PRICE 14. Write an INSERT statement for the same data but data values given in a different order (5, 0,.5, 'Member Loyalty) to PRICE 15.Write an INSERT statement to add the row (6, 'Employee Discount') to PRICE fexample of inserting with some data missingf 16. Write an UPDATE statement to increase all price rental fee values in the PRICE table by S0.50. 17. Write an UPDATE statement to change the price description of 'Standard'to 'Regular Rate'. fyou have to use a where clause here - we really haven't talked about that yet so just do your best.) 18. Write the statement to delete price code 4. {again, you need a where clause here) 19.Write the statement that deletes all the data in the PRICE table 20 in a table but an entire table? What command is used to delete a Table not the data

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Database Experts Guide To Database 2

Authors: Bruce L. Larson

1st Edition

0070232679, 978-0070232679

More Books

Students also viewed these Databases questions

Question

17. Whats the float for any activity on the critical path?

Answered: 1 week ago