5.10. Exercises
1. It is usual to provide a separate update event for every attribute in a database, with the possible exception of those that can change a primary or foreign key. In the case of the Academic Records System , which attributes do you think should be allowed to be updated, and which should not?
2. Specify an event that will set the value of Phone, and a second event that will allow it to be restored to null.
3. It is proposed to allow candidates to protect their data using passwords. Passwords are usually stored in encrypted form, in this case, as an integer. Specify an FD that allows each candidate to store an encrypted password. Assuming that you already have an encrypt function available, specify an event to check the correctness ...
Get Systems Analysis and Synthesis now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
