4 Answer Q4(a) - Q4(e) based on the given case study in Figure Q4. MajuApparel is a women clothing store located in Parit Raja. The management, decide to reach wider market by implementing a web based shopping system using PHP and MySQL. The system must store customers' information which include customer id, customer name, address and phone number, email and password. The system should be able to add record, update, search and delete record. A login page is required so that only a registered customers are allowed to log into the system. The login interface should contain label "username" for the customer to enter their email as their login id, label "Password" for the customer to enter their password and a submit button "Login". After a successful login the customer can view their personal information and their shopping history in their user profile page. Assume the database name is Apparelshop and table is Custinfo. Figure Q4 (a) Construct a program to implement the following task: (i) connect with the database (ii) add record into custinfo (iii) display record of Custinfo (iv) search record based on customer name (v) delete record based on customer id (10 marks) (b) Propose a user interface design for user login based on information in Figure Q4. (5 marks) c) Build the proposed login interface in Q4(b) using HTML markup language. (5 marks) d) Write a pseudo code to identify either the user login receive valid verification or invalid verification (5 marks) e) Discuss FIVE (5)requirements needed to build a login page on a website. (10 marks)