Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
1 Here is a excessivelevel design evaluate of the library database Tables Books which includes norma...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started