Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

6. Following records are given in the ITEM table. Analyses the records and write the query for the following questions. Item ID 1 2 3

image text in transcribed
image text in transcribed
6. Following records are given in the ITEM table. Analyses the records and write the query for the following questions. Item ID 1 2 3 4 5 6 Item_Name Company Item_prod_date Galaxy Note 9 Samsung 2015/10/30 iphone X 512 GB Apple 2018/08/20 iPhone Xs 512 GB Apple 2019/01/10 Galaxy S10 256 GB Samsung 2015/10/05 Galaxy S10 512 GB Samsung 2017/09/25 P30 Pro 256 GB Huawei 2018/09/14 Table 2 Rate 450.000 550.000 600.999 550.000 600.000 400.000 (d) Delete iphone X 512 GB item from ITEM table. [2 marks] (e) Which command can be used to verify the changes you made in the table ITEM? Write the SQL [2 marks] (1) Add a new column Phonecolour to the table ITEM. [2 marks] (g) Modify the column Item prod_date as production date. [2 Marks) (h) Save permanently all changes you have made in the database. [1 mark]

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_2

Step: 3

blur-text-image_3

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

Guide To Client Server Databases

Authors: Joe Salemi

2nd Edition

1562763105, 978-1562763107

More Books

Students explore these related Databases questions

Question

Connect with your audience

Answered: 3 weeks ago