C Suppliers Type Introductio To Database Sql Ser

By /

C Suppliers Type Introductio To Database Sql Ser

Introduction to Databases

Step 1: First learn about Databases

Step 2

Apply the concepts of data and databases by learning to install a SQL and No-SQL Database

(Instructions to install or just login)

Step 3

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

# TASK

Submit the Project Deliverable in a 2 page document that provides recommendations

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?