BC2402 Designing and Developing Databases Assignment Case – A simple clinic & Amazon Prime, Singapore

Week 8 Class Exercises – Basic Create Operations

Case: A simple clinic

Consider the following sample document (database = simple Clinic, collection = patients):

Required:

1. Create the above database and collection.
2. Insert the above document into the collection.
3. Insert 3 additional patient records (documents) with at least 1 history entry per patient.
4. Test out your database with find().
5. Find all patients who are older than 30 years old (or a value of your choice).
6. Delete all patients who got a flu as a disease.

Case: Amazon Prime

Amazon Prime is a paid subscription program from Amazon that gives users access to additional services otherwise unavailable or available at a premium to regular Amazon customers. Services include same, one or two-day delivery and streaming music and video. In January 2020, Amazon reported that Prime had more than 150 million subscribers worldwide.

During May 2020, Amazon.com had over 2.5 billion combined desktop and mobile visits, up from 2.01 billion visits in February 2020. The platform is by far the most visited e-commerce property in the United States.

Some fun facts about Amazon

1. 9 out of 10 consumers price check a product on Amazon.
2. Amazon sells more than 12 million products.
3. 95 million people have Amazon Prime memberships in the US.
4. $1.4K is the average spent by Amazon Prime members each year.
5. Amazon shipped over 5 billion items worldwide in 2017.

ERD

Sample Records

Required:

1. Create a MongoDB to capture the above records (database name = amazonPrime). You can use a maximum of 3 collections.
2. Insert the records in the above tables into documents in each collection. You must observe the relationships depicted in the ERD, either by reference or embedded documents.
3. Give a brief justification on your data model in a word document.