Using SQL Design a simple meal planning application that allows a user to plan their family meals for a week. You must provide the following functionality to the user:

a$.(10$ Points$)$ Allow a user to select a cookbook from a list of cookbooks

b$.(10$ Points$)$ Allow a user to select a recipe from a particular cookbook

c$.(10$ Points$)$ Allow a user to see what ingredients are needed for a particular

recipe

d$.(10$ Points$)$ Allow a user to assign a particular recipe to a particular day

Your program must make use of the application architecture principles we discussed in class:

$(10$ Points$)$ A presentation layer for interacting with the user

$$ Your program does not need to implement a graphical or web based front end,

but if you find that easier to manage then a text$-$based application, feel free.

$(10$ Points$)$ A business logic

$(30$ Points$)$ A DAL for interacting with the database

$$ A separate class for managing database access

$$ Data retrieved from the database must be parsed into data structures by the DAL

$$ Do not use Java ResultSets or Python Cursors outside the DAL!

$$ Your DAL may contain as many classes as you would like, keeping in mind that

each class should serve a distinct purpose

$(10$ Points$)$ All database access in the DAL must make use of stored procedures or

functions.

Page $1$ of $1$