The library System stores 3 type of informations:
1. Users ( USID, USNAME, USMob, USEmail, USDept,USStartDate, NofBooks)
2. Books ( BookSerNo, Title, Author,SubjectNo, Category, ISBNO, Publisher, Uprice, Qty,IsBorroed)
3. DailyTransactions (OpNo, USID, BookSerNo, Bordate, RetDate)
4. Departments (DepID, DepName, DeptOrder)
5. Subjects (SubjectNo, Description,SOrder)
Required:
• Create the library database schema Structure
• Insert 3 records in each table
• Write Update SQL statement to change the book status.