Write retrieve suppliers list than list marks
June,2018,
ITDA1001 Assignment!
,(2,Marks), Q2),What!is!weak!entity?!Explain!it!with!example.,
(2,Marks),Q3)! Notown! Records! has! decided! to! store! information! about! musicians! who! perform! on! its! albums!(as!well!as!other!company!data)!in!a!database.!The!company!has!wisely!chosen!to!hire! you!as!a!database!designer!(at!your!usual!consulting!fee!of!$2500/day).!
• Each!musician!may!play!several!instruments,!and!a!given!instrument!may!be!played!by several!musicians.
Each!album!has!a!number!of!songs!on!it,!but!no!song!may!appear!on!more!than!one•
album.
ITDA1001 Assignment!
| ORDER,DETAIL, | |||
|---|---|---|---|
|
|||
| HPSERVER10Processor, | HP,Enterprise,DL,380, Gen,10,with,4114,10, core,processor., |
|
|
|
|||
• Retrieve!a!list!of!Northwind’s!Customers!(names)!who!are!in!cities!where!there!are!no suppliers.
• List!all!the!product!names!from!Tokyo!Traders!where!the!product's!unit!price!is!greater than!the!average!unit!price!of!all!products.