You optimize a library database schema for scalability. Simulation Details: The Library Management System Company, founded in 2008, specializes in creating software solutions tailored to the unique workflows of libraries. Its initial cataloging and inventory management system significantly improved productivity for local libraries, leading to widespread adoption. Over the years, the company has introduced innovative features like borrowing-tracking modules and advanced analytics, helping libraries optimize their collections and reduce inefficiencies. Today, the company serves over 1,200 libraries across 15 countries, processing half a million borrowing transactions daily. Its technical stack, including Java Spring Boot and PostgreSQL, ensures scalability and reliability, even during peak transaction periods. Recent advancements, such as predictive analytics, have positioned the company as a leader in library management software, though challenges in database schema design remain critical to address for future growth. Step into the role of a Java Developer specializing in Spring Boot applications at the Library Management System Company. Your mission is to refine the LibraryDataModel.java file, a key component of the company’s database schema. Collaborate with Elizabeth Carter, the lead architect, to address issues in entity relationships and constraints. You will implement JPA-compliant mappings, optimize fetch types, and ensure data integrity by adding constraints. Throughout the simulation, you’ll justify your design decisions to Elizabeth, demonstrating your understanding of schema design principles and performance optimization. Your work will directly contribute to the scalability and maintainability of the library management system. - Collaborate with Elizabeth Carter to refine the LibraryDataModel.java file. - Implement JPA-compliant entity relationships, including bidirectional mappings. - Optimize fetch types for performance and access patterns. - Add a unique constraint to the User's email field to ensure data integrity. - Justify your design decisions through real-time chat discussions with Elizabeth. - Achieve measurable improvements in query performance and scalability.