Library Management System: Database Project - Part V - Finalize Database
LMS Library Management System for Imaginary University 2nd year Database Project In order to maximize the use of system resources to perform work as efficiently and rapidly as possible the views and indices to be used were confirmed and some of the views were decided to materialize. In the application a user can search a book based on its authors, title and subject as well as ISBN number. Therefore by creating indices on tilte, authors and subjects the database can access relevant entries more efficiently. Since the table book_details is not updated frequently this will not cause for any low performance of the database. book_details create index book_title on book_details(title); create index book_publisher on book_details(publisher); create index book_category on book_details(category); cd_details create index cd_title on cd_details(title); create index cd_publisher on cd_details(publisher); create index cd_category on cd_details(category);...