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 the Role Based Access Control mechanism for Pine Valley Furniture Company interfaces developed so far.

(a)

As an initial step, enhance the schema of the PVFC database. Write an 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.