Sql Projects

Authors Database

Need an database to store author information and the books that they have written.

First Solution

Your first solution should allow for any 1 author to be the author of record for many books.

Tables Needed

Authors

Books

Stored Procs Needed

The videos cover stored procedures. If you cannot build stored procedure please write out the SQL statements and save the scripts to a folder on your desktop.

To Select All Authors and return only Author information

To Select All Books and return only book information

To Select all Books written by a given Author (the proc should accept an authorId)

To Select All Authors that have written a book and return both author and book information by row.

Second Solution

Should allow for multiple authors on 1 book.