Lab Test(Aiman Syakir) PDF

Preview

Summary

TOTAL MARKS : 23 MARKSISP610 LAB TEST (10%)Instrucions:a. Please write the query under the designated quesion b. Then, capture the response from MongoDB and paste it according to quesion number c. Save the ile name using your full name d. Then upload it through google classroomUsing MongoDB,a. Creat...

Description

TOTAL MARKS : 23 MARKS ISP610 LAB TEST (10%) Instructions: a. b. c. d.

Please write the query under the designated question Then, capture the response from MongoDB and paste it according to question number Save the file name using your full name Then upload it through google classroom

Using MongoDB, a. Create a NoSQL database called “kfcyumm”. - Query use kfcyumm

(2 Marks) b. Create collections for all menu under “biasa” (refer to the above image). Note: Don’t use space in the collection name. - Query db.createCollection('Pasti Puas'); db.createCollection('A La Carte & Value Meals'); db.createCollection('McCafe'); db.createCollection('Sampingan'); db.createCollection('Pencuci Mulut'); db.createCollection('Minuman');

TOTAL MARKS : 23 MARKS db.createCollection('Happy Meals');

(7 Marks) c. List all collections that have been created in question b. - Query show collection

(2 Marks) d. Create combo under collection “PastiPuas” (refer the above image). -Query db.PastiPuas.insert([ {id:"ssMC",meal:"McChicken",nugget:4,side:"Apple Pie",price:13.99}, {id:"ssGCB",meal:"GCB",nugget:4,side:"Apple Pie",price:17.99}, {id:"ssSCMD",meal:"Spicy Chicken McDeluxe",nugget:4,side:"Apple Pie",price:17.99}, {id:"ssAGS",meal:"AG Spicy",nugget:4,side:"Apple Pie",price:17.99}, ]);

(8 Marks)

TOTAL MARKS : 23 MARKS

e. Update price for combo 1. Change it to RM15.99

- Query db.PastiPuas.update({id:"ssMC"}, {id:"ssMC",meal:"McChicken",nugget:4,side:"Apple Pie",price:15.99} );

(2 Marks) f.

Display new information for the updated combo in question d. -Query db.PastiPuas.find().pretty();

(2 Marks)...