Project Description
IS 680: Section 01, Spring 2020 Project Description
The course project of IS680-01 2020 spring is to take the business rule descriptions and application requirements in Homework 5 and 6, which is summarized below, and implement the data structures and functionalities in the chosen NoSQL database (in this semester the MongoDB).
▪ Customers make purchases by placing orders.
o Each customer has a customer number and profile (such as name, shipping address).
▪ To simplify the matter, each order can contain only one item.
▪ The company maintains hundreds of products at various warehouses throughout the United
States.
o Each warehouse has a warehouse code, address and phone number.
▪ When an order is fulfilled, the operator then updates the status to “shipped” for that order as well as the shipped date for tracking purpose.
▪ The company keeps track of products carried in various warehouses and their current inventory level.
Like in homework 5, you are responsible to determine the data structures in the MongoDB that will hold your operational data (likely in json format) and implement the required operations (insert/update/delete and queries) listed in the homework 6. Since this is a database management course, we will limit the scope of the project to core data-handling.
There are two ways to achieve the above objectives, web UI or command line. However, in either case, you need to demonstrate the following sequences of operations.
o Creating a new order with appropriate attributes
o Shipping the order with appropriate updates
o Look up an order
o Display the sales report that includes total orders/quantities/amounts for each product. o Display any existing open orders sorted by longest days open.
▪ If you are using the command line (which is recommended), submit the list of commands you used to achieve that (with the output result). You can cut and paste the entire result from command line and save them into a document (doc/pdf etc.) and submit the document to the project dropbox.
▪ If you are using the web UI, you may need to capture the screen shots as you progress. Please make sure you also capture the filter/command as well as any output result. In the end, prepare a document with all the screenshots and any description you want to have and submit the document to the project dropbox.
Due: May 9, 2020 4:00 PM dropbox project