Exam IIBA-CBDA topic 1 question 70 discussion

To avoid redundancies in the `Order` entity, attributes should be normalized to ensure that related data is stored in separate tables and redundancies are minimized. Typically, you would normalize by separating entities into distinct tables where data is repeated or has multiple occurrences. In this context, you need to consider attributes that would cause redundancy if included in the `Order` entity: 1. `OrderDate`: This should be kept in the `Order` table as it pertains to the order itself. 2. `ItemId`: This identifies the item and should be a foreign key to a separate `Item` table to avoid redundancy. 3. `ItemName`: This should be in the `Item` table, not in the `Order` table, to avoid redundancy since the item name is associated with `ItemId`. 4. `Quantity` and `ItemPrice`: These are related to the specific item ordered and are specific to the `OrderItem` relationship.