Use the library database and run queries. 1) Draw the ERD of the database. Make sure to include "Books", "Authors", "St

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Use the library database and run queries. 1) Draw the ERD of the database. Make sure to include "Books", "Authors", "St

Post by answerhappygod »

Use the library database and run queries.
1) Draw the ERD of the database. Make sure to include"Books", "Authors", "Students", "Publications", and "Library"tables.
2) Determine the Primary Key and the Foreign Key of eachtable. Are there any other columns in the tables that can be usedas the Primary Key of the tables? If yes, explain why they qualifyas a valid candidate?
3) Is the current design of the database in 3rd normalform? If yes, explain why. If it is not normal, explain what stepsneed to be taken to normalize the database.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”