For the purpose of the following problems, use the ER diagram

How do I change the above to have the Doctor ID as the first 2 letter of his first name followed by numbers. Eg. If the Doctors name is Ron Gates, then his DoctorID can be RO3283. The numbers do not exist else where in the database.

Person Personi FirstName Speciality Speciality SpecialityName LastName StreetAddress City Doctor Doctorid MedicalDegrees State Tip Personi PhoneNumber SSN DoctorSpeciality 8 Doctorib 8 Speciality D PVisitPrescription % Visit 8 PrescriptionID Patient 8 Patients SecPhone Number DOB Personi Patient Visit 8 VisitID Patienti Doctor VisitDate DocNote Prescription 8 Prescription PrescriptionName Test TestiD TestName PVisitTest 8 VisitD 8 TestID create table Person PersonID int not null Primary key, FirstName varchar(10), LastName varchar(10), StreetAddress varchar(30), City varchar(10), State char(2), Zip varchar(9), Phone Number varchar(15), SSN varchar(9) create table Doctor DoctorID varchar(6) not null Primary key, MedicalDegrees varchar(15), PersonID int, Foreign Key (PersonID) references Person (PersonID))