Problem 1) Refer to Lab 1 (Problem 1), Lab 4 (Problems 3 and 4) and Lab 5 (Problems 1 to 4). You are required to design and implement Role Based Access Control mechanism for Pine Valley Furniture Company interface developed so far in above mentioned problems.
(a) As an initial step enhance the schema of PVFC database. Write enhanced schema below.
(b) Next enhance the solutions for above mentioned problems to take advantage of modified schema and incorporate role based access control for all interfaces. Write the updated code for any one of the above problems below.
(c) Develop test cases for role based access control.