MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE IF NOT EXISTS `Faculty`
(
    FacultyID int not null primary key auto_increment,
    FirstName varchar(255) not null,
    LastName varchar(255) not null,
    Email varchar(255) not null default(lower(concat(firstname,'.',lastname,'@wossamotta.edu'))),
    unique(Email)
);
create view FacultyEmail
  as select FacultyID, Email from Faculty;
insert into Faculty (firstname, lastname) values ('Yarrow', 'Hock');
select * from FacultyEmail;


FacultyID
Email


1
yarrow.hock@wossamotta.edu


select * from Faculty;


FacultyID
FirstName
LastName
Email


1
Yarrow
Hock
yarrow.hock@wossamotta.edu


-- Updating the view updates Faculty.
update FacultyEmail set email = 'yhock@hotmail.com';

Rows matched: 1  Changed: 1  Warnings: 0


select * from Faculty;


FacultyID
FirstName
LastName
Email


1
Yarrow
Hock
yhock@hotmail.com


-- Deleting the view deletes from Faculty.
delete from FacultyEmail where email = 'yhock@hotmail.com'
select * from Faculty;


FacultyID
FirstName
LastName
Email