Reference no: EM132767452

ADDD301 Advanced Database Design and Development - Kent Institute

Learning Outcome 1: Demonstrate the difference between Relational and Non-Relational Databases and have knowledge to design large scale and multi structured databases.

Learning Outcome 2: Design Non-Relational Databases

Learning Outcome 3: Build a Non-Relational database

Learning Outcome 4: Apply queries on a Non-Relational Database.

Assessment Task - The assessment is about design and implementation of a document database.

ASSESSMENT DESCRIPTION:

This assessment is an individual design and implementation of a document database.

A company called MediaStore has asked you to design a data store comprising of media files. Media files could be audio CDs and movie DVDs.
With Audio CDs, your client wants to maintain the records with productId, type, title, price, artist, genre, date of release and tracks. With Video DVDs, most of the attributes remain same apart from artist and tracks. With DVD's they want the store to have information about the actors, directors, writers and producers in place of artist. There will be no track attribute in DVD entity. Note that certain attributes can have more than one values associated. Please choose the structures accordingly.

Since MediaStore frequently ships the items to customers, they want to store shipping information of each product too. This usually dimensions and weight, i.e., width, height, depth and weight.

The company has also informed you that media is usually searched based on artist/actors for CDs/DVDs. Sometime they like to search the films/dramas based on writer's or director's name. Some customers are interested to search media based on their favourite Genre.

1. Using given information design the CD and DVD documents using JSON notation.

2. Decide whether you want to put the shipping related information i.e., weight and dimensions in the CD/DVD documents or in a different document.

3. Create a database called mediaStore and create a collection called mediaProducts that can hold documents of media type audio and video as described earlier.

4. Decide what fields should be used for creating index and create at least two indices on appropriate fields.

5. Apply following find queries:
a. Finds all documents
b. Finds documents that satisfy any one search condition.
c. Finds documents that satisfy more than one search conditions using or operator.

6. Apply a sort query in descending order on title.

7. Update weight field of any one CD.

8. Drop the index on any one of the fields that you have created in Question 3.

The associated report should have following structure:
1. Title Page
2. Executive Summary
3. Introduction
5. Case Study and the Design
Normalization/Denormalization
6. Documents
7. Creation of Database and Collection
8. Queries
Find
Index
Sort
Update
7. References

Attachment:- Advanced Database Design and Development.rar