Question: Please write SQL queries for this question, not the explanation or the flowchart, just the sql queries for this question. Thanks 4. Write SQL statements

 Please write SQL queries for this question, not the explanation or

Please write SQL queries for this question, not the explanation or the flowchart, just the sql queries for this question.

Thanks

4. Write SQL statements for the following: Create a table sub with following information: columns and data types: name varchar(8), age number(5), markl number(4), mark2 number(4), mark3 number(4); a. Enter at least five tuples for the given relation. b. Add one more column with field name as total with data type as number(5). c. Update the age of sub for a particular student. d. Deleting a row from the table. e. Drop column mark3. f. Modify the table by changing the data type of mark3 to number(6) g. Delete all the data from the sub table. h. Delete the table

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!