Task $3$: Update Employee Information

As the new database administrator, your next task is to update the employee information in order to bring it up to date. Specifically, you need to add

email and phone information for each employee based on certain rules, however more information may be available in the future. Keep this in mind as

you design your implementation.

Instructions:

Email Requirements

First letter of $[$first$\_$name$][$last$\_$name$]+$ @company.net address. For example, if the employee name is Waldo Weber, then his email address

should be

wweber@company.net

IF the email address is taken, that is another employee has the same last name and has the same first initial, then, add the sequential number.

For example, if after Waldo got his email, you have a Walter Weber employee. In this case, Walter's email address should be

wweber$1$@weber.net.

Every employee must be assigned an email address.

For those employees whose title contains the word 'Senior', you need to add a second personal email address, following the same rules as above.

For example, if Waldo's title is 'Senior Engineer', you will add a personal email as:

wweber@personal.com

Phone Requirements

The company must have $801-6xx-xxxx,$ where $x$ is the employee number. The employee numbers range from, $10001$ to $499999.$ Note: if the

employee number is shorted than $6$ digits, you should pad it with zeros. For example, if Waldo's employee number is $12345,$ then the phone

numbers should be constructed as: $801-601-2345.$

Note: there may be other phone numbers available in the future: cell, home, etc.

Every employee must be assigned a phone number

Submission Checklist:

Store all your SQL commands in a file called task$3.$sql

Store all your connector code in a file called

task$3.$py or whatever extension your chosen language uses.