Use the library database and run queries. 1) Draw the ERD of the database. Make sure to include "Books", "Authors", "St
Posted: Fri Jul 01, 2022 5:58 am
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.
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.