Question B. Add database design for the following business rules to the ERD. 1. The library provides a number of various collections include BOOKs, JOURNALs and MAGAZINEs. Every collection needs to have a collection code, title, year, publisher name, and ISSN or ISBN. In addition to the collection attributes, every book has at least one author. A journal usually has a volume and number attributes. A journal consists of journal papers, and a journal paper can be written by many authors. 2. Collections which have multiple copies must have a unique collection code for each copy3. A book and magazine can be borrowed for two weeks time period. Meanwhile, a journal is strictly three days loan period. 4. In the Giant University, a student can works as a university staff called EmployedStudent. 5. A student is allowed to borrow a maximum 5 collections from the library, but an EmployedStudent may borrow a maximum 10 collections. 6. Library system will issue a receipt with borrow date and due date of loans. 7. Borrowers who fail to return items by due date accrue fines as follows: a. Books and magazines penalty are $1 per item per overdue day, b. Journals penalty are $3 per item per overdue day. 8. For every overdue item, library will issue an invoice and borrower has to pay by bank transfer or credit card. Card number, expiry date, bank issue are recorded by the system PART 2 (40 marks) § Giant University expands its business worldwide, and for every site Giant University has developed a standalone database system with different database design and technology. § Recently, Giant University has a plan to connect all libraries from different sites. Students enrolled at any Giant University site can use their student ID to borrow collections at any Giant University Library. § Giant Library also digitizes their collections, such that all stakeholders can get information or borrow the collection online. § Based on this limited information, design a distributed database and system solution with the following format: 1. Distributed database design (25 marks): details your design of the database system from the following aspects: a. What is global design of the system? The use of diagram, use case diagram or any other diagrams will help to understand the system. (5 marks) b. Which commercial or non-commercial database system will you recommend? Describe the system and give reason to choose the particular system (5 marks) c. What query operations will be mostly used? Some examples of query will be valuable. (3 marks) d. What transaction management and concurrency control methods you may have used? (3 marks) e. What performance tuning and query optimization you may have used? (3 marks) f. What special consideration you may have for data replica/redundancy, data infusion/allocation, or ensuring transparency? (3 marks) g. What aspects of your design you would consider as unique or innovative? (3 marks) 2. Discussion (10 marks): evaluate the feasibility of your design, including technical and nontechnical issues such as exception handling, cost of implementation and maintenance of 3 | P a g e such system, scalability of system (adaptive to rapid expansion of data), migration to other platforms (for example, P2P or Cloud systems), selection of hardware and software (comparisons to alternatives) etc. 3. Conclusion (3 marks): conclude your report by highlighting the major features of your design. 4. Presentation of report (2 marks): the presentation style of the report should be consistent and neat, free of editing errors, respecting plagiarism policies. NOTE: § The outcome is a reasonable design; you don't need to implement the design. § Consider about how to fragment the database, if needed. § Consider about the using of NOSQL, HADOOP, CLOUD, AZURE, MONGODB or any other technology related to distributed database and Big Data. § Decide to pick any system, describe and give reason why your group decided to choose the system (can be the performance, features, price, etc) § Additional ideas will make the design unique