Hello! I am putting together an Entity Relationship Diagram for a DBMS class. If I wanted to see how I should document a first_name and last_name instance on two separate tables. Would that be a foreign key? I want to make it when I update the opportunity record, the student record will also update. Can someone check and see if I made any other mistakes?

Thanks!

EnrollmentAdvisor PK EnrollmentAdvisorlD EnrollmentAdvisorLastName EnrollmentAdvisorFirstName AcademicAdvisor PK AcademicAdvisorID AcademicAdvisorLastName AcademicAdvisorFirstName Student Record PK StudentID FK AcademicAdvisorID FK Student EnrollmentID FK Mailing Address Phone Number School_Email_Address Student Status Opportunity Recoro PK OpportunitylD FK EnrollmentAdvisorlD FK StudentiD FK SourceCodelD FK MailingAddressID First Name Last_Name Home Phone Work_Phone Mobile_Phone Email_Address EmployerName Last_Called Date Last Contacted Date Last Emailed _Date Opportunity_Stage Opportunity_Status Marketing SourceCode PK SourceCode|D Vendor Name Lead Cost Student Enrollment PK Student_EnrollmentID FK StudentID FK ProgramID ClassID AdmitDate GraduationDate H Program PK ProgramlD FK CourselD ProgramDescription Mailing Address PK Mailing_AddresslD HH Address 1 Address 2 City State Zipcode Time Zone Country Courses PK CourselD Course Section_Number FK ProfessorID Start_Date End Date Course Cost Professor PK ProfessorID Professor FirstName Professor LastName