Suppose we have a table and assumptions as follows: (every attribute is atomic)

SEMINARS (Seminar#, Title, Room, Seminar_Date, Seminar_fee, Instructor#, Instructor_Name, Honorarium, Student#, Student_name, Regsitration_date, Registration fee)

- A seminar has a fixed title and fee.

- Each seminar is always held in the same room, regardless of days offered

- A seminar is one-day long, but held many times over the period.

- Each seminar is always taught by the same instructor.

- One instructor may teach multiple seminars and receive a different honorarium for different seminars.

- A student can register a particular seminar that is held in a particular date.

- If you register 30 days early for a particular seminar, you pay an early-bird fee which is 20% cheaper than a regular registration fee.

- A student can register multiple seminars at different dates.

Give an example of the following anomaly from SEMINARS table. Use English

Insert

Update

Delete