[SOLVED] database Database Design Test

Database Design Test

ATDMeals: Design a database to support a meal delivery service. ATDM will deliver ready to eat meals within a 2mile radius of the campus. This is intended for busy associates and others who dont have time to cook, or who want to have friends over for dinner. Your application will support the order and payment processes. Each day there will be five different complete menus available. A customer can order only the fixed meals; no substitutions of dishes are allowed. An order consists of a number of meals, each of which can be chosen from any of the five menus available. Customers can order online or they can order over the phone. Payments are by PayPal, collected by the delivery person using a smart phone.

Coding Test
Problem Statement
For the following problem please write and document a complete solution. You will not be expected to execute them in the interview, however they must be well documented and you should be prepared to review your solutions during the followup interview. Provide a onepage explanation of your architectural choices.
Write code to accomplish the following steps. The languages and packages you use to accomplish this are your choice:
Read two datasets
Static, but can change over timeCode must watch for new versions of data

Second is realtime
Live data is from MySQL.
Data sources must be joined in realtime for each message
Apply transformations
Compute a new dataframe:
the total number of transactions for each ITEM each week
the average weekly transactions for each ITEM
Apply a prediction with live data
Use linear regression model for next week transaction prediction
Persist results to a database and csv
Column Headers are:
DCCODE,
ITEMNUMBER,
CURRENTAVGWEEKLYTRANSACTIONS, PREDICTEDNEXTWEEKTRANSACTIONS

Make your best attempt to solve all parts of the problem.
Data Description:
Static Data:Filenamestaticdata.csvColumnsITEMNUMBER, DCcode, DClocation

Live Data:
Filenamelivedata.csvColumnsTASKID, ITEMNUMBER, DESCRIPTION, TRANSACTIONQUANTITY, TIMESTAMP

Confidentiality. All knowledge and information, not already available to the public, which you acquire, have acquired, or will acquire in the course of the interview process with the Company with respect to the Companys business, work methods, or pending regulatory matters, or other Company matters that are treated by the Company as confidential, shall be regarded by you as trade secrets, whether or not they are classifiable legally as trade secrets, and shall be treated by you as strictly confidential. Such knowledge and information shall not either directly or indirectly be used, disclosed, or made accessible to anyone by you for any purpose, except in the ordinary course of the Companys business under circumstances in which you are authorized to use or disclose such information. No disclosures of such confidential information shall be made outside of those you are authorized to make in the regular and ordinary course of your duties unless and until you receive prior written permission of the Board of Directors of the Company to make such disclosure.