Exercise 22.5

a) Select * From Authors

b) Select * From Publishers

c) Select Title, ISBN, YearPublished
    FROM Titles, AuthorISBN
    WHERE Titles.ISBN = AuthorISBN.ISBN AND AuthorISBN.AUthorID = 1
    ORDER BY Title

d) Select Title, ISBN
    FROM Titles
    Where PublisherID = 1
    ORDER BY Title

Exercise 22.6

a) INSERT INTO Authors ( FirstName, LastName, YearBorn )
    VALUES ( 'Nigel', 'Lee', 1982 )
   
b) INSERT INTO Titles ( ISBN, Title, EditionNumber, YearPublished, Description, PublisherID )
    VALUES ( '0-13-012345', 'CS80 Book', '3', '1993','', 2)
    INSERT INTO AuthorISBN ( ISBN, AUthorID)
    VALUES ( '0-13-012345', 1)

c) INSERT INTO Publishers( PublisherID, PublisherName)
    VALUES ( 3, 'CS80')