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

 

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 Expert Approved Answer
Step: 1 Unlock

1 Here is a excessivelevel design evaluate of the library database Tables Books which includes norma... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!