L

@lylefre

final project results

MongoDB
11 hours ago
db.createCollection("AUTHOR"); db.createCollection("BOOKAUTHOR"); db.createCollection("BOOK"); db.createCollection("BORROWEDBOOKS"); db.createCollection("MEMBER"); // Insert into AUTHOR db.AUTHOR.insertMany([ { authorID: "A01", firstName: "Geor

final project results

MongoDB
11 hours ago
db.createCollection("AUTHOR"); db.createCollection("BOOKAUTHOR"); db.createCollection("BOOK"); db.createCollection("BORROWEDBOOKS"); db.createCollection("MEMBER"); // Insert into AUTHOR db.AUTHOR.insertMany([ { authorID: "A01", firstName: "Geor

2.6

MongoDB
11 hours ago
db.MEMBER.aggregate([ { // Join with BORROWEDBOOKS to see who borrowed what $lookup: { from: "BORROWEDBOOKS", localField: "memberID", foreignField: "memberID", as: "borrowing_info"

2.5

MongoDB
11 hours ago
db.BORROWEDBOOKS.deleteOne({ fineAmount: 50 });

2.4

MongoDB
11 hours ago
db.BORROWEDBOOKS.aggregate([ { $group: { _id: null, totalRevenue: { $sum: "$fineAmount" } } } ]);

2.3

MongoDB
11 hours ago
db.BOOK.find({ publicationYear: { $gt: 2026 } });

2.2

MongoDB
11 hours ago
// Insert into AUTHOR db.AUTHOR.insertMany([ { authorID: "A01", firstName: "George", lastName: "Orwell" }, { authorID: "A02", firstName: "Jane", lastName: "Austen" } ]); // Insert into BOOK // (Note: Included one book published after 2026

2.1

MongoDB
11 hours ago
db.createCollection("AUTHOR"); db.createCollection("BOOKAUTHOR"); db.createCollection("BOOK"); db.createCollection("BORROWEDBOOKS"); db.createCollection("MEMBER");

1.2

MongoDB
11 hours ago
// Insert into AUTHOR db.AUTHOR.insertMany([ { authorID: "A01", firstName: "George", lastName: "Orwell" }, { authorID: "A02", firstName: "Jane", lastName: "Austen" } ]); // Insert into BOOK // (Note: Included one book published after 2026

1.1

MongoDB
11 hours ago
db.createCollection("AUTHOR"); db.createCollection("BOOKAUTHOR"); db.createCollection("BOOK"); db.createCollection("BORROWEDBOOKS"); db.createCollection("MEMBER");