1. Read Page 371 to 378 from the text.
2. Use a ER modeling software such as https://www.dbdesigner.net/ to produce HSD database model
3. In your own words, describe the database design. (Hint – Use Fig 5.1 for “recipe” as a structure)
a. Explain in your own words the PK selection process.
b. Explain in your own words, the verifying of normalization.
c. For the column names for tables for each table. Show column name, data type, PK/FK, Null/Not Null. (So, four columns for each table). Simple table will suffice for each.
d. Explain in your own words, the relationships between the various tables and how foreign keys were setup. (What column was selected, what column goes where, why?)
4. Use a word document to capture your design specifications and produce them neatly. Your design should be logical, and, explanations coherent.
(Think, if your design is not clear, the person who is take the baton from you and implement will not be able to do so).
5. Upload to the Assignment 3 folder on Brightspace by due date.
Bonus 5pts if you do your own research and find a ‘free to use’ software for this purpose that works equally effectively.
