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

  Prepare a dfd and context diagram for the system

Journal entries have to be reconciled with the spreadsheet on a daily basis - Prepare a context diagram for the system and also prepare a diagram 0 DFD for the system

  Construct an entity-relationship model for the database

Construct an entity-relationship (ER) model for the database. Make sure you include in your model details of entities, relationships, attributes, keys and limits in participation.

  Relations of airline flight information

The relations given below keep track of airline flight information:Flights(flno: integer, from: string, to: string, distance:integer, departs: time, arrives: time, price: real)Aircraft(aid: integer, aflame: string, cruisingrange: integer)

  Describe the data obtained through the observations

Describe the data obtained through the observations. Charts, diagrams, or other visual depictions of your data may be included.

  Difference a database administrator and a database architect

Describe the differences between a database administrator and a database architect. How is your organization structured to handle the functions of these roles

  Design and develop a database using professional principles

Design and develop a database using professional principles and standards.

  Produce different final database state than using trigger

Assume that relation Employee has no tuples in it initially. You are to show the simplest example you can think of where using trigger T1 will produce a different final database state than using trigger T2.

  Provide the sql code that inserts data into all of the table

Provide the SQL code that inserts data into all of the tables

  Why you think the w3c is important in the world of databases

Visit the W3C Web site and look at the information under Mission (http://www.w3.org/Consortium/mission). Discuss why you think the W3C is important in the world of databases.

  Justify a question on database management

When a student has not chosen a major at a university, the university often enters a value of "Undecided" for the major field. Is "Undecided" a way to represent the null value? Should it be used as a default value? Justify your answer carefully.

  1 not having an appropriate index can cause a full table

1. not having an appropriate index can cause a full table scan while performing the select statement by using a

  Process of creating the entity-relationship diagrams

Create documentation that explains the process of creating the entity-relationship diagrams in the change request relative to this project.

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