Given a basic SQL Server (Northwind) and MongoDB database (Northwind), import the data and explore the structure of the databases and how they are similar and different from each other.

computer science

Description

Investigate how data is stored in different types of databases

Explore a Database

Given a basic SQL Server (Northwind) and MongoDB database (Northwind), import the data and explore the structure of the databases and how they are similar and different from each other.

Use the following commands to import Northwind in Mongodb from the command prompt once MongoDB is installed.

*mongoimport -d Northwind -c categories --type csv --file categories.csv --headerline

*mongoimport -d Northwind -c customers --type csv --file customers.csv --headerline

*mongoimport -d Northwind -c employee-territories --type csv --file employee-territories.csv --headerline

*mongoimport -d Northwind -c employees --type csv --file employees.csv --headerline

*mongoimport -d Northwind -c northwind --type csv --file northwind.csv --headerline

*mongoimport -d Northwind -c order-details --type csv --file order-details.csv --headerline

*mongoimport -d Northwind -c orders --type csv --file orders.csv --headerline

*mongoimport -d Northwind -c products --type csv --file products.csv --headerline

*mongoimport -d Northwind -c regions --type csv --file regions.csv --headerline

*mongoimport -d Northwind -c shippers --type csv --file shippers.csv --headerline

*mongoimport -d Northwind -c suppliers --type csv --file suppliers.csv --headerline

*mongoimport -d Northwind -c territories --type csv --file territories.csv --headerline

1. Delieverable- Submit the Project Deliverable in a 2 page document that provides recommendations

 

2. First Choice Urgent Care has asked that you write a 2-page summary defining the basic concepts of a relational database management system and a NoSQL database and outline the advantages and disadvantages of each, so they can make a decision about which database management system to use. Consider the following questions:

  • What are the hardware and software requirements for the database?
  • How much will the database cost to operate?
  • What are the Pros and Cons of using the database?
  • What are the performance issues that you need to consider?
  • What are the relative merits of using the database?


Related Questions in computer science category


Disclaimer
The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.