Ask a question from expert

Ask now

Student Name:. Student ID:. Tutorial 5. (To be submitte

4 Pages241 Words217 Views
   

Added on  2020-03-02

Student Name:. Student ID:. Tutorial 5. (To be submitte

   Added on 2020-03-02

BookmarkShareRelated Documents
Student Name:Student ID:Tutorial 5(To be submitted Tuesday Week6)Given the following tables (in 3NF):itemColor (item(FK), color)item (item, price(FK))tax (price, tax)Write SQL queries for the following questions:1.List item, price and color of all items, whose price is 25.SQL Query: SELECTitem.item,item.price,itemcolor.colorFROMitemINNER JOIN itemcolor ON itemcolor.item = item.itemWHEREitem.price = 25;Screenshot:
Student Name:. Student ID:. Tutorial 5. (To be submitte_1
2.List all items name, color, price and tax whose name is “polo”:SQL Query:SELECTitem.item,itemcolor.color,item.price,tax.taxFROMtaxINNER JOIN item ON item.price = tax.priceINNER JOIN itemcolor ON itemcolor.item = item.itemWHEREitem.item = 'polo';Screenshot:3.List all item names “T-shirt” and “sweatshirt”, whose color is “blue” and “black”:SQL Query:SELECTitem.item,itemcolor.colorFROM
Student Name:. Student ID:. Tutorial 5. (To be submitte_2

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Management System
|17
|1391
|112

Data Base Design Question and Answer 2022
|9
|1259
|21