How would the following ERD be changed to incorporate the design decision listed next?

• The analyst wants to keep track of the user ID of anyone who changes a grade for a course.

• A data store is added on the physical DFD so that information regarding the current semester’s courses can be stored temporarily during the add/drop period before the courses become a part of the student’s permanent record.

• The system would like to archive alumni into a table, once they graduate, so that only active students are stored in the student table.

Answer rating: 100% (QA)

The analyst wants to keep track of the user ID of anyone who changes agrade of a course Keeping file... View the full answer