Both Questions Are Important

Root Departments CS/IT IBMS D11 D12 BBA IBMS D13 DVM New block Students S16 Aslam 25 male charsadda S14 sana 23 Female Sawabi S11 java C++ ali 25 male Peshawar Accounting 50 50 Economics 60 75 S12 zia 26 male Mardan S15 salih 25 male Sawat java php botany 80 islamyat 60 botany 75 English 56 S13 kamil 22 male Sawabi 65 50 Subject marks Python 50 C++ 70 S17 Aslam 25 male charsadda Q1. Convert the following hierarchal model to Relational model and then to network model And discuss which model is Suitable model for database and Why? Q2) Define stored procedure. Explain the creating calling of stored procedure with suitable example. And take screen shot of your query having your name and class number as comment