Week+7+Writing+Prompt

Week 7 Writing Prompt
Imagine that you are creating a database that will hold information for your school library. You want the database to allow students to see (1) what books they have currently checked out and, (2) the dates the books are due back to the library.

For this weekly prompt:


 * 1) Design the database tables you would create to store this information (i.e. a user or account table? A books table?) -- you can do this in Microsoft Word to demonstrate the idea (understanding you'd do this in a database program in practice)
 * 2) In those tables, show what data fields you would need in each table (and fill in some sample information in those tables)
 * 3) Communicate which data field(s) are needed in each table to create a relationship between the tables
 * 4) Write the SQL statement you would use to retrieve a list of book names that a specific user has currently checked out
 * 5) Write the SQL statement you would use to retrieve the due date for one of the books that a specific user has currently checked out