To create a collection called msgs under dbs

Assignment Help Database Management System
Reference no: EM131418661

Assignment: Internet DB

This project is to get familiar with one noSQL DB: MongoDB.

I would like to see some screenshots that shows your work. Students can use snipping if it is in Windows to capture screenshots and paste them into word doc.

Instructions (for windows only. Linux/Mac should be similar)

Detailed instruction is in attachment.

1. download mongodb from https://www.mongodb.com/dr/fastdl.mongodb.org/win32/mongodbwin32-x86_64-2008plus-ssl-3.4.2-signed.msi/download

2. install MongoDB.

3. setup PATH environment variable to tell the operating system where to look for application, mongod or mongo in this case. If a student is not sure, googling on "setup computer ENV, PATH". Attachment 1 is a help for this.

4. make a data store for your mongoDB

Students need to make a dir under C: called myMongoDBdata that will store all the data. Here is the command (C:\ is not part of command. It shows the current directory)

C:\mongod --dbpath "C:\myMongogDBdata"

5. run mongo inside a CMD and practice the following commands to get to know more on mongo

>help

>show dbs

>show collections

>use IASPtestDB

> message = { author: "Zee Chen", date: 03/07/2014, text:"Yak", tags: ["advanture", "positive"]}

>db.t.save(message)

>db.t.find()

Submissions

1) A screenshot with CMD (may need to run as an administrator) which shows the result of typing

a) PATH

b) mongo

2. A screenshot that shows the result of the following command.

mongod --dbpath "C:\myMongogDBdata"

Answer the purpose of the above command? Why does it needed before you start mongo?

3. A screenshot of a CMD that runs mongo, and show dbs and show collections.

Answer the difference between dbs and collections

4. Create a dbs named as "IASP565DB", its collection called "smartD". You need to create a schema that can accommodate the following information: the name of a smart device, the maker of the device, the type, the date, the color and note area. You need to create five records. Write down your schema. Paste a screenshot that shows five such records.

5. To create a collection called "msgs" under dbs named "IASP565DB". You need to create a schema that can accommodate the following information. As you know, when you in the chat mood, you are constantly send out a new message, reply to a message. So each message should have a user name like 'tellthetruth', the date and the time that the chat was created, the content of the chat, a reply or several pieces of reply to this chat. Remember, each reply is just like a chat that should have all the informations. Write down your schema. Paste a screenshot that shows a chat that has one reply and another chat has two pieces of reply.

Attachment:- Assignment File.rar

Reference no: EM131418661

Questions Cloud

What would you predict for your gpa : If you plan to study 8 hours per week, what would you predict for your GPA?- If you plan to study 10 hours per week, what would you predict for your GPA?
Summarize a case decision where an employer or union : Discussion: Locate and briefly summarize a case decision where an employer or union was found guilty of bad faith bargaining ( or not!). Briefly summarize the decision and explain whether you agree or disagree with the outcome. Make sure to post t..
How management or a union bargaining power : Discussion #1: During an economic recession, discuss how management's or a union's bargaining power might be affected. Give an appropriate business example to illustrate what you mean, support it with at least one reference.
Create the scatterplot for given scores : Create the scatterplot for these scores.- Calculate the mean and standard deviation for the variable "number of candidates supported."
To create a collection called msgs under dbs : To create a collection called "msgs" under dbs named "IASP565DB". You need to create a schema that can accommodate the following information. As you know, when you in the chat mood, you are constantly send out a new message, reply to a message
Discuss all the aspects of performance management : Discuss all the aspects of performance management in a firm. Select any firm and draw illustrations.
Normalized the erd to third normal form : In your Learning Team this week,you normalized the ERD to third normal form (3NF). This is a key element in effective database design.
Describe the characteristics of a system engineer : As a manager of a system engineering department, what steps would you take to ensure that your organization maintains a lead position relative to technical competency?
Select three relevant and appropriate scholarly articles : Select three relevant and appropriate scholarly articles that address the topic you chose.Present a thorough literature review of the three articles by summarizing, synthesizing, and evaluating the materials.Incorporate citations into your body para..

Reviews

len1418661

3/8/2017 1:35:50 AM

This project is to get familiar with one noSQL DB: MongoDB. I would like to see some screenshots that shows your work. Students can use snipping if it is in Windows to capture screenshots and paste them into word doc. A screenshot with CMD (may need to run as an administrator) which shows the result of typing PATH and mongo.

Write a Review

Database Management System Questions & Answers

  Find the start and end dates of cruise number

Write SQL SELECT commands to answer the following queries. Find the start and end dates of cruise number 35218. List the names and ship numbers of the ships built by the Ace Shipbuilding Corp. that weigh more than 60,000 tons.

  List full details of all hotels

List full details of all hotels

  Compute the total time to transmit the entire data file

Compute the total time to transmit the entire data file. Compute the effective throughput of the system.

  Prototyping part of a database systems application

The assignment comprises designing and prototyping part of a database systems application. Students should form themselves into groups of up to 4 members and pass details of the members of their group to the course leader.

  Describe some typical pairs of entities

Describe some typical pairs of entities that you think might be common in business, and describe their relationships, whether many-to-many, one-to-many, many-to-one, or one-to-one. Explain why you think that a particular relationship applies to th..

  Create a data model of process showing entity associations

Identify the valid entities, and explain why the rejected entities should no be modeled and create a data model of the process showing entity associations.

  Write sql statement to retrieve all data sorted in order

Generate the view called RepairSummary which shows only RepairInvoiceNumber, TotalCost, and TotalPaid. Illustrate the SQL statement to retrieve all RepairSummary data sorted by TotalCost.

  Define denormalization of a database schema be used

Under what situations would denormalization of a database schema be used? Give examples of denormalization.

  Design the database using the er approach

Design the database using the ER approach and then create the tables accordingly. Populate the tables

  Design a database to track the company products

Design a database to track the company's products and orders. Choose either an open-source product or a proprietary product to use, and explain your reasons for choosing it. Identify some of the characteristics of database configuration used in yo..

  Analyze the data in at least three different ways

Analyze the data in at least three different ways. Each form of Data Analysis should be provided on a separate, appropriately labeled worksheet. It is expected that each sheet will be professionally formatted and clearly documented with titles, co..

  Design and develop an it help desk system

The system has to be Web-based system using Design interface of the system using visual basic.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd