Database Management System Project
Description
Unformatted Attachment Preview
Database Management System
mark: 20
Weightage: 6%
Create following table in MongoDB using appropriate command (4 Marks):1. Shoes
ModelNo
Brand
M2101
M202
M303
Nike
Adidas
Puma
Color
Price
Size
Height
Width
10cm
1.5cm
8cm
2cm
8cm
2cm
Red, Black 100
Blue
80
Red, Black, 75
Neon
M404
Adidas
Orange
25
10cm
3cm
2. Update Brand name from Adidas to Puma in MongoDB for the very first
matching record. (2)
3. Insert one more brand info of your choice. (2)
4. Print all (display) shoes which are available in blue color and Width 2cm. (2)
5. Print all shoes which are available either in Blue or Neon Color using $in
expression. (2)
[please note: Query will be graded zero if $in is not used for criteria matching.]
6. Print only those brands of shoes which are in price range from 20(inclusive) to
80(inclusive). (2)
7. Delete all records for Adidas brand from this collection. (2)
8. Update Height for Nike Shoes to 12cm. (2)
9. Drop Shoes collection. (2 Marks)
Submission:
Submit only one word file
The file should include question#, code, screen shot of code and output.
[Please Note – Without Output screenshot Marks would be reduced to half]
Purchase answer to see full
attachment
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."