Finally, create and populate a table to hold the ingredients that you need to buy. Table should look like this: Ingredient Ingredientld Area IngredientName Areald Arealiame 1 Eggs 2 Flour 3 Margarine 4 Sugar 5 Mince Ingredient Areald. Recipeld Sponge cake 2 Baking Baking Dairy Baking Meat Note that in this case Quantity will be a text field. **For the first field just rename the given ID column title, no need to insert new column. Then, apply referential integrity to your relationships: Ingredientid IngredientName Areald Recipeld Quantity Sponge cake 4 ounces Sponge cake 4 ounces Sponge cake 4 ounces Lasagne Half pound Quantity Recipe **Relationships can be found in the Database Tools Tab. When you have finished, SAVE your work and Close your database. Recipeld Recipelame This is what the final Relationship Diagram should look like.

New Perspectives on HTML5, CSS3, and JavaScript
6th Edition
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Patrick M. Carey
Chapter12: Working With Document Nodes And Style Sheets: Creating A Dynamic Document Outline
Section: Chapter Questions
Problem 4CP4
icon
Related questions
Question

Please assist with completing the task using Microsoft Access in the attached screenshots. Please provide a step by steo guide.

M Inbox ( x
Answe x
→ CA
M Gmail → Unicaf University...
= Final.pdf
Free Ci x
Conflic x
UNICAF - Portal Pr...
UU-CC X
zm-vle-uu.unicaf.org/pluginfile.php/766725/mod_resource/content/3/Final.pdf
British x
Exif Editor m Free Premiere Pro... V VEED CREATE | Edit
6 / 6
Area
GEO to X
Ingredient
Ingredientid IngredientName
-
1 Eggs
2 Flour
Areald
AreaName
Finally, create and populate a table to hold the ingredients that you need to buy. Table should
look like this:
3 Margarine
4 Sugar
5 Mince
75%
00
Ingredient
Final.p x
+ »
Areald - Recipeld - Quantity
Baking
Baking
Dairy
Baking
Meat
Note that in this case Quantity will be a text field.
**For the first field just rename the given ID column title, no need to insert new column.
Then, apply referential integrity to your relationships:
Ingredientid
IngredientName
Areald
Recipeld
Quantity
Sponge cake 2
Sponge cake 4 ounces
Sponge cake 4 ounces
Sponge cake 4 ounces
Half pound
Lasagne
TẬN TÂN VẬT MẶT TẬT TẬT MẬT MẶT TẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT Nghi nghi
Recipe
This is what the final Relationship Diagram should look like.
**Relationships can be found in the Database Tools Tab.
When you have finished, SAVE your work and Close your database.
Recipeld
RecipeName
Enforc x
******** ATTENTION********
YOU SHOULD SUBMIT ONE (1) DOCUMENT AND ONE (1) FILE:
1) One Document with the Multiple Choice and Essay - Questions Answers.
2) One Access files of your answers from the Practical Exercise Section.
ATTACH THE MICROSOFT ACCESS DATABASE FILE WITH THE
EXTENTIONS (.ACCDB OR .MDB) WITH THE REST OF YOUR
EXAMINATION
HÂN HÂN HÂN HÂN HÂN HÂN HẬN
关关关关关关关关关关关关关关关关关关关关关关
End of Creating a Database (Practical Exercise)
1 (1) Wh
x
¯¯
Q
invalid X
□
Gscreen x
■
+
Finish update
↓
All Bookmarks
Transcribed Image Text:M Inbox ( x Answe x → CA M Gmail → Unicaf University... = Final.pdf Free Ci x Conflic x UNICAF - Portal Pr... UU-CC X zm-vle-uu.unicaf.org/pluginfile.php/766725/mod_resource/content/3/Final.pdf British x Exif Editor m Free Premiere Pro... V VEED CREATE | Edit 6 / 6 Area GEO to X Ingredient Ingredientid IngredientName - 1 Eggs 2 Flour Areald AreaName Finally, create and populate a table to hold the ingredients that you need to buy. Table should look like this: 3 Margarine 4 Sugar 5 Mince 75% 00 Ingredient Final.p x + » Areald - Recipeld - Quantity Baking Baking Dairy Baking Meat Note that in this case Quantity will be a text field. **For the first field just rename the given ID column title, no need to insert new column. Then, apply referential integrity to your relationships: Ingredientid IngredientName Areald Recipeld Quantity Sponge cake 2 Sponge cake 4 ounces Sponge cake 4 ounces Sponge cake 4 ounces Half pound Lasagne TẬN TÂN VẬT MẶT TẬT TẬT MẬT MẶT TẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT MẬT Nghi nghi Recipe This is what the final Relationship Diagram should look like. **Relationships can be found in the Database Tools Tab. When you have finished, SAVE your work and Close your database. Recipeld RecipeName Enforc x ******** ATTENTION******** YOU SHOULD SUBMIT ONE (1) DOCUMENT AND ONE (1) FILE: 1) One Document with the Multiple Choice and Essay - Questions Answers. 2) One Access files of your answers from the Practical Exercise Section. ATTACH THE MICROSOFT ACCESS DATABASE FILE WITH THE EXTENTIONS (.ACCDB OR .MDB) WITH THE REST OF YOUR EXAMINATION HÂN HÂN HÂN HÂN HÂN HÂN HẬN 关关关关关关关关关关关关关关关关关关关关关关 End of Creating a Database (Practical Exercise) 1 (1) Wh x ¯¯ Q invalid X □ Gscreen x ■ + Finish update ↓ All Bookmarks
M Inbox ( x
Answe x
→ cn
M Gmail → Unicaf University...
= Final.pdf
Free Ci x
Conflic x
UNICAF - Portal Pr...
UU-CC X
British x
zm-vle-uu.unicaf.org/pluginfile.php/766725/mod_resource/content/3/Final.pdf
Exif Editor m Free Premiere Pro... V VEED CREATE | Edit
5 / 6
A
Area
GEO to X
+
+
+
+
+
PART C: Creating a Database (Practical Exercise)
In this part, you have to create your own database. Please follow the instructions below.
This part will worth 25% of your Final Examination Result. DO NOT FORGET to attach
your Microsoft Access Database file when you finished.
Create a new database called Recipes.
Create a new table to hold the different supermarket areas from which you can buy ingredients.
When you have defined the fields, enter data as shown below:
75% +
Areald .
Recipe
AreaName
Recipeld
1 Meat
2 Dairy
3 Baking
4 Fruit and vegetables
5 Local market
6 Grocery
7 Other
Final.p x
H
Your table should contain two fields, as shown above
**For the first field just rename the given ID column title, no need to insert new column.
Close this table down, then create another table called Recipe to hold your favorite recipes (if
you haven't got any, make them up!). Here is what this might look like:
RecipeNami.
1 Sponge cake
2 Lasagne
(New)
Enforc x
Here we will add the ingredients for two recipes, but feel free to choose different ones
**For the first field just rename the given ID column title, no need to insert new column.
1 (1) Wh
x
¯¯
invalid X
□
Gscreen x
■
+
Finish update
↓
All Bookmarks
Transcribed Image Text:M Inbox ( x Answe x → cn M Gmail → Unicaf University... = Final.pdf Free Ci x Conflic x UNICAF - Portal Pr... UU-CC X British x zm-vle-uu.unicaf.org/pluginfile.php/766725/mod_resource/content/3/Final.pdf Exif Editor m Free Premiere Pro... V VEED CREATE | Edit 5 / 6 A Area GEO to X + + + + + PART C: Creating a Database (Practical Exercise) In this part, you have to create your own database. Please follow the instructions below. This part will worth 25% of your Final Examination Result. DO NOT FORGET to attach your Microsoft Access Database file when you finished. Create a new database called Recipes. Create a new table to hold the different supermarket areas from which you can buy ingredients. When you have defined the fields, enter data as shown below: 75% + Areald . Recipe AreaName Recipeld 1 Meat 2 Dairy 3 Baking 4 Fruit and vegetables 5 Local market 6 Grocery 7 Other Final.p x H Your table should contain two fields, as shown above **For the first field just rename the given ID column title, no need to insert new column. Close this table down, then create another table called Recipe to hold your favorite recipes (if you haven't got any, make them up!). Here is what this might look like: RecipeNami. 1 Sponge cake 2 Lasagne (New) Enforc x Here we will add the ingredients for two recipes, but feel free to choose different ones **For the first field just rename the given ID column title, no need to insert new column. 1 (1) Wh x ¯¯ invalid X □ Gscreen x ■ + Finish update ↓ All Bookmarks
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Class
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning