create database ProfStudent; use Profstudent; create table Profs ( profID INT, ProfLN char(15), ProfFN char(15), primary key (ProfID)); INSERT INTO Profs VALUES (1089,"Clark","Daniel"); INSERT INTO Profs VALUES (1094,"Rodriguez","Nancy"); INSERT INTO Profs VALUES (2033,"Lewis","Matthew"); INSERT INTO Profs VALUES (2109,"Lee","Betty"); INSERT INTO Profs VALUES (2248,"Walker","Anthony"); INSERT INTO Profs VALUES (2282,"Rodriguez","Juan"); INSERT INTO Profs VALUES (2472,"Allen","Dorothy"); INSERT INTO Profs VALUES (2592,"Young","Mark"); INSERT INTO Profs VALUES (2733,"Hernandez","Sandra"); INSERT INTO Profs VALUES (2989,"Clark","Mary"); show columns from Profs; select * from Profs; create table students ( StudID INT, SLName char(10), SFName char(10), SProf INT, primary key (StudID), foreign key (SProf) references Profs(profID)); INSERT INTO students VALUES (3889,"Smith","James",2033); INSERT INTO students VALUES (3890,"Johnson","Mary",1089); INSERT INTO students VALUES (3891,"Williams","John",2282); INSERT INTO students VALUES (3892,"Jones","Patricia",2033); INSERT INTO students VALUES (3893,"Brown","Robert",2733); INSERT INTO students VALUES (3894,"Davis","Jennifer",2989); INSERT INTO students VALUES (3895,"Miller","Michael",2033); INSERT INTO students VALUES (3897,"Wilson","Elizabeth",2109); INSERT INTO students VALUES (3899,"Moore","William",1094); INSERT INTO students VALUES (3924,"Taylor","Linda",2248); INSERT INTO students VALUES (3945,"Anderson","David",1089); INSERT INTO students VALUES (4105,"Thomas","Barbara",2109); INSERT INTO students VALUES (4156,"Jackson","Richard",2282); INSERT INTO students VALUES (4298,"White","Susan",2733); INSERT INTO students VALUES (4301,"Harris","Joseph",2989); INSERT INTO students VALUES (4452,"Martin","Jessica",2592); INSERT INTO students VALUES (4475,"Thompson","Thomas",2592); INSERT INTO students VALUES (5067,"Garcia","Margaret",2989); INSERT INTO students VALUES (5143,"Martinez","Joseph",2733); INSERT INTO students VALUES (6905,"Robinson","Sarah",2282); show columns from students; select * from students; select SFName as 'First Name', SLName as 'Last Name', concat(ProfLN, ', ',ProfFN) as 'Professor' From students, Profs where SProf = ProfID order by SLName;