1. Create both the tables Supplier and Item with appropriate attribute names, primary key, foreign key and data type. [3 marks]
2. Insert the above records into Supplier and Item tables. [2 marks]
3. Display all the records from Supplier and Item (Separately) [0.5 mark]
4. Display all the details of Item Name, Price and Country. [1 mark]
5. Display all supplier details from the country Hungary. [1 mark]
6. Write a PL/SQL program to display IName from the Item table where the ID 1. [1.5 marks]
7. Write a PL/SQL program to display all the details of Items with the type T2 using cursor. [2 marks]
8. Update Country as England for Supplier named Ansel. [1 mark]
9. Write a Function to receive a Supplier Name as Input and display the country of that Supplier. (Also write the calling program.) [2 marks]
10. Delete the Items which price is more than 500. [1 mark]

W - Microsoft Word - Document1 ( ) AA ) Calibri A" A+ Aa | || | xx, abe - UI B 1 " 10 || ' 5 Item Supplier IName | Price | Type | S_ID ID Country SName S ID Si T1 1341 AAA 1 America Alfred Si S2 T2 400 BBB 2 Bernard Hungary S2 S1 T1 150 CCC 3 America Ansel S3 S1 T2 340 DDD 4 : : ( ) = E = = w (w IC[ 11:11 ENG :) //