Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. A banking system implemented multilevel security to control access to data. The users in the banking system can have access to the below given

image text in transcribed
image text in transcribed
image text in transcribed
2. A banking system implemented multilevel security to control access to data. The users in the banking system can have access to the below given table by giving an SQL command through an application. Users and their security level ate mentioned. Each data in the table has its security classification Answer the following questions based on the given information Users_Bank_Mgr- (S), Branch_Mgr(TS), Clerk (0) Table Name: Bank Mast Cut CS109 CSITO CS111 C Cowo Ahmed wiec wwwc Ace Type Current Lo TS Savings is CSIIRU Abdul U Just TS a) Fill in the data that can be accessible by the user according to their security clearance using filtering after executing "Select Cardshoan from Bask_Main where Acc No-'CS111"" Marks CUWA 13 USERS Bank_Mgr Clerk Branch_Mgr b) Identify the apparent key for the above table (Bank Main) and give ther? [ Marks 2. A banking system implemented multilevel security to control access to data. The users in the banking system can have access to the below given table by giving an SQLcommand through an application. Users and their security level ate mentioned. Each data in the table has its security classification. Answer the following questions based on the given information Lisers_Bank_Mgr - (S), Branch_Mgr(TS), Clerk (U) Lable Name: Bank Masi Acc_Type Current Curso CS109 CSI10C CSIC CUWA - Ahmed C wotec uve Abdul U Loan TS Savings TS CSITU Joint TS ) Fill in the data that can be accessible by the user according to their security clearance using filtering after executing "Select Cars from Bank_Main where Ace_Now'CS111: 13 Marks CUWS Ace Type USERS Bank_Mgr Clerk Branch Mgr b) Identify the apparent key for the above table (Bank Main) and give the reason? [1 Marks) 2. A banking system implemented multilevel security to control access to data. The users in the banking system can have access to the below given table by giving an SQL command through an application. Users and their security level are mentioned. Each data in the table has its security classification. Answer the following questions based on the given information. Users: Bank_Mgr - (S), Branch_Mgr(TS), Clerk (U) Table Name : Bank Mast Cust.de Cust. Name Ace_Type CS109 C Ahmed C Current S CS110C Taqdeer C Loan TS CS111 C Hanadi C Savings TS CS112 U Joint TS Abdul a) Fill in the data that can be accessible by the user according to their security clearance using filtering after executing "Select Cust.Name.Ass Type from Bank_Main where Acc_No='CS111';" [3 Marks) USERS Cust. Same Acc_Type Bank_Mgr Clerk Branch_Mgr b) Identify the apparent Key for the above table (Bank Main) and give the reason? [1 Marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

MySQL/PHP Database Applications

Authors: Jay Greenspan, Brad Bulger

1st Edition

ISBN: 978-0764535376

More Books

Students also viewed these Databases questions

Question

Draw a schematic diagram of I.C. engines and name the parts.

Answered: 1 week ago