Trying your hand at creating a data model - An exercise 
The gadget spec URL could not be found



At this point, we have created the category model, product model, product colour model and product size model, and established the necessary relationship between these models. We just to have create the customer orders model and product orders model under orders menu folder, and establish a parent/child relationship between these model to complete the data model for our example application. This is a do-it-yourself exercise - hints are provided for reference.


  Orders Menu: CustomerOrders, ProductOrders data models



   CustomerOrders
   
Create the customer orders model under orders menu. The customer orders model must have the following parameters.
  • OrderID, "Text"
  • OrderDate, "Date"
  • CustomerID, "Text"
  • OrderStatus, "Text"
  • OrderAmount, "Number"
  • TotalItemsOrdered, "Number"
   



   ProductOrders
   
Create the product orders model as the child of customer orders under orders menu. The product orders model must have the following parameters.
  • OrderID, Parent/child reference to customer orders model
  • CategoryDescription, "Text"
  • ProductDescription, "Text"
  • ProductPrice, "Number"
  • ProductColour, "Text"
  • ProductSize, "Text"
  • Quantity, "Number"
  • Amount, "Number"