Consider the following table and write SQL statements Table Menu
ID Item Description Price
P001 Sambar Vada South Indian 40
P002 Dal Maakhani North Indian 150
P003 Noodles Chineese 100
P004 Idli Sabar South Indian 50
P006 Sarson Saag North Indian 170
P007 Dosa South Indian 120
P008 Pizza Italian 200
Write Create Command
To add a new row with the following data “P009”, “Lemon Rice”, “South Indian”, 140
Display details of all Menu items in the descending order of Price
Display Item and Description of those Items whose price is between 100 and 150
Add a new column Rating datatype as int to the table Menu
Enter values of rating columns.
Display maximum Price item name.
Delete record of Pizza.
Modify the Size of item.
Write command to display structure of table.
Answers
Answer:
Explanation:
(i) Insert into Menu values
(“P009”, “Lemon Rice”, “South Indian”, 140);
(ii) Select * from Menu order by Price;
(iii) Select Item, Description from Menu
Where price between 100 and 150;
(iv) Cardinailty - 7 Degree – 4
(v) Alter Table Menu Add Rating int;
SQL stands for Structured Query Language
SQL lets you access and manipulate databases
SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987
SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert records in a database
SQL can update records in a database
SQL can delete records from a database
SQL can create new databases
SQL can create new tables in a database
SQL can create stored procedures in a database
SQL can create views in a database
SQL can set permissions on tables, procedures, and views
See more:
https://brainly.in/question/34102035
#SPJ1