The question is describes in the attached file below and the rubric is defined here.
Final Exam Assignment F20Final Exam Assignment F20CriteriaRatingsPtsThis criterion is linked to a Learning OutcomeBusiness RulesA list of business rules pertinent to your database (see previous assignments and worksheets for examples). Your business rules should describe:1) A minimum of five regular entities (feel free to add weak entities and use superclasses/subclasses if appropriate)2) A reasonable number of attributes of varying types for each entity3) A mixture of relationship cardinalities, depending on how you imagine your scenario. Just let the business rules describe “how it is”.30 ptsFull Marks0 ptsNo Marks30 ptsThis criterion is linked to a Learning OutcomeER DiagramAn ER/EER diagram modeling your database (use appropriate symbols, and don’t forget associative entities where appropriate). This will be based on the business rules you created, so make sure you’ve written clear rules! Note: You MUST use the notation/style taught in class. For example do NOT use “Visio” style notation that shows PK and FK.30 ptsFull Marks0 ptsNo Marks30 ptsThis criterion is linked to a Learning OutcomeNormalized RelationsA list of normalized relations (using the notation from class) that is based on your ER diagram. Be sure to include foreign keys, etc.30 ptsFull Marks0 ptsNo Marks30 ptsThis criterion is linked to a Learning OutcomeMySQL ScriptPrepare a MySQL script that creates your database, tables, and inserts a small sampling of made-up data. Test it out in MySQL before submission. If your script does not run properly, you will lose points.30 ptsFull Marks0 ptsNo Marks30 ptsTotal Points: 120