Discuss the benefits and potential drawbacks

Assignment Help Computer Engineering

Reference no: EM133626880

1 Design a NoSQL Schema:

AudioStream from Assessment 1 has a requirement to create a NoSQL database for streamlined read access. The data to be modelled is as follows:

Artists: Each artist has a unique ID, name, and may have other details like biography, birth date, etc.

Albums: Each album has a unique ID, name, release date, and is associated with a specific artist.

Songs: Each song has a unique ID, name, duration, and is linked to an album.

Reviews: Each review has a unique ID, is linked to a specific song, and includes details like the

review content, reviewer name, and review date.

a) Design a NoSQL (consider a document-oriented database like MongoDB for this task) schema for storing the above data. Your design should take into consideration the typical operations the application will need to perform, such as:

Retrieving all songs by a specific artist.

Retrieving all reviews for a specific song

Adding a new review for a song.

Updating the details of a song or an artist.

b) Data Modeling: Create sample data for artists, each with albums, and songs with reviews; pictorially depict how the data will be represented in the database.

c) Consider that you are going to be using Azure Cosmosdb for this case; peruse the following documentation

Retrieve all albums of an artist by artist name.

Retrieve all reviews of a song by song name.

d) Discussion: Discuss the benefits and potential drawbacks of your database design. For example, you could consider aspects like scalability, ease of querying, data redundancy, and so forth.

Reference no: EM133626880

Questions Cloud

State your greedy choice and prove its correctness : Given a set of black and white intervals, select a smallest number of white intervals that collectively overlap every black interval. State your greedy choice

What factors influence course of infection : How does infection start, and what is usual course? What factors influence course of infection? Give specific examples of different trajectories of infection.

Capturing system memory of machines in this network : The network consists of only Windows machines. Assess the tools that the analyst could employ in this process for capturing system memory of machines

Issue of reproducibility and reliability in RAPD analysis : How can you address the issue of reproducibility and reliability in RAPD analysis, given that the technique is sensitive to factors like template DNA quality

Discuss the benefits and potential drawbacks : Discuss the benefits and potential drawbacks of your database design. For example, you could consider aspects like scalability, ease of querying

Introduction of bacteria into the urinary tract : Sterile technique is crucial when inserting a catheter because it helps prevent the introduction of bacteria into the urinary tract, which could lead to infecti

How could josies death have been prevented : With those contributing factors in mind, how could Josie's death have been prevented, and what process changes would you recommend to avoid a similar tragedy?

Creating a procedure that uses a stack frame : Creating a Procedure that Uses a Stack Frame When we first learned how to create procedures, we used registers to hold the procedures

What is impact of integrating oral health : What is the impact of integrating oral health with primary care on the quality and availability of dental services?

User Account

All Pages