Database Library System -- 2

Best wishes for a wonderful day. SQL is required for this endeavour. Currently, I only have to complete CLO2. For this endeavour, an Entity-Relationship Diagram (ERD) and a database diagram are essential components. In addition, it is essential to include DDL and DML instructions. These are the only elements that are genuinely required. After the construction of the entire database, it will still be necessary for you to construct queries using SQL server in order to respond to the inquiries. Needed by Nov 5th.