Can I get the answer to these question. Answer should be according to the marking guide
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 5.1 Normalization/Denormalization 6. Documents 7. Creation of Database and Collection 8. Queries 8.1 Find 8.2 Index 8.3 Sort 8.4 Update 7. References Comments MARKING GUIDE (RUBRIC): Marking Criteria Lecturer Expectation Marks Design of JSON Students understand the requirements from 7 documents given scenario. They are able to choose correct structures for the documents Creation of database Students have the knowledge of how to 2 and collection create databases and collections Decision of shipping Understanding where to use joins or 4 information dernormalization. Creation of Indices Showing an understanding where indexes 4 should be applied and how to create them Find Queries Showing a detailed understanding of find 6 commands. The use of conditional operators within find command to retrieve different documents Sort and Update Showing the skill to apply updates and sort 5 appropriately Drop Index Skills on how to remove indices 2 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 5.1 Normalization/Denormalization 6. Documents 7. Creation of Database and Collection 8. Queries 8.1 Find 8.2 Index 8.3 Sort 8.4 Update 7. References Comments MARKING GUIDE (RUBRIC): Marking Criteria Lecturer Expectation Marks Design of JSON Students understand the requirements from 7 documents given scenario. They are able to choose correct structures for the documents Creation of database Students have the knowledge of how to 2 and collection create databases and collections Decision of shipping Understanding where to use joins or 4 information dernormalization. Creation of Indices Showing an understanding where indexes 4 should be applied and how to create them Find Queries Showing a detailed understanding of find 6 commands. The use of conditional operators within find command to retrieve different documents Sort and Update Showing the skill to apply updates and sort 5 appropriately Drop Index Skills on how to remove indices 2
