database project

CSCI 340 - Introduction to Database - Project 2

Instructor: Song Huang; Email: [email protected] Due on: 04/24/2021 11:55 PM (Saturday)

Requirement: What you need to do for Project 2:

• Zip all of your source code and submit the Zipped file

• Attach a PDF file which should include your design of the project, some paragraphs to describe the functions if there is any

• Prepare a 2-minute presentation for this project, you can submit the presentation record- ing or attend a live session and present your project. In the presentation, you will need show the instructor how you run your program, and show different functions of your project, your tables in your database.

Grading:

• A functional project and source code: 70%

• Documentation (the PDF file): 10%

• Presentation: 20% Late Policy: No late submission will be accepted, except some important things happened. Student are required to email instructor and provide proofs.

1 Background

This project will be short project, and only requires you to get started with MongoDB.

MySQL, we used earlier, is a Relational Database Management System (RDMS). A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database.

MongoDB is a source-available cross-platform document-oriented database program. Clas- sified as a NoSQL database program, MongoDB uses JSON-like documents with optional schemas. MongoDB is developed by MongoDB Inc. and licensed under the Server Side Pub- lic License (SSPL).

2 Steps

2.1 Create a FREE account on MongoDB Atlas

MongoDB Atlas is Cloud-hosted MongoDB service on AWS, Azure and Google Cloud. Follow the link to register MongoDB Atlas: https://www.mongodb.com/cloud/atlas/register

1

2.2 Use API to perform CRUD operation on MongoDB Atlas

• Install Mongo Driver for your programming language (Python, Java)

• Connect you program to MongoDB via the MongoDB Driver

• Perform Create, Read, Update, Delete (CRUD) using a small sample dataset.

Screenshot the Results and Attach to a PDF file.

3 Use these References

• python to MongoDB: https://www.mongodb.com/blog/post/getting-started-with-python-and- mongodb

• Java to MongoDB: https://www.mongodb.com/blog/post/getting-started-with-mongodb-and- java-part-i

Try any of this out, and it won’t take you long to finish the project.

2