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:
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
End of preview
Want to access all the pages? Upload your documents or become a member.