Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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,
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_TextStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started