#Getting Started:# The questions can be answered within the appropriate file. (I.e. Question 1 can be answered in the file: question_1.php) unless otherwise stated in the question.

Each file will contain further instructions on where to insert your code.

#Question 1:# Given a MySQL database with the following tables:

CREATE TABLE `customer` (
  `customer_id` INT(11) NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(30) NOT NULL,
  `first_name` VARCHAR(255) NOT NULL,
  `last_name` VARCHAR(255) NOT NULL,
  `customer_occupation_id` INT(11) DEFAULT NULL,
  PRIMARY KEY (`customer_id`)
)

CREATE TABLE `customer_occupation` (
  `customer_occupation_id` INT(11) NOT NULL AUTO_INCREMENT,
  `occupation_name` VARCHAR(255) NOT NULL,
  `salary` INT(7) NOT NULL,
  PRIMARY KEY (`customer_occupation_id`)
)

Modify the file question_1.php to show the list of all customers from the table customer together with their occupations from the customer_occupation table in the MySQL database to display on a web page.

A database connection will need to be created

If the customer does not have a matching occupation, please list them as 'un-employed'

Finally, include an optional GET parameter named occupation_name which can be accepted from the user to filter and display any customers with a matching occupation_name

I.e: A request such as: /question_1.php?occupation_name=Manager will display all customers with an occupation of: "Manager"

#Question 2:# There are 3 types of customers:

• Bronze
• Silver
• Gold

Whenever a deposit is made:

• Bronze customers do not receive any extra credits
• Silver customers get 5% extra credit added their account balance (e.g. depositing $100 gives them $105)
• Gold customers get 10% extra credit added to their account balance (e.g. depositing $100 gives them $110)

Using question_2.php, create sub-classes of the Customer class for the 3 customer types - Bronze_Customer, Silver_Customer, and Gold_Customer

Create the deposit method(s) called deposit() that takes the deposit amount as its argument and increments the $balance of the object by the deposit amount PLUS the extra credit (if any)

#Question 3:# The first character of the customer IDs represents the customer type:

• B for Bronze
• S for Silver
• G for Gold

The customer ID is then followed by a set of numbers (no longer than 10 characters total).

So a customer with customer ID: 'B2345' is a Bronze customer, 'S5678' is a Silver customer, and 'G1234' is a Gold customer.

Use your file question_2.php and create a factory method called 'get_instance()' to instantiate the correct object (Gold, Silver or Bronze customer) given a customer ID described above.

When an invalid customer ID is passed to the factory method, make it throw an InvalidArgument exception

#Question 4:# When a new customer is created, a unique username needs to be generated for the customer.

As per the requirements around customer IDs outlined in Question 3 the customer's username needs to begin with a specified character as follows:

• B for Bronze
• S for Silver
• G for Gold

The username is then followed by a set of alphanumeric characters (no longer than 30 characters total). It cannot contain any special characters or spaces.

For example, a Bronze customer may have the following generated username: B2b6483600ewq6

Utilize the customer class(es) you have setup in question_2.php and add any required additional methods/members to these classes where appropriate in order to provide method(s) called generate_username() which will generate and return a valid username as a string

#Assumed database credentials:# Host: localhost / 127.0.0.1 Port: 3306 Username: test Password: test Schema: test

#Some assumed coding standards:# DocBlocks are required for all functions/classes. All DocBlocks must comply with PHPDoc standard. Please assume Register Globals is disabled within your PHP environment - you must utilize superglobals where appropriate.