URGENTLY NEEDED!

Consider following given database design and write queries.

a. Write a query to create view named as Permissions which stores records having country_code, country_name, person_id, permission level code, permission level description having role_description of Employee and system manager.

b. Write a query to display Person_ID, Login_Name, Message_ID, Date_Message_sent, Payement_id, Date_Paid, Report_id and Date_Report_Sent.

.

Countries PK Country Code H Country Name + People PK Person_ID FK Country Code FK Permission_Level_Code FK Role_Code Login_Name Password Personal_Details Other_Details Roles PK Role_Code Role_Description eg Agent, Customer eg Employee eg Prospect eg System Managers Permission_Levels PK Permission_Level_Code Permission_Level_Description Internal_Messages PK Message_ID FK Msg_From_Person_ID FK Msg_To_Person_ID Date_Message_Sent Message_Subject Message_Text Payments PK Payment_ID FK Person_ID Amount_Due Reminder_Sent_YN Date_Reminder_Sent Date_Paid Amount_Paid Other_Details Monthly Reports PK Report_ID FK Person_ID Date_Report_Sent Report_Text