You will use the scenario attached with this question which also has the required list included with comprehensive entity/attribute list that was created in the scenario.

1. Organize entities, characteristics, and relationships into a normalized list. Every entity:
2. Review and revise the original list of characteristics that characterize elements crucial to the organization in in scenario attached.
3. Check to see if any of these characteristics are natural unique identifiers (like an ISBN number) or if the object needs a random primary key (like Employee ID).
4. The list of qualities from the attached scenario should be changed. The attributes should be adequate to cover every information item listed in the requirements list as well as any additional items deem significant after looking over the project scenario attached.
5. For each entity, choose a primary key (a unique identifier) and, if necessary, a foreign key.
6. Verify that the third normal form is used for each entity (3NF). To determine whether an entity has repeating groups (1NF), whether its complete primary key (2NF) determines every attribute, and whether no non-key attribute may influence the value of another non-key attribute (3NF). If necessary, divide entities into two or more entities.

Lastly: 

1. Help me create UML class diagram  (Note: Every entity corresponds to a single class.)
2. Determine the connections between the classes.
3. Choose the appropriate notation to indicate the cardinalities of each relationship in the diagram, indicating whether the link is one to one, one to many, or many to many.
4. Determine the relationship's modality in the diagram using the appropriate notation, indicating whether it is a necessary relationship that always occurs between the two entities or an optional relationship that only exists under certain circumstances. Justify the rationale behind each relationship's modality.
5. a rundown of your reasoning for choosing each relationship's cardinality and modality.

Transcribed Image Text:

Product 10 (1 Product Name Product Catego Product 10 (1 Product Name Product Catego