SOLVED BUAN 6320 - Project Part 2
Functional Requirements and grading Design and DB Architecture [20 points] Data Load, data generation [20 points] Book Search and Availability [30 points] Reports [30 points]
Description
Generate test data to simulate borrowing transactions
Reports and Search SQL
Design and DB Architecture
Data Load, data generation
2.1
Book Search and Availability
1.
Reports
1.
Database Connection
Password - LibraryUser2
Connection String - mongodb+srv://LibraryUser2:LibraryUser2@librarycluster.mglbdjd.mongodb.net/test
Database and Tools
Tables Names - Naming Convention
books - Load from books.json
book_copies - Load from
Load Files
Borrowers file: borrowers information, such as name, SSN (dummy), address, etc. Library branches file: branches address information
Functional Requirements and grading
You should not add any additional tables. To satisfy project requirements you will need to add attributes to the existing tables. For example, to support borrowing and return of the books you can add attributes to either
Design and DB Architecture [20 points]
Deliverables:
Data Load, data generation [20 points]
Write MongoDB Script to generate (create/insert/update ):
Exactly 20 books check-outs for exactly 10 different borrowers and exactly 10 different books. Same borrower should not check out same book more than once
Deliverables:
Book Search and Availability [30 points]
Write MongoDB command that will locate a book given any combination of ISBN, title, and/or Author(s). Your query should support substring matching. For example, search for “will” should return results whose title include “will” or “willing”, or whose author name contains “Will”, “Willy”, “William”, etc.
Search should display the following information for each book in the result set:
Reports [30 points]
Design and write MongoDB shell script for 3 reports. The reports can accept input parameters, for example branch or date.
Number of books (book copies) per library branch.
Project report
I strongly recommend using markdown editor to generate your report. One example of such editor is Typora. Alternatively you can use Microsoft Word.
Both, project report and ER diagram should be packaged into single file and uploaded into eLearning by due date. Final project report should be in PDF format and include all pictures, diagrams and SQL code. Don't
submit or files. If you submit format other than PDF, there will be 20 points deduction.
Example of the the connect string you should provide:
The above connection string should be generated from the MongoDB Atlas Connect screen:
Bonus points (10 points)
following structure. Name your collection: documents in your new collection as in the provided
. You should end up with same number of file. Your new collection should have exact
"ISBN10": "055321215X", "ISBN13": "9780553212150",
"Title": "Pride And Prejudice",
"book_copies": [
{
"branch_id": 2,
"no_of_copies": 1
},
{
]
},{
"$oid": "6147925cb38887fa243c2442"
},
"Pages": "672",
"Authors_arr": [ "Kiana Davenport", "Margarete Längsfeld"
"no_of_copies": 1
},
{
"branch_id": 3,
"no_of_copies": 1
},
]
}
