Data analysis design for blogs

Assignment Help Data Structure & Algorithms

Reference no: EM13767293

Data analysis

Consider the following H Base table design for blogs. On the website, logged in users (who all have a unique, integer user ID) may comment on blog posts.

	cf: meta		cf: comments
post11356	user: 3	content: ...	1: <uid, comment>	2: <uid, comment>
post11357	user: 7	content: ...
post11358	user: 5	content: ...	1: <uid, comment>
post11359	user: 3	content: ...	1: <uid, comment>	2: <uid, comment>

For each query below, state either YES or NO the schema is optimal for that query. If you state NO, re-design the schema (copy the table above and modify it, then explain in English what is different with the new schema) so it is optimal for that specific query.

a) Given a particular blog post, what are all of the comments associated with it?yes

b) What are the blog posts for a particular user?

c) What comments has a particular user posted?

d) Deleting a particular blog post and all related data.

Reference no: EM13767293

Questions Cloud

Write response paper of my pencils outlast their erasers : Write one page response of Emily Temple's article "'My Pencils Outlast Their Erasers': Great Writers on the Art of Revision."

Determine the magnitude of the angular momentum : The position vector of a particle of mass 2 kg is given as a function of time by r = (9 m) (i hat) + (3 m/s)t (j hat). Determine the magnitude of the angular momentum of the particle with respect to the origin at time 9 s. Answer in units of kg*m2/s

How does the concept of opportunity differ : In 200-300 words, how does the concept of "Opportunity" differ between white collar crime and ordinary street crime

Recommended dri from each of the food groups : Write a 1,250- to 1,450-word paper that addresses the following points about your 1-day food intake: Review your iProfile Journal, the dietary reference intake (DRI), and the iProfile Intake Spreadsheet. Does your dietary intake for the day you recor..

Data analysis design for blogs : Consider the following H Base table design for blogs. On the website, logged in users (who all have a unique, integer user ID) may comment on blog posts.

What steps might good health & life take to ensure : What steps might Good Health & Life take to ensure that going forward only authorized users access the data on its computers? Whose efforts those of the federal government or Good Health & Life are most important in securing the company's computer..

Internal and environmental factors : What internal and environmental factors influence your health-related behavior?

What is the difference between art and entertainment : What is the difference between art and entertainment? How has the commercial music industry affected the artistic integrity of popular musicians?

What is the bar''s angular acceleration : The 0.4kg slender bar and 1 kg disk released from rest in the position shown. if the disk roll, what is the bar's angular acceleration at the instant of release?

User Account

All Pages