MongoDB is an open-source document-oriented database that is designed to store a large scale of data. It is categorised as a NoSQL (Not only SQL) database because the storage and retrieval of data in the MongoDB are not in the form of tables and querying does not have to be done using SQL. Additional learning materials for MongoDB can be found on COMP643 LEARN Page.

 you used a database to maintain a library of e-books for the Computing Department at Lincoln College. Convert a subset of this database to document database using MongoDB to capture information about book, checkout and patron. The key consideration for the structure of your database documents is the decision to “embed” or “use references”.

Use these three tables to create your document database.

Evaluations of the Document Database

You have been asked by A College to investigate the possibility of setting up a digital library for the college. The college has a total of 3,000 students, 1,200 staff and more than 10,000 collections of e-books. Write a one-page summary (excluding references) to discuss the suitability of a document database to store and manage the digital library. Your discussion should consider three factors. These factors may include data model (schema flexibility), usability and performance, data integrity and accuracy, functionality, security and cost.
 

BOOK Book Num Book Title 5235 5236 5237 5238 5239 CHECKOUT Check Num 91001 91006 91010 91005 91011 91004 91057 91068 Beginner's Guide to Java Database in the Cloud Mastering the Database Environment Conceptual Programming Java First Steps Book_Num 5235 5235 5235 5236 5236 5237 5238 5238 Pat_ID 1165 1203 1161 1202 1181 1160 1224 1229 Book Year Book_Cost 2014 2014 2015 2015 2015 Check Out Date 2023-03-31 2023-04-05 2023-04-05 2023-03-31 2023-04-05 2023-03-31 2023-05-10 2023-05-24 59.95 79.95 89.95 59.95 49.95 Check_Due Date Book_Subject Programming Cloud Database Programming Programming Check_In_Date 2023-04-14 2023-04-09 2023-04-12 2017-04-13 2023-04-19 2023-04-05 2023-04-07 2023-04-08 2023-04-12 2023-04-11 2023-04-14 2023-04-03 2023-05-17 2023-05-11 2023-05-31 NULL