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:
Get Free Quote!
277 Experts Online