Assignment 3 -- Complex Database Challenge -- Cookbot -- Teamwork is Optional but Advised !! |
|
---|---|
In this assignment I want you to design a database that can be used by a cooking robot (not a human chef) to prepare an indeterminate number of dishes. Your database is where the information for the dishes will be stored. | |
** Just A Note Up Front ** This is not a trivial challenge, so if you find yourselves creating a simple database, you are not on the right track. Here are some of the challenges you must accommodate with your design:
|
|
Hint: If you have had my AD-400 Project Management class, it might be helpful to take a non-trivial dish (something like lasagna) and put it into ProjectLibre just to get an understanding of the relationships involved. It may also help to load a recipe or 2 into the database. |
Hybrid Class Assignment - Normalization | |
---|---|
Make a copy of your robot cooking database (DO NOT DO THIS ON THE SAME COPY AS PART 1) | |
Break 4 (with respect to Normalization) of your tables in the following
fashion:
|
|
This is not intended to be a time consuming exercise. Look at my slides on each form of compliance and extrapolate the concept into one of your tables. Each non-compliant table should be mutually exclusive of the other forms of non-compliance -- Don't try to put 2 forms of non-compliance in the same table. |
Assignment Submission Criteria |
|
---|---|
To turn in this assignment you will go to the NSC Canvas shell for this
class. Submit:
|