ADVANCE DATABASE MANAGEMENT

SECTION B - 40 MARKS Answer all questions in Section B. QUESTION 4 As a database administrator, you have been hired to develop a database-backed Web application referred to as e-Passport to support the activities of the Passport Office in your country. e-Passport has a Web page that can be used by applicants in applying for passports. a. Using diagram(s), design a layered software architecture for e-Passport indicating the various layers in your architecture. [12marks) b. List one specific software that could be used to implement each of the layers in your architecture in 4.a. for each of the following environments: i. .NET (dot NET) platform. [4 marks) ii. Windows (but not dot NET) [3 marks) iii. Linux [3 marks) c. e-Passport is anticipated to process and display an interactive map in a web browser showing the address (spatial information) of the applicant. i. Using diagram(s), re-design your layered software architecture in 4.a for e-Passport to perform the task in 4.c. Show the various layers in your modified architecture [12marks) List one specific software that could be used to implement each of the layers in your architecture in 4.c assuming that the Passport Office's database is implemented in PostgreSQL [6 marks) [40 MARKS SECTION B - 40 MARKS Answer all questions in Section B. QUESTION 4 As a database administrator, you have been hired to develop a database-backed Web application referred to as e-Passport to support the activities of the Passport Office in your country. e-Passport has a Web page that can be used by applicants in applying for passports. a. Using diagram(s), design a layered software architecture for e-Passport indicating the various layers in your architecture. [12marks) b. List one specific software that could be used to implement each of the layers in your architecture in 4.a. for each of the following environments: i. .NET (dot NET) platform. [4 marks) ii. Windows (but not dot NET) [3 marks) iii. Linux [3 marks) c. e-Passport is anticipated to process and display an interactive map in a web browser showing the address (spatial information) of the applicant. i. Using diagram(s), re-design your layered software architecture in 4.a for e-Passport to perform the task in 4.c. Show the various layers in your modified architecture [12marks) List one specific software that could be used to implement each of the layers in your architecture in 4.c assuming that the Passport Office's database is implemented in PostgreSQL [6 marks) [40 MARKS