Question: Create a sample database design for a library and draw one database model for it. The library wants to keep track of books (regular

Create a sample database design for a library and draw one database model for it. The library wants to keep track of books (regular books/electronic/audio); book authors; book genres; book location (area/shelves); customer information; books that the customers borrowed, when they are due, employee that checked them out; employee information; and employee working schedules. 1. [3] Design the database that makes sense for the problem and select fields that make the most sense. A complete screenshot of your final design model is required. 2. [10] Determine the tables, columns, primary keys, nullabilities and show relationships between tables (one -one/one-many/many-many). 3. [5] Normalize your design into 3rd Normal Form. Please use MS Visio or any similar database design tool. 4. [2] Explain your design, including relationship between tables.
Step by Step Solution
There are 3 Steps involved in it
1 Here is a excessivelevel design evaluate of the library database Tables Books which includes norma... View full answer
Get step-by-step solutions from verified subject matter experts
