Computer Science By Mr. MRK
(vii) SELECT ClientName, ManufacturerName FROM Product, Client WHERE Client.Prod_Id=Product.P_Id;
Ans.
| Client Name | Manufacturer Name |
| Cosmetic Shop | ABC |
| Total Health | ABC |
| Live Life | XYZ |
| PrettyWoman | XYZ |
| Dreams | LAK |
(viii) SELECT ProductName, Price * 4 FROM Product.
| ProductName | Price*4 |
| Talcom Poweder | 160 |
| Face Wash | 180 |
| Bath Soap | 220 |
| Shampoo | 480 |
| Face Wash | 380 |
Outside Delhi 2008
5.b. Consider the following tables Item and Customer. Write SQL commands for the statement
(i) to (iv) and give outputs for SQL queries (v) to (viii)
| Table: ITEM | ||
| I_ID | Item Name | Manufacturer Price |
| PC01 | Personal Computer | ABC 35000 |
| LC05 | Laptop | ABC 55000 |
| PC03 | Personal Computer | XYZ 32000 |
| PC06 | Personal Computer | COMP37000 |
| LC03 | Laptop | PQR 57000 |
| Table: CUSTOMER | ||
| C_ID | Customer Name | City I_ID |
| 01 | N.Roy | Delhi LC03 |
| 06 | H.Singh | Mumbai PC03 |
| 12 | R.Pandey | DelhiPC06 |
| 15 | C.Sharma | DelhiLC03 |
| 16 | K.Agarwal Banglore | PC01 |