Reference no: EM133027886

ICT320 Database Programming - University of the Sunshine Coast

Professional Electronics and Repairs Case Study

Assignment Requirements:

1. Justify your choices for the NoSQL Document data structures you selected for each attribute in the given relational schema (maximum 500 words). Explain why you chose each of the data structures and justify these choices with your sample data set (8 marks for Q1).

2. Create 10 distinct queries with MongoDB that uses the following methods and expressions. All output should be easily read, i.e. use .pretty. Each query must address a business requirement. For e.g. How many parts were used to repair a customer's device? (3 marks each).
I. $group and $sum
II. aggregate() and count
III. aggregate() and $first
IV. find() and regex
V. $group and $push
VI. aggregate(), $group and $sum
VII. aggregate(), $group, $sum and $sort
VIII. aggregate(), $group, $dateToStringand $sum
IX. aggregate(), $group, count and $match
X. aggregate(), $unwind, $group and $sum

Attachment:- Database Programming.rar