Project assignment

Project Part 3

The focus of this project is to design a back end database for the See’s Candies web site (or Ecommerce site of your chose from parts 1 & 2). Yes, I know we did that for Project Part 1. However……
I want you to design this as a document database, using MongoDB.
This type of schema will be very different from the underlying schema behind the Project Part 1. You should begin by reexamining that schema, but consider how limiting that original schema was, and how different your database design would be if you could capture data as order documents, rather than having to break orders down and store them as different rows in a whole group of normalized tables. The problem with the traditional database design is that to get all the information from a single order you would have to do a multi-way join on the underlying normalized database.
This project will begin with a simple use case, and continue with more complicated use cases.
Use Case 1: Please answer the following questions:
1) What data belongs together in an order document for a simple customer order from the sees web site?

2) Design a simple MongoDB collection to handle a customer who orders one item to be shipped to one address.
3) Create and test a script to create this collection in MongoDB, and to create a document that contains the following information about this sample order:
a. I wish to order a box of 1 lb box of Dark Nuts and Chews
b. Assume my address is the college mailing address at 11333 Big Bend, Information Systems Department, Kirkwood, MO 63124.
c. Assume the credit card I would use is a Visa, with number 8834 1111 2222 3333, an expiration date of 5/25, and a “secret” code of 321. Do not worry about verifying the validity of the credit card number.
d. Use my name as the name of the person placing the order.
e. Please submit this script.
Use Case 2: Please answer the following questions:
1. Design a MongoDB order database containing collection(s) and documents to handle a customer who orders multiple items to be shipped to one address.
2. Create and test a script to create this in MongoDB, and to populate it with information from a single customer who wants to order multiple items from sees.com that are all shipped to the same address. You can use the information from Use Case 1 for the first item ordered, but please vary the items for the second, third, and other items so different items are ordered. Please submit your script.
Use Case 3: Consider how you might expand your MongoDB collection(s) to handle customers who place orders to be shipped to multiple addresses. Would you create an additional collection, or would you create additional documents to handle the scenario of multiple shipping addresses? Explain your answer.