Database Development and Management with SQL - Cloud Database Development and Management - page 154

Figure 4.16 Log on to SQL database portal to manage Class_Registration.

INSERT INTO FACULTY (FacultyID, FirstName, LastName)
VALUES(3, 'Mary', 'Fry')

INSERT INTO FACULTY (FacultyID, FirstName, LastName)
VALUES(4, 'Jen', 'Garza')

— - inserting records into STUDENT
INSERT INTO STUDENT (StudentID, FirstName, LastName, FacultyID)
VALUES(10, 'Liz', 'Cox', 1)

INSERT INTO STUDENT (StudentID, FirstName, LastName, FacultyID)
VALUES(11, 'Joe', 'Cole', 2)

INSERT INTO STUDENT (StudentID, FirstName, LastName, FacultyID)
VALUES(12, 'Linda', 'Diaz', 1)

INSERT INTO STUDENT (StudentID, FirstName, LastName, FacultyID)
VALUES(13, 'Don', 'Ford', 3)

INSERT INTO STUDENT (StudentID, FirstName, LastName, FacultyID)
VALUES(14, 'Jen', 'Brooks', 4)

INSERT INTO STUDENT (StudentID, FirstName, LastName, FacultyID)
VALUES(16, 'Bruce', 'Cox', 3)