Question: Design a database using MongoDB to support the content management system of a blog. The database must store the following information: Articles: Page URL

Design a database using MongoDB to support the content management system of a blog. The database must store the following information:

 

  • Articles:
    • Page URL
    • Article title
    • Article ID
    • Page Content
    • Author name
    • Author email
    • Author picture URL
    • Author short bio
  • Comments
    • Each article can have 0 or unlimited number of comments
    • Content of comment
    • Date and time posted
    • Handle of comment poster
    • ID
  • Views and activity
    • User agent
    • Date and time
    • Description of event (view, like, share)
    • Type (comment, article)
    • Content ID

Deliverable:

 

  • Code to create the data to be inserted to the database
    • Insert at least 12 articles
    • Each article must have a random number of likes
    • Each article must have at least one comment
    • At least one comment must be liked
  • Query to aggregate and calculate:
    • Number of views per article
    • Average number of comments per article
    • Article ID of the most liked article

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Q:

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Q:

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

Q:

It is reported that 85% of Asian, 78% of white, 70% of Hispanic, and 38% of black children have two parents at home. Suppose there are 500 students in a representative school, of which 280 are white,...

Q:

Sharon Sutherland owned a home in Toronto, Ontario, a ski chalet in Whistler, BC, and a condominium in Florida, USA until June 15, 20X7 when she sold all three properties and moved into a seniors...

Q:

What is the Rule of 72?

Q:

For a certain make of a car, spare parts are produced by two manufacturers, A and B. The total production of the manufacturer B is n times as large as that of A. The proportions of defective spare...

Q:

Jay Simons, the accountant of See Co., wanted to buy a new computer software package for his general ledger. He couldnt do it because all funds were frozen for the rest of the fiscal period. Jay...

Q:

The accounts that will be used by Dad & Sons Moving Company follow. Office Supplies Accounts Payable Cash Salaries Expense Prepaid Rent Fees Income Utilities Expense Office Equipment Accounts...

Q:

One year ago, you purchased a 5 percent annual coupon, $1,000 par, 6-year bond for a clean price of $1,075. The bond now has 5 years remaining until maturity. Today, the yield to maturity on this...

Q:

Dolan Products is a small, family-owned audio component manufacturer. Several years ago, the company decided to concentrate on only three models, which were sold under many brand names to electronic...

Q:

ANOVA CASE STUDY The watch supervisor wants to know if there is a statistical significance between the working shift's productivity. The following data pertains: 4 PMMidnight 21 Midnight 8 AM...

Q:

the McKinsey Customer Decision Journey model of consumer behavior suggests that the best thing fter customers make a purchase is: Begin an ongoing and regular process of exposing them to the brand\'s...

Q:

B Remember to SAVE your work C D QUESTION 3-REVENUE VARIANCE ANALYSIS-Version C (25 marks) ABC Co. manufactures widgets and has the following operating Information for the past year: Product Line...

Q:

5. Use any method (including calculators!) to compute the following volumes. a) The region bounded by y = sin(x) and the lines y = 0, x = 0, and x = 2 rotated around the x-axis. b) The region bounded...

Q:

need help with doing these basic unix commands if somebody could show me how that would be awesome! Beginners guide to the UNIX / Linux operating system. Eight simple tutorials which cover the basics...

Q:

Assessing simultaneous changes in CVP relationships Braun Corporation sells hammocks; variable costs are $75 each, and the hammocks are sold for $125 each. Braun incurs $240,000 of fixed operating...

Q:

Write an SQL query using EXISTS to retrieve the supplier name and number of the supplier who has the lowest supplier number.

Q:

Contrast operational versus tactical versus strategic decision-making. Illustrate with examples in An online retail setting (e.g., Amazon, Netflix, eBay); A bank setting; A university setting.

Q:

Write an SQL query with ALL or ANY to retrieve the name of the product with the highest available quantity.

Q:

The symbols at and a2 represent the "favorable" and "unfavorable" assessment by the broker, and 5J, 52, and 53 represent, respectively, the up, same, and down change in future prices. (a) Draw the...

Q:

6. A school district is in dire need to reduce expenses to meet new budgetary restrictions at its elementary schools. Two options are available: Delete the physical education program (E), or delete...

Q:

9. TriStar plans to open a new plant in Arkansas. The company can open a full-sized plant now or a small-sized plant that can be expanded 2 years later if high. demand conditions prevail. The time...