Date: Friday, 06 March 2026
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 a Role Based Access Control mechanism
for Pine Valley Furniture Company interfaces developed so far in the above mentioned problems.
(a) As an initial step, enhance the schema of the PVFC database.
Write the enhanced schema below.
(b) Next, enhance the solutions for the above mentioned problems to take advantage of the modified schema and incorporate role based access control for all interfaces. Write the updated code for any one of the above problems below. (Develop in Visual Studio.)
(c) Develop test cases for role based access control. (Write your test cases below.)