Database with PL-SQL functions/procedures/triggers. Oracle DB has been used with Oracle SQL Developer.
Adding a function to track the number of book not returned.
Adding a procedure to handle the insertion of one borrow based on sysdate for the creation date and respectively his detail in detailsemprunts table. Adding a sequence to handle the next value for the insertion of the borrow in the table emprunts
Adding a function to track members activity.
Adding a function to retrieve the limit date that for which a member could still borrow a book.
Adding a new virtual column FinAdhesion in Membres table.
Adding PL/SQL Procedure to update exemplaires table.
Adding T-SQL Script to update Exemplaires table.
Inserted new values in DetailsEmprunts table based on sysdate.
Adding T-SQL Script to change the etat value in emprunts table according if in the detailsemprunts the book has been returned or not.
Adding constraint check on etat in emprunts table.
Adding a new column ETAT in Emprunts table and added default value EC in it.
Inserted values in the tables.
Adding of Trigger for the sequence of Membres table.
Adding of Sequence for autoincrement Membres table.
Adding of SQL scripts for creating the tables.