With the following basic database information: FARMERS MARKET DATABASE • Farmers input what PRODUCE their FARMS will send to market and when. • CUSTOMERS see what PRODUCE they can ORDER at the market and • CUSTOMERS will be able to place ORDERS for PRODUCE at the market. Outputs/views • What PRODUCE is available for ORDERS on a certain date/time. • Classify FARMS by regions and show the average amount of each PRODUCE sold on an ORDER this year for that region. • Show the ORDERS, and each ORDER TOTAL for each CUSTOMER so far this year. • Show the most recent ORDER to fill with at least 2 or more types of PRODUCE. • Show a list of available PRODUCE and the expiration dates. Create a normalization to 3NF diagram, including functional dependencies drawn Create a relational algebra for view, query and function designs
With the following basic
FARMERS MARKET DATABASE
• Farmers input what PRODUCE their FARMS will send to market and when.
• CUSTOMERS see what PRODUCE they can ORDER at the market and
• CUSTOMERS will be able to place ORDERS for PRODUCE at the market.
Outputs/views
• What PRODUCE is available for ORDERS on a certain date/time.
• Classify FARMS by regions and show the average amount of each PRODUCE sold
on an ORDER this year for that region.
• Show the ORDERS, and each ORDER TOTAL for each CUSTOMER so far this year.
• Show the most recent ORDER to fill with at least 2 or more types of PRODUCE.
• Show a list of available PRODUCE and the expiration dates.
Create a normalization to 3NF diagram, including functional
dependencies drawn
Create a relational algebra for view, query and function designs
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
